Log In
Register
Home
New Member
February 21, 2021
Offline
I am using Excel 2016. Pl help me to get stock quotes real-time or closing prices for the companies I track.
I dont have access to Excel 365.
Example: for AAPL, I want to get the stock price in the document. thanks
July 16, 2010
Offline
Welcome to our forum! Without 365 you'd need to scrape the price from a web page. You can use Power Query to do this as explained here.
Mynda
VIP
Trusted Members
December 7, 2016
Offline
Hello,
If you have a Microsoft account you can use the stock data types in Excel online.
Br,
Anders
July 16, 2010
Offline
I'm pretty sure you need a 365 licence to use the stock data types in Excel Online.
VIP
Trusted Members
December 7, 2016
Offline
Yep, seems to be so. Below quote is from the support site.
https://support.microsoft.com/.....a89e210877
Note: The Stocks and Geography data types are only available to Worldwide Multi-Tenant clients (standard Microsoft 365 accounts).
1 Guest(s)
