Yahoo! Finance Stocks

Yahoo! Finance Stocks

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

Usage

Excel formula:

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

Example:

=RTD("gartle.rtd",,"YahooFinanceStocks","YHOO","FullTimeEmployees")

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 
CompanyName=RTD("gartle.rtd",,"YahooFinanceStocks",[Symbol],"CompanyName")
Sector=RTD("gartle.rtd",,"YahooFinanceStocks",[Symbol],"Sector")
Industry=RTD("gartle.rtd",,"YahooFinanceStocks",[Symbol],"Industry")
FullTimeEmployees=RTD("gartle.rtd",,"YahooFinanceStocks",[Symbol],"FullTimeEmployees")
TradeStart=RTD("gartle.rtd",,"YahooFinanceStocks",[Symbol],"Start")
TradeEnd=RTD("gartle.rtd",,"YahooFinanceStocks",[Symbol],"End")
rtd_LastError=RTD("gartle.rtd",,"YahooFinanceStocks",[Symbol],"rtd_LastError")
rtd_LastMessage=RTD("gartle.rtd",,"YahooFinanceStocks",[Symbol],"rtd_LastMessage")
rtd_LastUpdate=RTD("gartle.rtd",,"YahooFinanceStocks",[Symbol],"rtd_LastUpdate")
rtd_LastUpdateDate=RTD("gartle.rtd",,"YahooFinanceStocks",[Symbol],"rtd_LastUpdateDate")
rtd_LastUpdateTime=RTD("gartle.rtd",,"YahooFinanceStocks",[Symbol],"rtd_LastUpdateTime")

See Copying formulas about inserting formulas into Excel spreadsheets.

Data Provider Settings

The data provider is configured to loading data every 6 hours when the Excel workbook is open.

See Data provider settings.

ParameterValue
RefreshInterval06:00:00, six hours
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.stocks

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