VbaFin.com

Visual Basic for Financial Professionals
   Home      Price Functions
This is an Excel Add-in example that features the following functions:
  • vf_GetLast(Symbol): Retrieves the last price for the specified symbol
  • vf_GetHistory(Symbol, Optional StartDate, Optional EndDate): Retrieves price history for the specified symbol
  • vf_GetItem(Symbol, Item): Retrieves specific item (Name, Last, High, Volume, etc) for the respective symbol
  • vf_GetRTLast(Symbol): Retrieves last real time price for the specified symbol. Works only for NYSE and NASDAQ stocks
Once you install the Add-in (Tools>Add-in) these functions can be used from any spreadsheet. Click on the image to download the file.