Get latest exchange rate

[Jared12345]

Hi Community,

Is it possible to have a column or virtual column value that calculates the exchange rate between two currencies automatically?

Similar to this function in Google sheets.

=GOOGLEFINANCE("CURRENCY:<source_currency_symbol><target_currency_symbol>")

https://spreadsheetpoint.com/convert-currency-google-sheets/

[WillowMobileSys · Accepted solution]

No, there is no analogous function in AppSheet.  You can build your own using scripts, possible sheet formulas or other external services.