Yahoo Finance api change?

sedgefield02

New Member
Joined
May 29, 2017
Messages
11
I use the yahoo financial api to download mutual fund prices each day. It has worked fine for months. Today I got

run time error 1004 application defined or object defined error

the apparent cause of the error is highlighted in bold below.

{ code
Set DataSheet = ActiveSheet
With ActiveSheet.QueryTables.Add(Connection:="URL;" & qurl, Destination:=Range("BQ5"))
.BackgroundQuery = True
' .TablesOnlyFromHTML = False
.FillAdjacentFormulas = False
.Refresh BackgroundQuery:=False '<---- cause of the bug 11/2/2017
.SaveData = True
End With

end code}

I know Yahoo will make changes without any notification. Does anyone have information on this?
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
I use the yahoo financial api to download mutual fund prices each day. It has worked fine for months. Today I got

run time error 1004 application defined or object defined error

.Refresh BackgroundQuery:=False '<---- cause of the bug 11/2/2017

Hi sedgefield02,
I get the same error. It worked yesterday morning but failed yesterday afternoon. You're right that Yahoo changes this without warning and doesn't provide info; they may have even dropped the 'service' (it's never been officially supported). And I have yet to find a fix....

Anyone have an idea? Or a suggestion for a good (i.e. free) alternative source?

Jim
 
Upvote 0
I too have used the Yahoo quoting service for years. This is now the response:

It has come to our attention that this service is being used in violation of the Yahoo Terms of Service. As such, the service is being discontinued. For all future markets and equities data research, please refer to finance.yahoo.com.

Fcn Yahoo!
 
Upvote 0
Yep, same here, only a matter of time when Verizon took over.
They eliminated the history, now they are eliminating the end of day.
Stopped for me on 11/1 with a 999 error, now I'm getting a 403.

Couple of alts:


Google api
strURL = "https://finance.google.com/finance/historical?q=" & strTicker & "&output=csv" - Only goes back 12 months.

Quote Media:
https://app.quotemedia.com/quotetoo...sv?&webmasterId=501&startDay=02&startMonth=02
&startYear=2002&endDay=02&endMonth=07&endYear=2009&isRanged=false&symbol=[Symbol name]

eoddata
 
Upvote 0
I saw that option during my research, only I found that you can extend your period

I cannot get the url to post correctly but where you have strTicker you can add beginning and ending dates (greater than 12 months). Give me a couple and I will try to figure out how to post the entire URL.

I really need just a simple daily open and close. I can obviously change the dates for today only but I am holding close to 50 equities, which would mean I have to run the url 50 times and parse the csv as it comes in. Doable, but not liking it.
 
Last edited:
Upvote 0
"http://finance.google.com/finance/historical?q=NYSE:WMT & startdate=Nov+3+2015 & enddate=Nov+2+2017 & output=csv"
 
Upvote 0
This should be good for what you are doing.

"https://finance.google.com/finance/historical?q=FB&output=csv"


Is how it is used.
Then I would read through until I got to the date that I already had and finished.



I had the date url as well, I don't have to go back that far generally

This is what I was using:

"http://www.google.com/finance/historical?q=FB&startdate=Jan+1"%2C+2016&enddate=Jan+1%2C+2017&num=30&ei=gnUrVvGHDYbPedfriKAP&output=csv"

Yours is obviously cleaner.[/QUOTE]
 
Upvote 0
Correction on quotemedia.

Sample url:

"http://app.quotemedia.com/quotetools/getHistoryDownload.csv?&webmasterId=501&startDay=01&startMonth=01&startYear=2017&endDay=12&endMonth=11&endYear=2017&isRanged=false&symbol=MSFT"
 
Upvote 0
Anyone know how to get the current (15 min delayed quote) for a list of symbols? I'll the miss all the finance fields available from Yahoo though.
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,202
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top