Yahoo! Finance Quotes CSV
Special offer: 50% discount ($1440) for ODataDB Enterprise until June 24, 2024

Yahoo! Finance Quotes CSV

This provider is obsolete. Use Yahoo! Finance Summary instead.

Usage

Excel formula:

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

Example:

=RTD("gartle.rtd",,"YahooFinanceQuotesCSV","YHOO","Last")

This provider has the same data as the YahooFinanceQuotes provider but loads data directly from Yahoo! Finance website.
You can use this provider if the YahooFinanceQuotes provider has issues with updating data.

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

Data Fields and Excel Formulas

Excel ColumnExcel Formula
Symbol 
LastTradeDate=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"LastTradeDate")
LastTradeTime=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"LastTradeTime")
Bid=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"Bid")
Ask=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"Ask")
Last=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"Last")
Change=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"Change")
ChangeInPercent=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"ChangeInPercent")
Open=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"Open")
High=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"High")
Low=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"Low")
Volume=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"Volume")
DaysRange=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"DaysRange")
PrevClose=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"PreviousClose")
ShortRatio=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"ShortRatio")
YearHigh=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"YearHigh")
YearLow=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"YearLow")
YearRange=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"YearRange")
ChangeFromYearHigh=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"ChangeFromYearHigh")
ChangeFromYearLow=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"ChangeFromYearLow")
PercentChangeFromYearHigh=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"PercentChangeFromYearHigh")
PercentChangeFromYearLow=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"PercentChangeFromYearLow")
MA50=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"FiftydayMovingAverage")
MA200=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"TwoHundredDayMovingAverage")
ChangeFromMA50=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"ChangeFromFiftyDayMovingAverage")
ChangeFromMA200=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"ChangeFromTwoHundredDayMovingAverage")
PercentChangeFromMA50=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"PercentChangeFromFiftyDayMovingAverage")
PercentChangeFromMA200=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"PercentChangeFromTwoHundredDayMovingAverage")
AverageDailyVolume=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"AverageDailyVolume")
OneYearTargetPrice=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"OneYrTargetPrice")
PE=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"PERatio")
PEG=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"PEGRatio")
EPSEstCurrentYear=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"EPSEstimateCurrentYear")
EPSEstNextQuarter=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"EPSEstimateNextQuarter")
EPSEstNextYear=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"EPSEstimateNextYear")
EarningsShare=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"EarningsShare")
MarketCap=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"MarketCapitalization")
MarketCap$=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"MarketCapitalization$")
DividendYield=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"DividendYield")
DividendShare=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"DividendShare")
ExDividendDate=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"ExDividendDate")
DividendPayDate=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"DividendPayDate")
BookValue=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"BookValue")
PriceBook=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"PriceBook")
PriceSales=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"PriceSales")
PriceEPSEstCurrentYear=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"PriceEPSEstimateCurrentYear")
PriceEPSEstNextYear=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"PriceEPSEstimateNextYear")
EBITDA=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"EBITDA")
EBITDA$=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"EBITDA$")
CompanyName=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"Name")
StockExchange=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"StockExchange")
rtd_LastError=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"rtd_LastError")
rtd_LastMessage=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"rtd_LastMessage")
rtd_LastUpdate=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"rtd_LastUpdate")
rtd_LastUpdateDate=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"rtd_LastUpdateDate")
rtd_LastUpdateTime=RTD("gartle.rtd",,"YahooFinanceQuotesCSV",[Symbol],"rtd_LastUpdateTime")

Synonyms: ChangeInPercent, ChangePercent, and PercentChange.

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.