Forum Discussion
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 Price, Volume... work. I tried to copy paste the formula for those fields from Office 365 to Mac but they never worked. Any ideas?
6 Replies
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
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.
Duplication of https://techcommunity.microsoft.com/t5/excel/excel-for-mac-data-field-stock-exchange/m-p/1042578
Did you try the suggested solutions given in the above link? It worked there!
And what version of Excel are you on? The picture below comes from the help section.
Riny_van_Eekelen Thanks for getting back.
Excel version is uptodate. I am also logged into Excel with my office 365 account. This is a personal account. Not sure if any subscription to Office 365 is needed for the same.
Seshu1992 I believe the help message is clear in saying that you must be a subscriber. I'm on a monthly program and it works for me.
Attached a workbook with some examples. See if it works for you.
