|
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_GetHistorical(Symbol, AsOfDate, Optional Item):
Retrieves historical price for a specified date
- 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_GetHstVol(Symbol, Optional StartDate, Optional EndDate):
Returns historical volatility
- vf_GetHstCorr(SymbolOne, SymbolTwo, Optional StartDate, Optional EndDate):
Returns historical correlation
- vf_GetReturn(Symbol, Optional StartDate, Optional EndDate):
Returns the Log Return for a specified date range
- vf_Today():
Non Volatile function which returns the system date
Click on the image to download the Add-in, Examples, and a Help file. Click here
to watch some demos.
|
Price Functions
