Excel 365 Stock End Of Day Data Providers

[Data123]

Being new to both Google Sheets (GS) and Excel 365 I need some advice. I left GS because the stock data was not reliable. I bought Excel 365 because I assumed this would not be an issue, but I am viewing about 850 symbols and I show about 5%+ do not have historical price data. My sheet shows #N/A or 0 for them. I then looked up each symbol to verify each one was trading and had historical data available.

So my question is what are people using for end of day data when using Excel 365 and are there any free services that are reliable?

P.S. MSFT's data vendor for stock history is a big well established company. I am sure they are paying them big $$$. It's a shame it's not reliable.

 

[alansidman]

Here is the link to the add-in that I use.

Stock Connector add-in for Excel

www.michael-saunders.com

 

[Data123]

Here is the link to the add-in that I use.

Stock Connector add-in for Excel

www.michael-saunders.com

Thanks Alan! May I ask does the add in offer historical price data going back a few years?

 

[alansidman]

I don't have a need for that information. Suggest you go to the web site and review it for the answer.

 

[alansidman]

Called up Mr Google and he found the following that may work for you

How to Download Historical Stock Data to Excel for Free

This tutorial shows how to download historical data for multiple stocks into Excel.

www.listendata.com

 

[Data123]

Called up Mr Google and he found the following that may work for you

How to Download Historical Stock Data to Excel for Free

This tutorial shows how to download historical data for multiple stocks into Excel.

www.listendata.com

Thanks Alan, options are always good.