Ticker | = |
Ticker symbol (e.g "MMM") | |
Start Year | = |
Year to use as the starting date of the historical quotes; must be four
digits (e.g. 2022); optional; default is to fill your array-entered
range. | |
Start Month | = |
Month to use as the starting date of the historical quotes; optional; default is to fill your array-entered range. | |
Start Day | = |
Day to use as the starting date of the historical quotes; optional; default is to fill your array-entered range. | |
End Year | = |
Year to use as the ending date of the historical quotes; must be four
digits (e.g. 2023); optional; defaults to most recent date available. | |
End Month | = |
Month to use as the ending date of the historical quotes; optional; defaults to most recent date available. | |
End Day | = |
Day to use as the ending date of the historical quotes; optional; defaults to most recent date available. | |
Period | = |
Type of data period to retrieve; optional; defaults to "d"; possible values:
"d" = Daily quotes "w" = Weekly quotes (Yahoo chooses to use the first trading day of the week as the end of the period) "m" = Monthly quotes (Yahoo chooses to use the first trading day of the month as the end of the period) "v" = Dividend history ("T" is the only "Data Item" that makes a difference � Date and Dividend amount are automatic) | |
Data Items | = |
A character string indicating which data items to retrieve; optional;
defaults to "DOHLCVA"; possible values within the character string:
"T" = Ticker symbol "D" = Ending date of the period "O" = Opening price of the period "H" = High price for the period "L" = Low price for the period "C" = Adjusted Closing price for the period "V" = Trading volume for the period "U" = Adjusted closing price for the period "A" = Accepted as input but same as C - Adjusted close (only one will display) If C and A are provided, A will be dropped | |
Header Line | = |
A binary value to indicate whether headers should be returned for the
column(s) of data; optional; defaults to 1; possible values:
0 = Delete column headings 1 = Display column headings | |
Adjust | = |
A binary value to indicate whether data should be adjusted or not; optional; defaults to 1. Left in for compatibility.
0 = Do not attempt to adjust data; now returns error if used 1 = Returns data as adjusted by Yahoo | |
Resort | = |
A binary value to indicate whether data should be resorted or not; optional; defaults to 0.
0 = Do not resort data; present raw data as returned from Yahoo!; newest data will be on the top rows of table. 1 = Reverse the order of data returned from Yahoo!; oldest data will be on the top rows of table. |