Get historical currency rate via CURRENCYH shows error: The requested historical date is invalid or is in the future

From Apple Number’s [doc](https://support.apple.com/en-gb/guide/functions/ffa3e86ad3f3/10.0/web/1.0) , 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 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?