AVGetEquityQuote function


Description


Provides the current quote for the equity


Syntax


AVGetEquityQuote(Symbol, Field)

AVGetEquityQuote function syntax has the following arguments :

  • Symbol String The equity symbol
  • Field String The specific field to return (like "price"). "all" returns all fields (default value is "all")

Returns


Void A spreadsheet range representing the equity 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 an equity.


Remarks


Usage : =AVGetEquityQuote("MSFT","all") or =AVGetEquityQuote("AAPL","price")


See Also


Alpha Vantage Functions