AVGetCurrencyTimeSeries function

Description

---

Get Currency time series using Alpha Vantage

Syntax

---

AVGetCurrencyTimeSeries(From_currency, To_currency, Interval_value, Output_arguments)

AVGetCurrencyTimeSeries function syntax has the following arguments :

• From_currency String The currency converting from. Digital currency histories must put the digital currency symbol here
• To_currency String The currency converting to
• Interval_value String Frequency of the series. Valid values are (Monthly,Weekly,Daily,60min,30min,15min,5min,1min)
• Output_arguments Object (Optional) Arguments for the data output. See Remarks for more information.

Returns

---

Void A spreadsheet range representing the currency rate series

Summary

---

An Excel spreadsheet function that returns a time series for the exchange rate between two currencies. See Currency Series API for more details

Remarks

---

Usage : =AVGetCurrencyTimeSeries("GBP","USD","Daily","compact") or =AVGetCurrencyTimeSeries("BTC","USD","Daily","A1:B2(see below...)")

output size arguments
• Single Argument

  "compact"

  - up to 100 points

  "full"

  - complete series history

  something else...

  - A string input that's not "compact" or "full" is assumed to be the name of the output range(Named range). No spaces allowed

• 2 Columns. First is key, second is value
  key: "outputsize"
  - value can be "full" or "compact"
  key: "outputname"
  - string input is the name of the output range(Named range). No spaces allowed

See Also

---

Alpha Vantage Functions