Yahoo! Finance Summary
Usage
Excel formula:
=RTD("gartle.rtd",,"YahooFinanceSummary","<Ticker>","<Data Field>")
Example:
=RTD("gartle.rtd",,"YahooFinanceSummary","YHOO","Days Range")
=RTD("gartle.rtd",,"YahooFinanceSummary","YHOO170120C00033000","Days Range")
This provider is unique as you can get Open, High and Low values for options.
Use https://finance.yahoo.com/ to find tickers. See also the complete list of Yahoo! Finance exchanges.
Data Fields and Excel Formulas
| Excel Column | Excel Formula |
|---|---|
| Symbol | |
| Company Name | =RTD("gartle.rtd",,"YahooFinanceSummary",[Symbol],"Company Name") |
| Stock Exchange | =RTD("gartle.rtd",,"YahooFinanceSummary",[Symbol],"Stock Exchange") |
| Earnings Date | =RTD("gartle.rtd",,"YahooFinanceSummary",[Symbol],"Earnings Date") |
| Last Trade Date | =RTD("gartle.rtd",,"YahooFinanceSummary",[Symbol],"Last Trade Date") |
| Last Trade Time | =RTD("gartle.rtd",,"YahooFinanceSummary",[Symbol],"Last Trade Time") |
| Last Trade DateTime | =RTD("gartle.rtd",,"YahooFinanceSummary",[Symbol],"Last Trade DateTime") |
| Bid | =RTD("gartle.rtd",,"YahooFinanceSummary",[Symbol],"Bid") |
| Ask | =RTD("gartle.rtd",,"YahooFinanceSummary",[Symbol],"Ask") |
| Bid Size | =RTD("gartle.rtd",,"YahooFinanceSummary",[Symbol],"Bid Size") |
| Ask Size | =RTD("gartle.rtd",,"YahooFinanceSummary",[Symbol],"Ask Size") |
| BidX | =RTD("gartle.rtd",,"YahooFinanceSummary",[Symbol],"BidX") |
| AskX | =RTD("gartle.rtd",,"YahooFinanceSummary",[Symbol],"AskX") |
| Last | =RTD("gartle.rtd",,"YahooFinanceSummary",[Symbol],"Last") |
| Change | =RTD("gartle.rtd",,"YahooFinanceSummary",[Symbol],"Change") |
| Change In Percent | =RTD("gartle.rtd",,"YahooFinanceSummary",[Symbol],"Change In Percent") |
| Open | =RTD("gartle.rtd",,"YahooFinanceSummary",[Symbol],"Open") |
| High | =RTD("gartle.rtd",,"YahooFinanceSummary",[Symbol],"High") |
| Low | =RTD("gartle.rtd",,"YahooFinanceSummary",[Symbol],"Low") |
| Volume | =RTD("gartle.rtd",,"YahooFinanceSummary",[Symbol],"Volume") |
| OpenInterest | =RTD("gartle.rtd",,"YahooFinanceSummary",[Symbol],"OpenInterest") |
| Previous Close | =RTD("gartle.rtd",,"YahooFinanceSummary",[Symbol],"Previous Close") |
| Days Range | =RTD("gartle.rtd",,"YahooFinanceSummary",[Symbol],"Days Range") |
| Beta | =RTD("gartle.rtd",,"YahooFinanceSummary",[Symbol],"Beta") |
| 52-Week High | =RTD("gartle.rtd",,"YahooFinanceSummary",[Symbol],"52-Week High") |
| 52-Week Low | =RTD("gartle.rtd",,"YahooFinanceSummary",[Symbol],"52-Week Low") |
| 52-Week Range | =RTD("gartle.rtd",,"YahooFinanceSummary",[Symbol],"52-Week Range") |
| Change from 52-Week High | =RTD("gartle.rtd",,"YahooFinanceSummary",[Symbol],"Change from 52-Week High") |
| Change from 52-Week Low | =RTD("gartle.rtd",,"YahooFinanceSummary",[Symbol],"Change from 52-Week Low") |
| % Change from 52-Week High | =RTD("gartle.rtd",,"YahooFinanceSummary",[Symbol],"% Change from 52-Week High") |
| % Change from 52-Week Low | =RTD("gartle.rtd",,"YahooFinanceSummary",[Symbol],"% Change from 52-Week Low") |
| Avg Vol (3 Month) | =RTD("gartle.rtd",,"YahooFinanceSummary",[Symbol],"Avg Vol (3 Month)") |
| Market Cap | =RTD("gartle.rtd",,"YahooFinanceSummary",[Symbol],"Market Cap") |
| Market Cap $ | =RTD("gartle.rtd",,"YahooFinanceSummary",[Symbol],"Market Cap $") |
| P/E | =RTD("gartle.rtd",,"YahooFinanceSummary",[Symbol],"P/E") |
| PEG Ratio | =RTD("gartle.rtd",,"YahooFinanceSummary",[Symbol],"PEG Ratio") |
| Price/Sales | =RTD("gartle.rtd",,"YahooFinanceSummary",[Symbol],"Price/Sales") |
| One Year Target Price | =RTD("gartle.rtd",,"YahooFinanceSummary",[Symbol],"One Year Target Price") |
| Mean Recommendation | =RTD("gartle.rtd",,"YahooFinanceSummary",[Symbol],"Mean Recommendation") |
| EPS Estimate Current Year | =RTD("gartle.rtd",,"YahooFinanceSummary",[Symbol],"EPS Estimate Current Year") |
| EPS Estimate Next Quarter | =RTD("gartle.rtd",,"YahooFinanceSummary",[Symbol],"EPS Estimate Next Quarter") |
| Forward Annual Dividend Rate | =RTD("gartle.rtd",,"YahooFinanceSummary",[Symbol],"Forward Annual Dividend Rate") |
| Forward Annual Dividend Yield | =RTD("gartle.rtd",,"YahooFinanceSummary",[Symbol],"Forward Annual Dividend Yield") |
| Ex-Dividend Date | =RTD("gartle.rtd",,"YahooFinanceSummary",[Symbol],"Ex-Dividend Date") |
See Copying formulas about inserting formulas into Excel spreadsheets.
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
Yahoo! Finance Website.
Example: