Four More Formulas Always Returning #NUM!

[Lou K]

I have hit four more formulas that always returns #NUM!.

These are:

EPF.Yahoo.RevenueGrowth
EPF.Yahoo.Revenue.Estimate.SalesGrowth.Annual
EPF.Yahoo.Growth.Estimate.Annual

What is up with this tool? Are the makers planning to get it working or is this another mickey-mouse operation who does not have the time to do what they are being

paid to do?

[Andrew Sinclair]

Thank you for your feedback.

I have just tested these formulas and they are all working as expected (at least for the sample tickers I used).

EPF.Yahoo.RevenueGrowth
This requires just one parameter, for example: =EPF.Yahoo.RevenueGrowth("AAPL")

EPF.Yahoo.Revenue.Estimate.SalesGrowth.Annual

This requires 2 parameters, a ticker and a time period where 0 is the current year and 1 is the next year
For example: =EPF.Yahoo.Revenue.Estimate.SalesGrowth.Annual("AAPL",0)

EPF.Yahoo.Growth.Estimate.Annual
Again, this formula needs 2 parameters,  a ticker and a time period where 0 is the current year and 1 is the next year

For example: EPF.Yahoo.Growth.Estimate.Annual("AAPL",0)

If you have some examples of tickers where the formulas are not working but the data is available on Yahoo Finance then let us know and we can investigate further.

Kind Regards,

Andrew Sinclair

Coderun Technologies Ltd

[lou...@gmail.com]

Is it possible that Yahoo is changing the inputs, then fixing them/changing them back?

--
You received this message because you are subscribed to the Google Groups "Excel Price Feed" group.
To unsubscribe from this group and stop receiving emails from it, send an email to excel-price-fe...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/excel-price-feed/9a2fee6a-010d-4384-b90b-ea60c8766f2an%40googlegroups.com.

[Andrew Sinclair]

That does not sound possible.

Can you attach your spreadsheet or some formulas (with tickers/other parameters) to this message and we can investigate?