Working and Not Working

[Lou K]

I find the vast majority of the EPF functions are working. I am having trouble with several array functions. The functions are still always returning #NUM! in spreadsheets where they were previously working:

EPF.Yahoo.DividendsDatePeriod
EPF.Yahoo.HistoricDailyLookbackAdjustedClose
EPF.Yahoo.News.Headline
EPF.Yahoo.News

[Andrew Sinclair]

Can you send me the contents of your error log?

The error log can be viewed from the "Help->Show Error Log" menu option on the ExcelPriceFeed tab in Excel.

Please send it to: he...@coderun.net

Thanks

Andy

[Lou K]

Sure.

It's the same error message for all of the errors:

2025-05-09 10:38:04.254 -04:00 [ERR] GetCrumb: 429 Too Many Requests
2025-05-09 10:38:04.086 -04:00 [ERR] GetCrumb: 429 Too Many Requests
2025-05-09 10:38:03.924 -04:00 [ERR] GetCrumb: 429 Too Many Requests
2025-05-09 10:38:03.741 -04:00 [ERR] GetCrumb: 429 Too Many Requests
2025-05-09 10:38:03.574 -04:00 [ERR] GetCrumb: 429 Too Many Requests
2025-05-09 10:38:03.405 -04:00 [ERR] GetCrumb: 429 Too Many Requests
2025-05-09 10:38:03.225 -04:00 [ERR] GetCrumb: 429 Too Many Requests
2025-05-09 10:38:03.054 -04:00 [ERR] GetCrumb: 429 Too Many Requests
2025-05-09 10:38:02.864 -04:00 [ERR] GetCrumb: 429 Too Many Requests

I am going to do some more testing and see if I get any other error messages. I will report if I find anything. I am guessing all the errors will look like the above. I will tell you if I find anything to the contrary.

[Lou K]

I have some different log entries. I will post them separately here by EPF formula. Array functions, like EPF.Yahoo.DividendsDatePeriod are logging entries like:

2025-05-09 11:31:49.064 -04:00 [ERR] GetCrumb: 429 Too Many Requests
2025-05-09 11:31:48.895 -04:00 [ERR] GetCrumb: 429 Too Many Requests
2025-05-09 11:31:48.723 -04:00 [ERR] GetCrumb: 429 Too Many Requests
2025-05-09 11:31:48.538 -04:00 [ERR] GetCrumb: 429 Too Many Requests
2025-05-09 11:31:48.378 -04:00 [ERR] GetCrumb: 429 Too Many Requests
2025-05-09 11:31:48.187 -04:00 [ERR] GetCrumb: 429 Too Many Requests

On Friday, May 9, 2025 at 10:14:17 AM UTC-4 andy.s...@gmail.com wrote:

[Lou K]

I am getting a "flashing" behavior where certain functions are alternately displaying values, then 0 or some Excel error. These alternate on a 2-second interval. This is related to one or more of these functions:

  EPF.Yahoo.AnnualDividendsPaid
  EPF.Yahoo.AnnualEarnings
  EPF.Yahoo.AnnualDepreciationAndAmortization
  EPF.Yahoo.AnnualStockBasedCompensation
  EPF.Yahoo.AnnualOtherNonCashItems

These are throwing very long messages. They are all reporting problems with an HTTP get. Example:

https://query2.finance.yahoo.com/ws/fundamentals-timeseries/v1/finance/timeseries/DOW?

That is followed by a list of 112 types that start out:

type=annualInterestExpense,
annualOtherIncomeExpense,

~~~

The message is:

[WRN] YF Request Failure: 429 Request:Method: GET, Version: 1.1, Content: <null>, Headers:

{
  User-Agent: Mozilla/5.0
  User-Agent: (Windows NT 10.0; Win64; x64)
  User-Agent: AppleWebKit/537.36
  User-Agent: (KHTML, like Gecko)
  User-Agent: Chrome/99.0.4844.51
  User-Agent: Safari/537.36
}

The Headers vary, naming different platform information.

Does [WRN] mean warning message?

Below is the complete, lengthy, raw message I extracted the above from:

2025-05-09 11:26:38.893 -04:00 [WRN] YF Request Failure: 429 Request:Method: GET, RequestUri: 'https://query2.finance.yahoo.com/ws/fundamentals-timeseries/v1/finance/timeseries/DOW?type=annualInterestExpense,annualOtherIncomeExpense,annualOperatingCashFlow,annualPurchaseOfInvestment,annualEndCashPosition,annualBeginningCashPosition,annualNetOtherFinancingCharges,annualRepurchaseOfCapitalStock,annualRepaymentOfDebt,annualSaleOfInvestment,annualPurchaseOfBusiness,annualOtherNonCashItems,annualFreeCashFlow,annualAccountsPayable,annualStockBasedCompensation,annualDeferredIncomeTax,annualChangeInWorkingCapital,annualCostOfRevenue,annualEBITDA,annualNormalizedEBITDA,annualOperatingIncome,annualStockholdersEquity,annualCurrentLiabilities,annualTotalLiabilitiesNetMinorityInterest,annualCurrentAssets,annualTotalAssets,annualChangesInAccountReceivables,annualOperatingCashFlow,annualCapitalExpenditure,annualNetOtherInvestingChanges,annualCashFlowFromContinuingFinancingActivities,annualCapitalExpenditure,annualChangeInCashSupplementalAsReported,annualDepreciationAndAmortization,annualChangeInInventory,annualInvestingCashFlow,annualCommonStockIssuance,annualCashDividendsPaid,annualChangeInAccountPayable,annualSpecialIncomeCharges,annualOtherSpecialCharges,annualRestructuringAndMergernAcquisition,annualImpairmentOfCapitalAssets,annualWriteOff,annualSellingAndMarketingExpense,annualNetIncome,annualTotalRevenue,annualGrossProfit,annualOperatingExpense,annualResearchAndDevelopment,annualSellingGeneralAndAdministration,annualOperatingExpense,annualPretaxIncome,annualTaxProvision,annualBasicEPS,annualDilutedEPS,annualBasicAverageShares,annualDilutedAverageShares,annualNetIncomeContinuousOperations,annualCapitalLeaseObligations,annualTotalDebt,annualNetDebt,annualGoodwillAndOtherIntangibleAssets,annualGoodwill,annualAccountsReceivable,annualInventory,annualCashCashEquivalentsAndShortTermInvestments,annualLongTermDebt,annualNetPPE,annualTotalNonCurrentAssets,annualTotalNonCurrentLiabilitiesNetMinorityInterest,trailingForwardPeRatio,trailingPeRatio,annualInvestedCapital,annualWorkingCapital,annualTangibleBookValue,quarterlyTotalRevenue,quarterlyNetIncome,quarterlyCostOfRevenue,quarterlyGrossProfit,quarterlyOperatingIncome,quarterlyInterestExpense,quarterlyBasicEPS,quarterlyDilutedEPS,quarterlyEBITDA,quarterlyOperatingExpense,quarterlyPretaxIncome,quarterlyTaxProvision,quarterlyBasicAverageShares,quarterlyDilutedAverageShares,quarterlyOtherIncomeExpense,quarterlyNetIncomeContinuousOperations,quarterlyNormalizedEBITDA,quarterlySellingAndMarketingExpense,quarterlySellingGeneralAndAdministration,quarterlyResearchAndDevelopment,trailingTotalRevenue,trailingNetIncome,trailingCostOfRevenue,trailingGrossProfit,trailingOperatingIncome,trailingInterestExpense,trailingEBITDA,trailingOperatingExpense,trailingPretaxIncome,trailingTaxProvision,trailingOtherIncomeExpense,trailingNetIncomeContinuousOperations,trailingNormalizedEBITDA,trailingSellingAndMarketingExpense,trailingSellingGeneralAndAdministration,trailingResearchAndDevelopment&period1=493590046&period2=2232617095', Version: 1.1, Content: <null>, Headers:
{
  User-Agent: Mozilla/5.0
  User-Agent: (Windows NT 10.0; Win64; x64)
  User-Agent: AppleWebKit/537.36
  User-Agent: (KHTML, like Gecko)
  User-Agent: Chrome/99.0.4844.51
  User-Agent: Safari/537.36
}

[Andrew Sinclair]

Thanks Lou, we really appreciate your help with investigating these problems.

We have just released a new version (1.134) which aims to fix the historical and dividend data formulas.

Please install it and let us know if there is any change, although you may still need to wait a while for your machine to be unblocked due to the code 429 errors (too many requests).

Kind Regards,

Andy

[Steve]

Confirmed that 1.134 is working for historical data formulas.

Thanks!

[Lou K]

Tin fur...

[Lou K]

Array formula EPF.Yahoo.DividendsDatePeriod is now working. There are some problems with missing and erroneous data, but it is the same data that Yahoo is displaying. For some reason, I am still getting the below messages—despite not having any problems with the formula:

2025-05-09 12:41:41.069 -04:00 [ERR] GetCrumb: 429 Too Many Requests
2025-05-09 12:41:40.892 -04:00 [ERR] GetCrumb: 429 Too Many Requests
2025-05-09 12:41:40.642 -04:00 [ERR] GetCrumb: 429 Too Many Requests

These formulas are still returning #NUM!:

EPF.Yahoo.Growth.Estimate.Annual
EPF.Yahoo.News.Headline
EPF.Yahoo.News

Every else that I use is working. My various spreadsheets cover the vast majority of the Stock, Mutual Fund and ETF formulas. I do not use the futures formulas or the esoteric formulas that technical analysts use. I’m a fundamentals guy and look at a lot of history.

Lou

[Lou K]

I forgot to mention. Everything is much faster now. That is a greatly appreciated improvement.