Enter your first MarketXLS formula
Use a simple stock-price formula to confirm that MarketXLS works in your workbook.
Use a simple last-price formula to test your installation. The formula name differs between the two add-ins.
Test the Windows desktop add-in
- Open a blank workbook in desktop Excel on Windows.
- Select an empty cell.
- Enter
=Last("MSFT"). - Press Enter.
Capture the Windows MSFT Last formula in the formula bar with its returned value.
/images/docs/windows/first-formula.webp
Test the Microsoft 365 add-in
- Open a blank workbook on a Mac or in Excel for the web.
- Select an empty cell.
- Enter
=mxls.Last("MSFT"). - Press Enter.
Capture the Microsoft 365 MSFT Last formula in the formula bar with its returned value.
/images/docs/microsoft-365/first-formula.webp
The cell should return a value for Microsoft. The exact value depends on the market session, your subscription, and the data source available to the function.
Use a symbol from another cell
Put MSFT in cell A2. Then enter one of these formulas in B2:
| Add-in | Formula |
|---|---|
| Windows desktop | =Last(A2) |
| Mac or Excel for the web | =mxls.Last(A2) |
You can now replace the symbol in A2 without editing the formula.
Fix a test that doesn't return a value
- If Excel shows
#NAME?, help Excel recognize the function. - If the cell shows
NAor an unexpected value, check the symbol and data access. - If the MarketXLS ribbon is missing on Windows, restore the ribbon.
Next, learn how to use MarketXLS formulas or browse the formula reference.