Equal currency pairs don't work for some currencies after updating to Numbers 5.1

Since updating to Numbers 5.1 I have the following problem.


I use the CURRENCY function to get the current exchange rates between two currencies and do the conversion between them. For example, for the conversion between the EUR and USD I use:

=CURRENCY("EUR","USD","price").


Because of the way my spreadsheet is designed, sometimes it occurs to have the same currency in the same function, returning the value 1.00. For example, CURRENCY("EUR","EUR","price") returns 1.

However, for some reason the same doesn't work for many other currencies such as "SEK".

This is best illustrated on the following example: I have 4 currencies in a table, obtaining 16 mutual rates from their combinations:


User uploaded file


Pairs "EUR"<>"EUR" and "USD"<>"USD" normally return 1, but the same doesn't apply to "SEK" and "PLN". I get the following error:


User uploaded file

As visible from the screenshots, both currencies SEK and PLN work when paired with other currencies.

Is there any particular reason why same currency pairs don't fully work after the update to 5.1, and why it works for some currencies, while for others it returns an error?

MacBook

Posted on Jun 25, 2018 9:24 PM

Reply
Question marked as Top-ranking reply

Posted on Jul 29, 2018 11:34 PM

It's a Yahoo! think. To verify just try the URLs.


works:


https://finance.yahoo.com/quote/sekeur=X?ltr=1


works:


https://finance.yahoo.com/quote/eureur=X?ltr=1


doesn't work:


https://finance.yahoo.com/lookup?s=SEKSEK=X


You can easily avoid the whole issue by simply including a conditional in your formula, like this:


User uploaded file


In B2, filled down and right:


=IF(B$1=$A2,1,CURRENCY(B$1,$A2))


SG

Similar questions

9 replies
Question marked as Top-ranking reply

Jul 29, 2018 11:34 PM in response to filipb

It's a Yahoo! think. To verify just try the URLs.


works:


https://finance.yahoo.com/quote/sekeur=X?ltr=1


works:


https://finance.yahoo.com/quote/eureur=X?ltr=1


doesn't work:


https://finance.yahoo.com/lookup?s=SEKSEK=X


You can easily avoid the whole issue by simply including a conditional in your formula, like this:


User uploaded file


In B2, filled down and right:


=IF(B$1=$A2,1,CURRENCY(B$1,$A2))


SG

Jul 24, 2018 10:13 AM in response to Badunit

HI **.


Your original post was on June 16.


This line from filipb's most recent post may provide a clue: "I waited for some weeks to see whether it solves by itself, but the problem persists."


I'm guessing the date on your post was changed when filip marked it "Helpful" today (your time, late yestrday by my time).


Regards,

Barry

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Equal currency pairs don't work for some currencies after updating to Numbers 5.1

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.