How do I do a currency conversion in situ?

[Galena1]

Say I have a spreadshet with $ for currency.
Now, say I wanted a drop down filter or radio button
that if selected would convert all cells to the new currency.

here's what I DON'T want to use:

1. A macro
2. A relative referenced cell that formulaically contains the conversion factor that I can multiply my cells against and produce the results on another worksheet.

I just want the worksheet to magically change to the new currency when I push a radio button (or select from a drop-down validation list). Surely there is a 3rd party api that I can get than can do this that polls the latest
currency exchange rates from outside the spreadsheet and uses them as the basis for the conversion.

Anyone got any ideas?

Thanks!~

 

[Oaktree]

Consider this example:

Today, I have $1,000 USD. I'm curious to see what the value in € is, so I divide by today's conversion rate of 1.4333 USD/EUR to get €697.69 (overwriting my $1,000 value).

Then, tomorrow, the exchange rate falls to 1.43, and I want to convert back to $USD. If I multiply my €697.69 by 1.43, my file would show $997.70.

But, I really still have $1,000 in $USD, I was just doing some what-if analysis. For this reason, I'd highly recommend keeping your starting point in your base currency and letting your currency fluctuation be a multiplying factor (as in 2 in your exclusion list). Otherwise, it will be hard to track the fluctuations as you change your exchange rate assumptions and have no tracking history.