Usage

Excel formula:

=RTD("gartle.rtd",,"YahooFinanceHistoricalData","<Ticker>",[<date>],"<Data Field>")

where <date> is a Microsoft Excel date value or a string value as "yyyy-mm-dd".
If <date> is empty or equal to 0 then the last trade date is used by default. It is useful to monitor the last trade date data.

Example:

=RTD("gartle.rtd",,"YahooFinanceHistoricalData","YHOO","2013-07-15","Close")
=RTD("gartle.rtd",,"YahooFinanceHistoricalData","YHOO",,"Close")

Use http://finance.yahoo.com/ to find tickers.

Important Notes

Do not request the Yahoo! website frequently. Otherwise, your IP can be banned by the Yahoo! website.

Historical data for a one ticker symbol is downloaded by a one request to a web service. This feature significantly reduces amount of requests to the Yahoo! website.

The amount of data depends on the entire data period that is calculated for all stocks in opened workbooks.

Data Fields and Excel Formulas

Excel Column
Excel Formula
Symbol 
Date
Open=RTD("gartle.rtd",,"YahooFinanceHistoricalData",[Symbol],[Date],"Open")
High=RTD("gartle.rtd",,"YahooFinanceHistoricalData",[Symbol],[Date],"High")
Low=RTD("gartle.rtd",,"YahooFinanceHistoricalData",[Symbol],[Date],"Low")
Close=RTD("gartle.rtd",,"YahooFinanceHistoricalData",[Symbol],[Date],"Close")
Change=RTD("gartle.rtd",,"YahooFinanceHistoricalData",[Symbol],[Date],"Change")
ChangeInPercent=RTD("gartle.rtd",,"YahooFinanceHistoricalData",[Symbol],[Date],"ChangeInPercent")
AdjClose=RTD("gartle.rtd",,"YahooFinanceHistoricalData",[Symbol],[Date],"AdjClose")
AdjChange=RTD("gartle.rtd",,"YahooFinanceHistoricalData",[Symbol],[Date],"AdjChange")
AdjChangeInPercent=RTD("gartle.rtd",,"YahooFinanceHistoricalData",[Symbol],[Date],"AdjChangeInPercent")
Volume=RTD("gartle.rtd",,"YahooFinanceHistoricalData",[Symbol],[Date],"Volume")
PrevDate=RTD("gartle.rtd",,"YahooFinanceHistoricalData",[Symbol],[Date],"PrevDate")
PrevOpen=RTD("gartle.rtd",,"YahooFinanceHistoricalData",[Symbol],[Date],"PrevOpen")
PrevHigh=RTD("gartle.rtd",,"YahooFinanceHistoricalData",[Symbol],[Date],"PrevHigh")
PrevLow=RTD("gartle.rtd",,"YahooFinanceHistoricalData",[Symbol],[Date],"PrevLow")
PrevClose=RTD("gartle.rtd",,"YahooFinanceHistoricalData",[Symbol],[Date],"PrevClose")
PrevAdjClose=RTD("gartle.rtd",,"YahooFinanceHistoricalData",[Symbol],[Date],"PrevAdjClose")
PrevVolume=RTD("gartle.rtd",,"YahooFinanceHistoricalData",[Symbol],[Date],"PrevVolume")
rtd_LastError=RTD("gartle.rtd",,"YahooFinanceHistoricalData",[Symbol],[Date],"rtd_LastError")
rtd_LastMessage=RTD("gartle.rtd",,"YahooFinanceHistoricalData",[Symbol],[Date],"rtd_LastMessage")
rtd_LastUpdate=RTD("gartle.rtd",,"YahooFinanceHistoricalData",[Symbol],[Date],"rtd_LastUpdate")
rtd_LastUpdateDate=RTD("gartle.rtd",,"YahooFinanceHistoricalData",[Symbol],[Date],"rtd_LastUpdateDate")
rtd_LastUpdateTime=RTD("gartle.rtd",,"YahooFinanceHistoricalData",[Symbol],[Date],"rtd_LastUpdateTime")

See Copying formulas about inserting formulas into Excel spreadsheets.

Change, ChangeInPercent, AdjChange, and AdjChangeInPercent calculated by RealTimeToExcel.

Data Provider Settings

The data provider is configured for loading free Yahoo! Finance data from US exchanges one or two times a day.

To load the data from other world's exchanges, you may configure the default settings. See Data provider settings.

Parameter Value
RefreshInterval 12:00:00, twelve hours
NextRequestDelay 1000, a one second
DataStartTime 06:00:00 -05:00
DataEndTime 24:00:00 -05:00
LoadEndTime 24:00:00 -05:00
LoadOnSaturday 1, loading Friday's data once.
LoadOnSunday 1, loading Friday's data once.

Data Source

http://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20yahoo.finance.historicaldata

To Top