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 Column | Excel 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.
| Parameter | Value |
|---|---|
| RefreshInterval | 12:00:00, 12 hours |
| 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
Web pages like https://finance.yahoo.com/q/in?s=YHOO