Fixing Macro on Yahoo Finance Historical Data

[dabears19850]

Last time I ran this Macro was back in February, and I've been using it since 2017. I'm guessing something has changed on the back-end of Yahoo Finance since when I tried it today, it came back with an error message. I attached two screenshots. VBA is not my strong suit so I'm hoping someone far smarter than me is able to identify what the issue is and the correction needed to the code.

I uploaded a copy of the spreadsheet to Google Drive for anyone that wants to download it.

 

[alansidman]

If you are running O365, you can use the new function called StockHistory.

STOCKHISTORY Function

The Excel STOCKHISTORY function retrieves historical stock price information based on a given symbol and date range. The primary purpose of STOCKHISTORY is to get the history of a financial instrument over time. The result is an array of values that spill onto the worksheet into multiple cells.

exceljet.net

 

[dabears19850]

If you are running O365, you can use the new function called StockHistory.

STOCKHISTORY Function

The Excel STOCKHISTORY function retrieves historical stock price information based on a given symbol and date range. The primary purpose of STOCKHISTORY is to get the history of a financial instrument over time. The result is an array of values that spill onto the worksheet into multiple cells.

exceljet.net

I might have one computer that has O365. I'll have to take at that.

 

[sverrealbech]

Did you solve this? Please upload a excel spreadsheet if you did. Thx.