Forum Discussion

Seshu1992's avatar
Seshu1992
Copper Contributor
Mar 14, 2020

Excel for mac - Stocks data doesnt work

I was never able to get the Share Price or any other fields auto fill in Excel for Mac. It works fine on Windows or Cloud based Excel but not on a macbook.        None of the options like P...
Excel on Mac
Need Help
DarthBoots's avatar
DarthBoots
Copper Contributor
Feb 08, 2026

Excel for macOS has significant limitations in retrieving global stock prices compared to Apple Numbers. The built-in Stocks data type and STOCKHISTORY() work reliably for some US equities but fail or are inconsistent for many non-US stocks, ETFs, and instruments across international exchanges. Identifier resolution is opaque, coverage is uneven, and there is no clear way to validate or extend the data source.

 

In addition, Excel for Mac lacks practical alternatives for market data ingestion: web services, GoogleFinance-style functions, and flexible web/API connectors are either unavailable or severely constrained compared to Excel on Windows or Excel for the web. This makes Excel for Mac unsuitable for globally diversified portfolios without external tools.

 

Improved global coverage, clearer ticker/exchange mapping, and parity in web data connectivity would materially improve Excel’s usefulness for international users. Take a look at Apple Numbers STOCK formula