Yahoo Historical Question

[Joe Wilkinson]

Hi All,

I have run into an  issue with the  HistoricDailyLookbackAdjustedClose  function... When I use the function with a US Mutual Fund symbol the latest price series is shifted...

=EPF.Yahoo.HistoricDailyLookbackAdjustedClose("OGMIX", 10, "DESC",1)

Date
Adj. Close
14 Feb 2023 0
13 Feb 2023 23.19000053
10 Feb 2023 23.12000084
09 Feb 2023 23.04000092
08 Feb 2023 23.27000046
07 Feb 2023 23.55999947
06 Feb 2023 23.72999954
03 Feb 2023 23.37999916
02 Feb 2023 23.69000053
01 Feb 2023 24.70999908

Using the non-Adjusted close for the same data I see this...

=EPF.Yahoo.HistoricDailyLookbackClose("OGMIX", 10, "DESC",1)

Date
Close
14 Feb 2023 23.19000053
13 Feb 2023 23.12000084
10 Feb 2023 23.04000092
09 Feb 2023 23.27000046
08 Feb 2023 23.55999947
07 Feb 2023 23.72999954
06 Feb 2023 23.37999916
03 Feb 2023 23.69000053
02 Feb 2023 24.70999908
01 Feb 2023 25.14999962

[Andrew Sinclair]

Hi Joe,

We have spent some time investigating this and have today released a fix for this problem. The dates for both datasets are now aligned correctly.

Please install the latest version by following the instructions in the User Guide:

https://www.excelpricefeed.com/userguide/add-in-updates

Kind Regards,

Andrew Sinclair

Coderun Technologies Ltd.

[Thomas Morton]

I'm running into inconsistent results with the EPF.Yahoo.Historic.AdjustedClose function. It seems to be pulling the unadjusted close for some dates. Example using:

11/19/2024  79.50 79.14 79.50
11/20/2024  79.48 79.12 79.48
11/21/2024  79.51 79.15 79.51
11/22/2024  79.49 79.13 79.49
11/25/2024  79.79 79.43 49.79
11/26/2024  79.64 79.28 49.64
11/27/2024  79.88 79.52 79.88

First column is what is populated by the EPF formula above. 2nd column is the adjusted close price from Yahoo Finance. 3rd column is the unadjusted close price from Yahoo Finance. As you can see, the EPF formula for Adjusted Close appears to be grabbing the unadjusted close.

[Thomas Morton]

The security used in the example above is HYG

[Andrew Sinclair]

Can you ensure you are using the latest version of the Add-in (we did fix a problem with this last year), instructions on how to update here:

https://www.excelpricefeed.com/userguide/add-in-updates

I have just tested it and the current version is returning the correct numbers.

Here you can see the formula used for cell E1, which returns 79.14 which is the adjusted close for HYG on 19 Nov 2024:

Please let me know if using the latest version fixes this for you.

Kind Regards,

Andrew Sinclair

Coderun Technologies Ltd

[Andrew Sinclair]

Hi Guil,

Sorry to hear you are having some problems with our software.

I presume the Add-in is installed but the tab is not visible in Excel? Also, do any of the formulas work, such as =EPF.Yahoo.Price("AAPL")

We do have a page on our website to help resolve problems like this, use the links at the top depending on which problem you are experiencing:

https://www.excelpricefeed.com/userguide/troubleshooting

Let me know how you get on.

Kind Regards,

Andrew Sinclair

Coderun Technologies Ltd.

On Thu, 26 Dec 2024 at 21:31, Guil Nergard <gil...@gmail.com> wrote:

Could someone help me with this?

When I open Excel, the Excell Price Feed add-in doesn't load.

I have tried to uninstall and then download a current file and then reload.

I have the GuruFocus add-in which I am trying to uninstall but cannot for some reason.

Guil

[Thomas Morton]

Hi Andrew,

I'm still running into issues where the  EPF.Yahoo.Historic.AdjustedClose is populating the cell with the unadjusted close. It's happening across multiple securities (LQD, SGOV, HYG) on a number of dates between June 2022 and September 2022 and again in July through September 2023. I have the most updated versions and have tried refreshing the sheet under various excel calculation settings. Do you have any ideas for why it would do this? And what might fix it?

Thanks,

Thomas Morton

[Thomas Morton]

I should had that it pulled the correct adjusted close prices for these securities on these dates when I used the configuration pane to generate a daily historical lookback. It seems to be an issue with using the EPF excel formulas that reference a security and a specific date.

[Andrew Sinclair]

Hi Thomas,

I'm sorry to hear that you are still experiencing some issues.

I have just been testing it with LQD for date: 1 August 2023. As far as I can see the formulas (EPF.Yahoo.HistoricDailyLookbackAdjustedClose and EPF.Yahoo.Historic.AdjustedClose) are returning consistent results with both the Yahoo Finance website and the configuration pane, an adjusted close price of 100.35

These are the formulas I have used:

=EPF.Yahoo.HistoricDailyLookbackAdjustedClose("LQD",1500,"DESC",1)

=EPF.Yahoo.Historic.AdjustedClose("LQD","1 Aug 2023")

Can you send me the exact formula(s) with its parameters that is returning the wrong data and I can investigate further?

Thanks