Apple Numbers, CURRENCYH (EUR USD) conversion problem

I am assuming it is the data coming from Yahoo! Finance. I hope they or Apple will soon correct the data for this API. It is correct on the Yahoo! Finance website but apparently CURRENCYH pulls data from somewhere else. The stock functions have a similar problem from time to time, though usually it is "data not available". That's actually a better result than incorrect numbers.

Broken here too. I tried it in version 13.1 and 14.4 and using some other sets of currencies. The ones that involved conversion to/from USD had this problem, the ones that did not involve USD appeared to be okay. It appears to be a problem with the data it is receiving.

It does seem like CURRENCYH() is broken, but I can't quite see how - it's not as simple as always returning USD, for example.

I created a quick table of dates, CURRENCYH("USD","EUR") and CURRENCYH("EUR","USD") and got the following:

So it's not like it's always returning, say, USD, because the numbers are close, but not the same, differing by somewhere between 0.00¢ and 0.03¢

Granted, currency conversion is not something I do regularly, so I don't know what previous versions would return, but I would expect one to be the inverse of the other.

Feedback - Numbers - Apple would be the next port of call.

cvonselle wrote:

Wrote to Feedback/Numbers/Apple twice, still the problem persists. How long do they need to address an essential flaw in their software? I cannot put my bookkeeping on hold, guess I will need to move back to using Excel for Mac.

It's hard to say. Feedback is monitored but there is no way of knowing how long it will take to resolve a particular problem. Suggest. you give feedback again. The may be a flaw not in the software itself but in the data feed from the provider.

If you want to keep your work in Numbers remember that as a temporary workaround it is not hard to get historical data elsewhere (say Google Sheets, using a GOOGLEFINANCE formula) and copy-paste into a Numbers table.

SG

Same problem with CAD and USD. Put either currency first and the number comes out the same. Or at least sameish.