AVGetEquityTimeSeries function

Description

---

Get Equity time series using Alpha Vantage

Syntax

---

AVGetEquityTimeSeries(Symbol, Interval_value, Adjusted, Output_arguments)

AVGetEquityTimeSeries function syntax has the following arguments :

• Symbol String Equity symbol
• Interval_value String Frequency of the series. Valid values are (Monthly,Weekly,Daily,60min,30min,15min,5min,1min)
• Adjusted Object (Optional)Flag for whether the series is adjusted for corporate actions or not. Default value is TRUE
• Output_arguments Object (Optional) Arguments for the data output. See Remarks for more information.

Returns

---

Void A spreadsheet range representing equity series

Summary

---

An Excel spreadsheet function that returns a time series for the specified equity symbol. See Time Series API for more details

Remarks

---

Usage : =AVGetEquityTimeSeries("MSFT","Daily",TRUE,"compact")

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