EPF.EOD.IPODate always Returns #NUM!

[Lou K]

I am trying formula EPF.EOD.IPODate for the first time. The return is #NUM! for every symbol I try. I have tried 629 Stock, ETF and Mutual Fund symbols.

I checked my EODHistoricalData API key. This check returns Valid API Key regsitered to "my name".

Is EPF.EOD.IPODate broken?

[Andrew Sinclair]

I have just checked the formula and it is working as expected, it returns 12 Dec 1980:

Are you using the correct tickers/symbols? 

For example, with Apple stock I needed to append the country code of US, so the ticker is APPL.US

Andrew Sinclair

Coderun Technologies Ltd

[Lou K]

Thanks for the reply Andy.

I just tried =EPF.EOD.IPODate("AAPL.US") and I am still getting #NUM! as the return.

Lou Kurrelmeyer

[Andrew Sinclair]

Can you check that you have a valid EOD API Key set on the Configuration Pane?

https://www.excelpricefeed.com/userguide/eod-historical-data/overview

If I enter an invalid API Key then I also see the #NUM! error, this means it cannot retrieve the data.

[Andrew Sinclair]

Perhaps you have exceeded your EOD API allowance?

[Lou K]

I have tried generating a new API key, despite the old one reporting valid. The new key reports valid as well. Neither return anything other than #NUM!.

As for doing too many, I am trying 1.

[Lou K]

Bottom line is that formula EPF.EOD.IPODate always returns #NUM!. Does anyone have this working?