Documentation for RCHGetYahooHistory() function


Description

    Returns historical stock quotes from the Yahoo quotes interface.

Syntax

    =RCHGetYahooHistory( Ticker, [Start Year], [Start Month], [Start Day], [End Year], [End Month], [End Day], [Period], [Data Items], [Header Line], [Adjust], [Resort] )

Parameters

    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. 2005); 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. 2005); 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" = Closing price for the period
    "V" = Trading volume for the period
    "A" = Adjusted closing price for the period

    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 0.

    0 = Do not adjust data; returns the raw data as returned from Yahoo!
    1 = Adjust O/H/L/C prices based on the value of the Adjusted Close and Close amounts returned from 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.


Examples Usage notes