Google finance sheets currency. The format for a googlefinance formula to find the current exchange rate is googlefinance currencyusdgbp where you can replace usd and gbp with other suitable three letter currency codes. That means 1 usd 63575 inr. Priceopen the price as of market open.
And today well examine the function together. This formula returns the exchange rate of usd with inr. Another great function of google sheets is that it can convert currencies in real time.
Summary currencysymbol purchase price current price amount invested total growth bitcoinbtc 125000 981606 800 1000000 7852848 685. Im speaking about the googlefinance function. You can do this by typing the stock ticker currency followed by the codes of the two currencies you want to convert such as usdgbp or eurjpy you can also display historical currency data by specifying a date.
The above 63575 is the exchange rate of usd to inr at the time of writing this post. If you apply this formula to your sheet you may get a different rate as the exchange rate is auto updating on google sheets. High the current days high price.
Attribute optional price by default the attribute to fetch about ticker from google finance and is required if a date is specified. The example above shows the then current usd to gbp rate. Converting currency with sheets.
Autogenerating Currency Conversion Formulas In Google Sheets Using Googlefinance Concatenate Jason D Rowley
jasondrowley.com
Azsheets Com Everything About Spreadsheets Download Free Google Spreadsheet And Microsoft Excel Templates
azsheets.com