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 https://finance.yahoo.com/ to find tickers. See also a full list of Yahoo! Finance exchanges.
Data Fields and Excel Formulas
| Excel Column | Excel 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.
| Parameter | Value |
|---|---|
| RefreshInterval | 00:15:00, 15 minutes |
| NextRequestDelay | 1000, one second |
| DataStartTime | 00: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.quoteslist
Special thanks to http://www.philadelphia-reflections.com/blog/2392.htm