CLK350
Member
GIYF: Add Real-Time Stock Prices And Metrics To Excel — The Spreadsheet Guru.It's too much work updating the stock price in excel. And it costs money. I'm at my 3rd keyboard now.
Anyone know a way to autoimport a live stockprice from somewhere into an excel cell? Don't have to be real-time. A one minute delay or something would be fine.
Serious question.
On June 5th, 2019 Microsoft released a feature to Office 365 that allows Excel users to pull real-time stock prices into their spreadsheets. This feature was never truly supported in Excel until now, even though many Excel users used to pull stock data from Yahoo! Finance until the capability end in 2018 (thanks Verizon!).
Excel now has the ability to pull data related to stocks, bonds, currency, and even crypto-currency such as Bitcoin. Microsoft is working with Nasdaq and Refinitiv to pull current financial data directly into your spreadsheets under a new feature called Data Types.