AVGetExchangeRate function


Description

Provides the current exchange rate. Currencies can be physical or digital


Syntax

AVGetExchangeRate(From_currency, To_currency, Field)

AVGetExchangeRate function syntax has the following arguments :

  • From_currency String The currency converting from
  • To_currency String The currency converting to
  • Field String The specific field to return (like "Exchange Rate"). "all" returns all fields (default value is "all")

Returns

Void A spreadsheet range representing the currency quote. If you desire a single output you need to specify a specific field


Summary

An Excel spreadsheet function that returns a current quote for the exchange rate between two currencies.


Remarks

Usage : =AVGetExchangeRate("GBP","USD","all") or =AVGetExchangeRate("BTC","USD","Exchange Rate")


See Also

Alpha Vantage Functions