Getting no data from Yahoo provider: "Provider update complete"
Author: kmckiou
Creation Date: 7/29/2020 3:22 PM
profile picture

kmckiou

#1
What the heck am I doing wrong?

I have the Yahoo Finance Static, Real-Time and Fundamental extension version 2020.02.23

When I attempt to get data, all seems well, except I get no data and the log has this entry:

Updating Provider Yahoo! Finance ...
Preparing requests ...
Requests are ready to go.
Provider update complete for Yahoo! Finance
----------------

Update completed (0.4 sec)

- Kevin
profile picture

Eugene

#2
Try to restart WLD.
profile picture

kmckiou

#3
It has been restarted multiple times. I have been fighting with this a couple days. Just to be sure, I restarted it again. No change.

- Kevin
profile picture

Eugene

#4
Apparently some of Yahoo's .WL files got corrupt. You should reload the data instead. There are 3 ways:

A. Delete the .WL files from the hidden folder: c:\Users\Windows username\AppData\Roaming\Fidelity Investments\WealthLabDev\1.0.0.0\Data\YahooStaticProvider\Daily

B. Use the Data Tool addin > "Remove all data"

C. Using WL's built-in tool:

1. Highlight your Yahoo DataSet 1
2. Click "Symbol Details"
3. Click on the first symbol, then use keyboard shortcut Shift-End to select all symbols (or do this with your mouse)
4. Right-click on the selection and choose "Reload symbol data file". The cached data is purged.
5. Update the DataSet to reload the data from scratch.
6. Repeat for Yahoo DataSet 2 etc.
profile picture

kmckiou

#5
Hi Eugene,

I used method "C" and then checked the file (method "A"). There were no files. I restarted WLD and tried loading data using the Yahoo Finance extension. Same result:

Updating Provider Yahoo! Finance ...
Preparing requests ...
Requests are ready to go.
Provider update complete for Yahoo! Finance
----------------

Update completed (0.0 sec)
----------------
profile picture

Eugene

#6
Hmm the Yahoo provider doesn't even get to caching the session cookie.

This starts to look more like a firewall / antivirus issue preventing WLD from accessing Yahoo site.

P.S. I don't think it should have any effect but try closing WLD and removing the YahooStaticProvider folder (i.e. not just the empty Daily subfolder).
profile picture

kmckiou

#7
Yep. Tried that. Removed the folder and restarted. Still nothing.

I then turned off all Firewall protections in Norton and restarted WLD. Same result.

I take it that the Yahoo Finance extension works for you and others...so, I must have something wrong.

Other data providers are working. For example, Wealth-Data is just fine - except it does not include QQQ, QLD or TQQQ. I just need a provider that can give me daily historical data for those symbols.

- Kevin
profile picture

Eugene

#8
Yahoo has been definitely working for many a WLD user. We did have a bug exactly like this before. It was fixed later. Removing the folder was the workaround.

Can't see why obtaining the Yahoo cookie would fail (as it's the reasonable next step I'm thinking about) abruptly - not by timeout. No legacy code there.

Does update of a Y! DataSet work? So far you only showed a "Update All Data" log.
profile picture

kmckiou

#9
I'll be darned. I created a Yahoo dataset and it worked! Thanks Eugene!

- Kevin
profile picture

Eugene

#10
I should've thought of that... Sometimes the simplest route is the less obvious.

You're welcome.

profile picture

kmckiou

#11
Well, I thought all was well, but it seems there is still a problem. I cannot get the current day entry (7/29/2020) from yahoo finance. When I update the dataset I get the following:

Updating Provider Yahoo! Finance ...
Preparing requests ...
Requests are ready to go.
Yahoo session cookie cached
Updating Security Names for 3 symbols...
Security Names updated.
[1] QQQ 5382 bars 7/28/2020 0 bars added
[2] TQQQ 2633 bars 7/28/2020 0 bars added
[0] QLD 3550 bars 7/28/2020 0 bars added
Provider update complete for Yahoo! Finance
----------------

Update completed (1.31 sec)
----------------

I tried deleting the dataset and recreating it, restarting and updating, but it gives the same result.

It is updating the data record because the QQQ.WL file has the correct modification date and time. I also tried deleting hte YahooStaticProvider folder and it recreating the folder and data files, but they still do not contain the current day price data.

Alright...wait a minute...If I check the option "Always return data with partial bar" I get the current day data. That doesn't seem right...

- Kevin
profile picture

Eugene

#12
It's OK, nothing to worry about. You can indeed check "Always return data with partial bar" if you're rushing to get the data today. In this case, the next morning the downloaded data should have corrections applied to it. The Y! data may be not available instantly but usually it does next a.m. Like it is right now.
This website uses cookies to improve your experience. We'll assume you're ok with that, but you can opt-out if you wish (Read more).