Yahoo! Finance WatchList

Yahoo! Finance WatchList

This provider is obsolete. Use Yahoo! Finance Quotes CSV instead.

Usage

Excel formula:

=RTD("gartle.rtd",,"YahooFinanceWatchList","<Ticker>","<Data Field>")

Example:

=RTD("gartle.rtd",,"YahooFinanceWatchList","YHOO","Last")

Use http://finance.yahoo.com/ to find tickers. See also a full list of Yahoo! Finance exchanges.

Data Fields and Excel Formulas

Excel ColumnExcel Formula
Symbol 
LastTradeDateTime=RTD("gartle.rtd",,"YahooFinanceWatchList",[Symbol],"LastTradeDateTime")
LastTradeDate=RTD("gartle.rtd",,"YahooFinanceWatchList",[Symbol],"LastTradeDate")
LastTradeTime=RTD("gartle.rtd",,"YahooFinanceWatchList",[Symbol],"LastTradeTime")
Last=RTD("gartle.rtd",,"YahooFinanceWatchList",[Symbol],"Last")
Change=RTD("gartle.rtd",,"YahooFinanceWatchList",[Symbol],"Change")
ChangeInPercent=RTD("gartle.rtd",,"YahooFinanceWatchList",[Symbol],"ChangeInPercent")
ChangePercent=RTD("gartle.rtd",,"YahooFinanceWatchList",[Symbol],"ChangePercent")
PercentChange=RTD("gartle.rtd",,"YahooFinanceWatchList",[Symbol],"PercentChange")
Open=RTD("gartle.rtd",,"YahooFinanceWatchList",[Symbol],"Open")
High=RTD("gartle.rtd",,"YahooFinanceWatchList",[Symbol],"High")
Low=RTD("gartle.rtd",,"YahooFinanceWatchList",[Symbol],"Low")
Volume=RTD("gartle.rtd",,"YahooFinanceWatchList",[Symbol],"Volume")
rtd_LastError=RTD("gartle.rtd",,"YahooFinanceWatchList",[Symbol],"rtd_LastError")
rtd_LastMessage=RTD("gartle.rtd",,"YahooFinanceWatchList",[Symbol],"rtd_LastMessage")
rtd_LastUpdate=RTD("gartle.rtd",,"YahooFinanceWatchList",[Symbol],"rtd_LastUpdate")
rtd_LastUpdateDate=RTD("gartle.rtd",,"YahooFinanceWatchList",[Symbol],"rtd_LastUpdateDate")
rtd_LastUpdateTime=RTD("gartle.rtd",,"YahooFinanceWatchList",[Symbol],"rtd_LastUpdateTime")

Synonyms: ChangeInPercent, ChangePercent, and PercentChange.

See Copying formulas about inserting formulas into Excel spreadsheets.

The ChangeInPercent value is calculated by RealTimeToExcel.

Data Provider Settings

The data provider is configured to loading data every 15 minutes when the Excel workbook is open.

See Data provider settings.

ParameterValue
RefreshInterval00:15:00, 15 minutes
NextRequestDelay1000, one second
DataStartTime00:00:00 -05:00
DataEndTime24:00:00 -05:00
LoadEndTime24:00:00 -05:00
LoadOnSaturday1, loading Friday's data once.
LoadOnSunday1, loading Friday's data once.

Data Source

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

Special thanks to http://www.philadelphia-reflections.com/blog/2392.htm