From Apple Number’s doc, the formula CURRENCYH should return historical currency data.
Examples
=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 2020and 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 2020I managed to get the USDGBP rate and it is all available up until 17 Apr 2020then 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?
