Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Level 1

10 points

Historical currency in Numbers not working correctly

I have a spreadsheet that tracks stock values in their “native” currency and also in Euro, using yesterday’s closing price, via CURRENCYH to make the conversion. In the last few days it is giving an error that the date (yesterday) is invalid or in the future. I have to go back 3 days to get a reading. Note that I do not change the format of the date cell; in fact, I use (TODAY)-1 to get yesterday’s date, and (TODAY)-3 to get a valid reading.

Also, I’ve indicated this happens on my MacBook Pro (because I have to select something!), but it is also happening on my iPads.

MacBook Pro 15″, macOS 10.15

Posted on Apr 16, 2021 12:24 AM

Best reply

iBacio

Level 1

18 points

Posted on Apr 26, 2021 12:45 PM

It has finally (after more than a week) started to work.

For a short period of time today it worked only partially (some of the currencies were OK, some NOT), but as for now - it is working as it should.

View in context

Historical currency in Numbers not working correctly

Similar questions