1

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.

formula

Today()-2



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.

4/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.

ok



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?

8
  • What version of Numbers are you using? I tried getting USD to GBP from 1 April thru 4 May for 2017 thru 2020 for closing values using Currencyh(). All of the formulas have returned decent looking values for all dates except for weekends and 4 May 2020. I haven't tried this function before but it is possible that the recent historic data is always available with a bit of lag. I have made this test using Numbers v6.1. – Alper May 4 '20 at 22:28
  • Numbers version 10.0, macOS 10.15.4 – EES May 4 '20 at 23:19
  • Also, IMO, partially not available and lag for two weeks doesn't make sense as Forex trades 24/7. – EES May 4 '20 at 23:29
  • I haven’t traded a lot of FX but from what I know FX markets are closed on weekends. That might be the reason why there are no data over the weekends. I have an MBP that has Numbers v10.0. I will check if the file I have prepared that seems to be running OK on Numbers v6.1 is running OK also on v10.0 and let you know. – Alper May 4 '20 at 23:55
  • I ran the file with Numbers v10.0 and it is working alright on v10.0 as well. Data is not available for weekends as I explained before. Now the USD to GBP rate for 4 May 2020 is also being brought up on both versions. I guess it did not bring in 4 May 2020 before because I reckon the market was not closed when I ran the file on 4 May 2020 in the respective market about 12 hours ago. The file also runs OK on both versions for opening quotes for the same dates. Sorry that I can't tell you why it is not working on your computer as it does on the Macs I tried. Hope you figure it out soon. – Alper May 5 '20 at 11:34

You must log in to answer this question.

Browse other questions tagged .