missing aily data

40 views
Skip to first unread message

Özkan Çimen

unread,
Jul 11, 2025, 6:47:04 AMJul 11
to Excel Price Feed
I use the formula EPF.Yahoo.HistoricDailyLookback(+E1;500;"DESC";TRUE) 
the formala does not retrieve 10 July 2025 data. Please see the result for CADCHF


Screenshot 2025-07-11 124412.png

Andrew Sinclair

unread,
Jul 11, 2025, 3:25:52 PMJul 11
to Excel Price Feed
I've checked and there does seem to be an issue with Yahoo data on 10 July, for other currency pairs as well.

I'm afraid this is outside our control as Yahoo is responsible for the data. I can contact them and they may fix it.

Kind Regards,

Andrew Sinclair
Coderun Technologies Ltd

Özkan Çimen

unread,
Jul 14, 2025, 3:28:53 AMJul 14
to Excel Price Feed
I have checked their web page they have all the daily data (see attached)

However excel price feed does not capture the same. This time 11th of July is missing? 
Screenshot 2025-07-14 092750.png
Screenshot 2025-07-14 092341.png

Özkan Çimen

unread,
Jul 15, 2025, 12:32:09 PMJul 15
to Excel Price Feed
Can I get a comment please?

This time 14th and 11 th of July is missing

katerina.a...@gmail.com

unread,
Jul 15, 2025, 2:18:50 PMJul 15
to Excel Price Feed
The Yahoo website appears to sometimes have different data to what we receive through the API. 

I'm afraid data issues like this are outside our control.

Best Regards,
Katerina

Özkan Çimen

unread,
Jul 20, 2025, 11:13:04 AMJul 20
to Excel Price Feed
Can you contact them to correct the data accessed through API 

Andrew Sinclair

unread,
Aug 6, 2025, 12:23:24 PMAug 6
to Excel Price Feed
Today we released a new version of the software with a fix for historical data. We did find an issue as it appears that Yahoo made a recent change to their data feed.

Instructions here on how to update: https://www.excelpricefeed.com/userguide/add-in-updates

I've checked CADCHF and the 11 and 14 July points are now downloaded.

Kind Regards,

Andy
Reply all
Reply to author
Forward
0 new messages