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?
4 Replies
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.
