Yahoo! Finance Industry

Yahoo! Finance Industry

Usage

Excel formula:

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

Examples:

=RTD("gartle.rtd",,"YahooFinanceIndustry","YHOO","Sector")
=RTD("gartle.rtd",,"YahooFinanceIndustry","YHOO","Industry")

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 
Sector=RTD("gartle.rtd",,"YahooFinanceIndustry",[Symbol],"Sector")
Industry=RTD("gartle.rtd",,"YahooFinanceIndustry",[Symbol],"Industry")
rtd_LastError=RTD("gartle.rtd",,"YahooFinanceIndustry",[Symbol],"rtd_LastError")
rtd_LastMessage=RTD("gartle.rtd",,"YahooFinanceIndustry",[Symbol],"rtd_LastMessage")
rtd_LastUpdate=RTD("gartle.rtd",,"YahooFinanceIndustry",[Symbol],"rtd_LastUpdate")
rtd_LastUpdateDate=RTD("gartle.rtd",,"YahooFinanceIndustry",[Symbol],"rtd_LastUpdateDate")
rtd_LastUpdateTime=RTD("gartle.rtd",,"YahooFinanceIndustry",[Symbol],"rtd_LastUpdateTime")

See Copying formulas about inserting formulas into Excel spreadsheets.

Data Provider Settings

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

See Data provider settings.

ParameterValue
RefreshInterval12:00:00, 12 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

Web pages like http://finance.yahoo.com/q/in?s=YHOO