VbaFin.com

Visual Basic for Financial Professionals
Home      Price Functions
This is an Excel Add-in example that features the following functions:
  • vf_GetPrice(Symbol, Optional Item, Optional Delayed): Retrieves price data (Last, Change, Open, High, Low, etc)
  • vf_GetDividend(Symbol, Optional Item): Retrieves dividend data (Dividend, Currency, Ex Date, Pay Date, Frequency)
  • vf_GetHistory(Symbol, Optional StartDate, Optional EndDate, Optional Item): Retrieves price or dividend history
  • vf_GetOptions(Symbol): Retrieves options chain (Call and Put Symbol, Last, Change, Bid, Ask, Volume, Open Int, Strike)
  • vf_GetOption(Symbol, Optional Item): Retrieves options price data (Last, Change, Open, High, Low, etc)
  • vf_Today(): Non Volatile function that returns the system date
Click on the image to download the Add-in, Examples, and a Help file. Click here to watch some demos.