Update on Automating Yahoo Finance Stock History into Excel

[fred3]

It has been some time since I used my vba / Workbook setup to do stock analysis. I find that it no longer works.
I've done a bit of research and trying with limited success.
I haven't found much that seems to be *current* information as of 3/22/2023. So, I'm asking for other's views here.
My original Workbook would automatically get Date, Open, High, Low, Close, Adj Close, Volume over 2 or 3years to the last date.
So, I'd like to get the same capability.
The question is how?

Just for refernce to show how old the orignal Worksheet is; the old vba code included the Yahoo access:

qurl = "http://ichart.finance.yahoo.com/table.csv?s=" & Symbol
        qurl = qurl & "&a=" & Month(StartDate) - 1 & "&b=" & Day(StartDate) & _
            "&c=" & Year(StartDate) & "&d=" & Month(EndDate) - 1 & "&e=" & _
            Day(EndDate) & "&f=" & Year(EndDate) & "&g=" & Sheets("Data").Range("a1") & "&q=q&y=0&z=" & _
            Symbol & "&x=.csv"

So far, the best luck(?) I've had is using Data/From Web and providing the necessary URL.
Just doing this manually goes through PowerQuery and loads only the first 100 rows of a table that is much larger (but not quite large enough if the specified date span is 3.3 years).
So, at least I was able to download over 2 years worth of history but that gets lost in loading into a Worksheet.
Of course, this is all manual and not automated at all. So, it's not what I need but is some kind of progress.

I'm looking for suggestions, references and examples of things that will work in today's context.

Thanks!

 

[James006]

Hi,
You are right .. !!!
This world is changing quickly ... "Once upon a time, Yahoo finance" ....

Have you tried Excel built-in features ...

How to Use the Built-In Stocks Feature in Microsoft Excel

It's a cinch to add stock data to your Excel spreadsheet. Let's take a look!

www.howtogeek.com

 

[fred3]

James006: Thank you! I put in the STOCKHISTORY function and, other than ADJ CLOSE which I probably wouldn't be using anyway, the data downloads and fills a worksheet.
But now, it doesn't always want to run.
Using this:

=STOCKHISTORY(ticker,startDate,endDate,0,,0,2,3,4,1,5)

and using Refresh on that cell, I rather often get:
Unable to open http://ichart.yahoo.com/table.csv?s=BP&a=4&b=1&c=2013&d=5&e=11&f=2013&g=&q=q&y=0&z=BP&x=.csv

 

[fred3]

Any suggestions?