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

Excel Macro : Extract historical data for multiple stocks

Excel macro to download historical data for multiple stock quotes. Use data to perform technical analysis on stocks you wish to invest

www.listendata.com

 

[Data123]

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

Excel Macro : Extract historical data for multiple stocks

Excel macro to download historical data for multiple stock quotes. Use data to perform technical analysis on stocks you wish to invest

www.listendata.com

Thanks Alan, options are always good.