From Apple Quantity’s doc, the method CURRENCYH ought to return historic forex knowledge.
Examples
=CURRENCYH(“USD”, “GBP”, 3, “18/04/2017”) returns £0.78, the bottom price of trade (“low” or 3) from america greenback (USD) to
Kilos sterling (GBP) on 18 April 2017.=CURRENCYH(“gbp”, “bmd”, “open”, “31/12/2015”) returns BMD1.48, the trade price from Kilos sterling (GBP) to the Bermudian greenback (BMD)
initially of buying and selling on 31 December 2015.=CURRENCYH(“usd”, “aud”, “shut”, TODAY()-2) returns the trade price from United States {dollars} to Australian {dollars} (in AUD) on the shut
of buying and selling two days in the past.
Nonetheless, once 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 grew to become There isn’t any historic knowledge on the requested date. The subsequent obtainable is on 6/4/2020.
After updating to 6 Apr 2020, I managed to get the USDGBP price and it’s all obtainable up till 17 Apr 2020, then grew to become 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 forex price for a particular date in Numbers. Is that this anticipated, and the way can I repair it?
