From Apple Number’s doc, the formula
CURRENCYH should return historical currency data.
=CURRENCYH(“USD”, “GBP”, 3, “18/04/2017”) returns £0.78, the lowest rate of exchange (“low” or 3) from the United States dollar (USD) to Pounds sterling (GBP) on 18 April 2017.
=CURRENCYH(“gbp”, “bmd”, “open”, “31/12/2015”) returns BMD1.48, the exchange rate from Pounds sterling (GBP) to the Bermudian dollar (BMD) at the beginning of trading on 31 December 2015.
=CURRENCYH(“usd”, “aud”, “close”, TODAY()-2) returns the exchange rate from United States dollars to Australian dollars (in AUD) at the close of trading two days ago.
However, when I try it with
TODAY()-2 (writing as of 4 May 2020) and a couple of previous days, it shows the error The requested historical date is invalid or is in the future.
I have to go back to
4 Apr 2020, and the error message became There is no historical data on the requested date. The next available is on 6/4/2020.
After updating to
6 Apr 2020, I managed to get the USDGBP rate and it is all available up until
17 Apr 2020, then became unavailable.
To summarise with a quick test from 1 Apr:
- 1-3 Apr are available
- 4-5 Apr are NOT available
- 6-17 Apr are available
- 18 Apr - 4 May are NOT available
It seems very unreliable for getting the currency rate for a specific date in Numbers. Is this expected, and how can I fix it?