Returns historical Prices or Dividends.
Syntax
vf_GetHistory(Symbol[, StartDate][, EndDate][, Item])
The vf_GetHistory function syntax has these parts:
| Part | Description |
| Symbol | Required; String. A valid ticker Symbol. Follows Yahoo!Finance naming conventions. |
| StartDate | Optional; Date. StartDate is set to Today-365 if omitted. |
| EndDate | Optional; Date. EndDate is set to Today if omitted. |
| Item | Optional; String. Can be one of the following: Open, High, Low, Volume, Close, Adj Close. If Item is none of the above the list of available items is returned. Otherwise the respective Item's value is returned. If Item is omitted the Adj Close is returned. |
Remarks
The returned data is a two column array of Dates and Values which is placed vertically in the spreadsheet
starting form the Cell where the function resides.
Any data in the two columns below the last row is deleted.
In the case of Dividends the first column is the Ex Dividend Date and the second is the Dividend Amount.
In the case of Prices the first column is the Date and the second is the Close. Sourced from Yahoo!Finance.
See Also
vf_GetHistorical
vf_GetHstVol
vf_GetHstCorr
vf_GetPrice
vf_GetDividend
vf_GetReturn
vf_GetOptions
vf_GetOption
vf_Today
vf_Download
Resources
Contact
E-mail: admin@vbafin.com