Converting Currencies In Google Sheets With Google Finance API Calls
Channel: Daniel Rosehill
Date: 2022-03-04

Using Google Sheets, you can call the Google Finance API to pull live exchange rates into your spreadsheets, making it easy to convert between foreign currencies. Better still, the cells will automatically update as the rates change. 

=A1*(GOOGLEFINANCE("CURRENCY:ILSUSD"))

The three letter currency identifiers that Google Finance uses are as defined in ISO 4217:

https://www.iso.org/iso-4217-currency-codes.html

Rates may take up to 20 minutes to update from the real time rate. 

--

By: Daniel Rosehill 

== Contact Information ===

For latest contact information: 

https://www.youtube.com/c/DanielRosehillVideo/about

Social media and more:

https://www.danielrosehill.com

== Licensing / syndication / reproduction ==

Unless otherwise indicated, all videos I distribute through YouTube are licensed under the following Creative Commons license: Attribution-NonCommercial-NoDerivatives 4.0 International (CC BY-NC-ND 4.0). 

For the full license, see: https://bit.ly/ncnd4bycc.