Forum Discussion
Data Type Stocks not working in Excel 2019
It is indeed frustrating to read the linking ability of Excel 2016 and note that it is NOT included in 2019 ! I was reluctant to try the linking to get stock prices until I got a book on linking from Office Watch, and there they seem to describe the possibility to get data from the web, but so far I've had no luck. It strikes me that MS downgraded 2019 in order to boost the required long-term guaranteed income for MS from their Office 365 version. While I am sympathetic to the company for wanting to close the door on non-online users, I find it very disheartening that I will have to switch over to Google-Finance to achieve a goal that was once somewhat more straightforward.
You can actually use the function in Excel for the Web, free! All you need a outlook or hot mail email address which you can to access Excel for the Web.
Regards
Abiola1 did you really say Hotmail! Holy cow, we are going backwards here. What can we do if we do not have an outlook account or a hotmail, are you saying we can no longer use the Excel Stock function, even though it is an icon on the toolbar? Something seems amiss
There is an icon that says stock. If you enter MSFT, you can hit the stock button and it recognizes Microsoft as a stock. Now, how might we be able to see the data for that stock, say last close price, volume, etc. Can you help?
