filmov
tv
Converting Currencies In Google Sheets With Google Finance API Calls
Показать описание
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:
Rates may take up to 20 minutes to update from the real time rate.
--
By: Daniel Rosehill
== Contact Information ===
For latest contact information:
Social media and more:
== 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).
=A1*(GOOGLEFINANCE("CURRENCY:ILSUSD"))
The three letter currency identifiers that Google Finance uses are as defined in ISO 4217:
Rates may take up to 20 minutes to update from the real time rate.
--
By: Daniel Rosehill
== Contact Information ===
For latest contact information:
Social media and more:
== 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).