Microsoft recently updated the built-in tools for retrieving stock quotes into Excel. If you’re typing closing prices into Excel manually, my recent California CPA Magazine article may be able to help you get it done faster. Specifically, it talks about how the Stock data type retrieves current quotes and related information, and how Power Query can retrieve historical stock quotes.

To read the full article, just click below … hope it helps!

https://www.excel-university.com/articles/cal-cpa/get-current-and-historical-stock-prices-into-excel/