Skip to content

Changing currency - EUR, AUD, GBP, etc

The returned rates are in USD and you can convert to any other currency using the GOOGLEFINANCE function.

For example, to convert to Euro you can use:

=QUERY(IMPORTDATA("https://cryptorates.ai/files/standard.csv", ",", "en_US"), "SELECT Col3 WHERE Col1 = 'BTC'", 0) * GOOGLEFINANCE("USDEUR")