From Apple Quantity’s doc, the formulation CURRENCYH ought to return historic foreign money information.
Examples
=CURRENCYH(“USD”, “GBP”, 3, “18/04/2017”) returns £0.78, the bottom fee of trade (“low” or 3) from the USA greenback (USD) to
Kilos sterling (GBP) on 18 April 2017.=CURRENCYH(“gbp”, “bmd”, “open”, “31/12/2015”) returns BMD1.48, the trade fee from Kilos sterling (GBP) to the Bermudian greenback (BMD)
originally of buying and selling on 31 December 2015.=CURRENCYH(“usd”, “aud”, “shut”, TODAY()-2) returns the trade fee from United States {dollars} to Australian {dollars} (in AUD) on the shut
of buying and selling two days in the past.
Nonetheless, after I attempt it with TODAY()-2 (writing as of 4 Could 2020) and a few earlier days, it reveals the error The requested historic date is invalid or is sooner or later.
I’ve to return to 4 Apr 2020, and the error message turned There isn’t a historic information on the requested date. The following obtainable is on 6/4/2020.
After updating to 6 Apr 2020, I managed to get the USDGBP fee and it’s all obtainable up till 17 Apr 2020, then turned unavailable.
To summarise with a fast check from 1 Apr:
- 1-3 Apr can be found
- 4-5 Apr are NOT obtainable
- 6-17 Apr can be found
- 18 Apr – 4 Could are NOT obtainable
It appears very unreliable for getting the foreign money fee for a selected date in Numbers. Is that this anticipated, and the way can I repair it?