Google Sheets - Tutorial 05 - Automatic Currency Conversion

Often you need to convert currencies, for instance to keep track of income or expenses, and it’s always a nuisance to update the latest exchange rates to keep your calculations up-to-date.

With Google Drive, you no longer need to change all your formulas.

In any cell of your Google Docs spreadsheet you can use the GoogleFinance function to pull in an exchange rate from real time data, so calculations are always up to date without having to look up the exchange rate.

-----------

As always if you found this helpful, subscribe today and find us on one of the following websites:

Looking to create your own videos like this to 'flip' you class?
I use Techsmith Camtasia and Snagit and love it!

[yoannafrancisca]

Other people would explain it in a very complicated way. Yours is so simple and easy to understand.

[ArtInMotionStudios]

is there no way to tell it to convert to a specific date ? like 3rd June ?

[Kiwinnit]

Also you'll need to set the currency sign yourself, using format --> numbers --> your currency. As this method simply works on percentages. Although my USD converted to GBP, it still showed a USD sign due to how i formatted the box. So watch out for that (if that made any sense)

Hope that helps ^

[irmalavit]

Incredibly precisely stated when it is so difficult to comprehend Excel with currencies.

[LowVisionTec]

I have a question how would I do this

So what ever currency I added, it would fill in the other currencies out if the 3 cells

[fraazhussain]

Thanks! Do you know how to stop the currency auto updating once it's been converted?

[jiaren]

Thanks, how about one column have various currency and I would like to formatting them the same currency in another column.

[MonnelEspiritu]

Thank you so much sir! Just used this in my budgeting spreadsheet! More power to you!

[natetate]

Thank you so much for making this! I've been trying to figure out how to do it for over an hour but it's working now.

[jnyYT]

Thanks! This helped a lot, I'm making a massive spreadsheet and this has made it so much easier

[infodcn]

Thanks man! Super useful. Hope life in Thailand is good.

[pillarheights]

Much appreciative for your talent and help. Using this to make my wholesale catalogues.

[maanuy]

Hello thank you for these videos. Since I was beginner in Google docs these are so very helpful.

[JamezJN]

how can i make that when i write in the column G it chages the value in column F and H ? and Vice versa

[sulycorredor]

Thanksss! it was a short, well explain video. It worked.

[kalolainefainu]

This was helpful - thank you. What about if I'm using two different currencies, for example, sometimes I'm spending Australian Dollars, and sometimes I'm spending in PGK, and creating the columns to convert either way depending on which column I input the amount into first? Is it possible?

[davesproket]

Very helpful thanks for making it easy!

[vanessabishop]

Any new Google Sheet that I open has an auto-format for the Pound. I would like this to be AUS Dollar... is there any tricks for this?

[salesforcerelated]

lets say I have a master column which is column C and then I have other columns after that, for column D I have sterling and column E, I have dollar, is it possible to have a formula that every time I enter an amount for dollar that it will auto populate the euro amount into column C?

[PaulissVegan]

Will this function update the currency exchange rates all the time or daily or will it just convert them at the time I put in a value?