AVGetListingStatus function


Description


Gets the listing status of equities on the latest date. Function is slow because it returns a lot of data


Syntax


AVGetListingStatus(State, Listing_date)

AVGetListingStatus function syntax has the following arguments :

  • State String Listing state. Can be active or delisted
  • Listing_date Object (Optional) Get listing status for this date. Default is most recent trading date

Returns


Void A spreadsheet range representing the listing status


Summary


An Excel spreadsheet function that returns the listing status of equities


Remarks


Usage : =AVGetListingStatus("active")


See Also


Alpha Vantage Functions