Yahoo! Finance Summary

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 may get Open, High and Low values for options.

Use http://finance.yahoo.com/ to find tickers. See also the complete list of Yahoo! Finance exchanges.

Data Fields and Excel Formulas

Excel ColumnExcel 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.

See Data provider settings.

ParameterValue
RefreshInterval00:15:00, 15 minutes
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

Yahoo! Finance Website.

Example:

https://finance.yahoo.com/q?s=AAPL