This is pretty useful and I can never remember the exact syntax, so here it is for me (and now you) to remember.
In a Google spreadsheet, you can do an online currency conversion that looks up the exchange rate in real time, making my life much easier.
For example to get EUR to GBP just type
=googlefinance(("CURRENCY:EURGBP"))
(note: if you copy and paste this and get an error, replace the quotation marks ( ” ) with your own. For some reason the blog template sometimes changes the quote symbol into it’s own format. I think I’ve fixed it but just in case…)
which will give you the rate ( you can then use that to convert existing cells to whatever currency you wish)
This makes it really easy to build an expense forecasting sheet like this that auto updates the exchange rate
|
Does this function still work? I keep getting an error, but maybe I’m doing it wrong.
yes – I just checked and it seems that when I applied a new theme to my blog it changed the ” character… so when you copy and paste the code, replace the ” with your own ” – thanks for pointing this out I’ll try and fix the text format in the post
Hello, I just noticed that this funcion does not return the value but the convertion rate, so in my case when y was converting 32000 COP to USD I had to multiply the result of this function by 32000 to get the correct value that shows google.
Hi!
How can I specify the amount that I want to be converted ?
Thanks
the function will just give you the rate, which you then just multiply by your cell with the amount in it
eg if your amount is in B2, then the formula for the conversion is =B2*(googlefinance((“CURRENCY:EURGBP”)))
Thank you, this is great.
Can you do this over a 3 month average for the conversion rate instead of in real time?
I’ve been looking for this formula as well. Any luck? Anybody?