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 https://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 https://finance.yahoo.com/q/in?s=YHOO

This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.