Access Yahoo Finance Quotes in Excel with Market RTD

Access Yahoo Finance Quotes in Excel with Market RTD

The YahooFinanceQuotes provider delivers live market quotes and related trading data for a wide range of financial instruments. It supports:

  • Price Data
    Last trade, open, high, low, bid, ask, previous close

  • Volume and Liquidity
    Volume, average daily volume, bid/ask size, market capitalization

  • Performance Metrics
    Change, percent change, day range, 52-week range, moving averages

  • Valuation and Earnings
    P/E ratios, EPS, forward P/E, earnings dates and estimates

  • Dividends and Yield
    Dividend rate, dividend yield, ex-dividend and pay dates

  • Meta Information
    Exchange names, quote source, time zones, market state

This data can be used to build watchlists, dashboards, and live monitoring models directly in Excel.

Use the following generic RTD formula:

=RTD("market.rtd",,"YahooFinanceQuotes","<Symbol>","<Data Field>")

Example:

For example, to retrieve the last trade price for Apple Inc. (AAPL), use:

=RTD("market.rtd",,"YahooFinanceQuotes","AAPL","Last")

In this formula:

  • <Symbol> is the ticker symbol (e.g., AAPL)
  • <Data Field> is one of the supported fields listed below.

Use the Formula Builder to generate and copy formulas into Excel. You can also customize separators and layout settings.

To find ticker symbols, visit Yahoo Finance.

You may also refer to the complete list of Yahoo Finance exchanges.

By default, the refresh interval is set to 15 minutes. You can change it using the following formula:

=RTD("market.rtd",,"YahooFinanceQuotes","rtd_RefreshInterval",15*60)

Data Fields and Excel Formulas

Data FieldExcel Formula
Symbol=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"Symbol")
language=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"language")
region=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"region")
quoteType=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"quoteType")
typeDisp=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"typeDisp")
quoteSourceName=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"quoteSourceName")
triggerable=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"triggerable")
customPriceAlertConfidence=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"customPriceAlertConfidence")
currency=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"currency")
regularMarketChangePercent=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"regularMarketChangePercent")
regularMarketPrice=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"regularMarketPrice")
shortName=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"shortName")
longName=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"longName")
exchange=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"exchange")
messageBoardId=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"messageBoardId")
exchangeTimezoneName=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"exchangeTimezoneName")
exchangeTimezoneShortName=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"exchangeTimezoneShortName")
gmtOffSetMilliseconds=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"gmtOffSetMilliseconds")
market=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"market")
esgPopulated=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"esgPopulated")
hasPrePostMarketData=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"hasPrePostMarketData")
firstTradeDateMilliseconds=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"firstTradeDateMilliseconds")
priceHint=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"priceHint")
fullExchangeName=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"fullExchangeName")
financialCurrency=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"financialCurrency")
regularMarketOpen=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"regularMarketOpen")
averageDailyVolume3Month=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"averageDailyVolume3Month")
averageDailyVolume10Day=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"averageDailyVolume10Day")
fiftyTwoWeekLowChange=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"fiftyTwoWeekLowChange")
fiftyTwoWeekLowChangePercent=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"fiftyTwoWeekLowChangePercent")
fiftyTwoWeekRange=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"fiftyTwoWeekRange")
fiftyTwoWeekHighChange=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"fiftyTwoWeekHighChange")
fiftyTwoWeekHighChangePercent=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"fiftyTwoWeekHighChangePercent")
fiftyTwoWeekLow=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"fiftyTwoWeekLow")
fiftyTwoWeekHigh=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"fiftyTwoWeekHigh")
fiftyTwoWeekChangePercent=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"fiftyTwoWeekChangePercent")
dividendDate=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"dividendDate")
earningsTimestamp=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"earningsTimestamp")
earningsTimestampStart=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"earningsTimestampStart")
earningsTimestampEnd=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"earningsTimestampEnd")
earningsCallTimestampStart=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"earningsCallTimestampStart")
earningsCallTimestampEnd=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"earningsCallTimestampEnd")
isEarningsDateEstimate=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"isEarningsDateEstimate")
trailingAnnualDividendRate=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"trailingAnnualDividendRate")
trailingPE=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"trailingPE")
dividendRate=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"dividendRate")
trailingAnnualDividendYield=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"trailingAnnualDividendYield")
dividendYield=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"dividendYield")
epsTrailingTwelveMonths=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"epsTrailingTwelveMonths")
epsForward=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"epsForward")
corporateActions_0=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"corporateActions_0")
postMarketTime=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"postMarketTime")
regularMarketTime=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"regularMarketTime")
postMarketChangePercent=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"postMarketChangePercent")
postMarketPrice=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"postMarketPrice")
postMarketChange=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"postMarketChange")
regularMarketChange=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"regularMarketChange")
regularMarketDayHigh=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"regularMarketDayHigh")
regularMarketDayRange=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"regularMarketDayRange")
regularMarketDayLow=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"regularMarketDayLow")
regularMarketVolume=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"regularMarketVolume")
regularMarketPreviousClose=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"regularMarketPreviousClose")
bid=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"bid")
ask=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"ask")
bidSize=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"bidSize")
askSize=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"askSize")
epsCurrentYear=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"epsCurrentYear")
priceEpsCurrentYear=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"priceEpsCurrentYear")
sharesOutstanding=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"sharesOutstanding")
bookValue=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"bookValue")
fiftyDayAverage=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"fiftyDayAverage")
fiftyDayAverageChange=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"fiftyDayAverageChange")
fiftyDayAverageChangePercent=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"fiftyDayAverageChangePercent")
twoHundredDayAverage=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"twoHundredDayAverage")
twoHundredDayAverageChange=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"twoHundredDayAverageChange")
twoHundredDayAverageChangePercent=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"twoHundredDayAverageChangePercent")
marketCap=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"marketCap")
forwardPE=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"forwardPE")
priceToBook=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"priceToBook")
sourceInterval=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"sourceInterval")
exchangeDataDelayedBy=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"exchangeDataDelayedBy")
averageAnalystRating=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"averageAnalystRating")
tradeable=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"tradeable")
cryptoTradeable=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"cryptoTradeable")
marketState=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"marketState")
displayName=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"displayName")
quoteResponse_error=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"quoteResponse_error")
Avg Vol(3m)=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"Avg Vol(3m)")
StockExchange=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"StockExchange")
50-Day Moving Average=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"50-Day Moving Average")
52-Week High=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"52-Week High")
Change from 52-Week High=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"Change from 52-Week High")
% Change from 52-Week High=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"% Change from 52-Week High")
52-Week Low=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"52-Week Low")
Change from 52-Week Low=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"Change from 52-Week Low")
% Change from 52-Week Low=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"% Change from 52-Week Low")
Forward P/E(1 yr)=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"Forward P/E(1 yr)")
Market Cap=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"Market Cap")
Change=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"Change")
ChangeInPercent=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"ChangeInPercent")
High=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"High")
Low=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"Low")
Open=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"Open")
Prev Close=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"Prev Close")
Last=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"Last")
LastTradeDateTime=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"LastTradeDateTime")
Volume=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"Volume")
CompanyName=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"CompanyName")
P/E(ttm)=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"P/E(ttm)")
EPS(ttm)=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"EPS(ttm)")
Annual EPS Est=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"Annual EPS Est")
DividendShare=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"DividendShare")
200-Day Moving Average=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"200-Day Moving Average")
LastTradeDate=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"LastTradeDate")
LastTradeTime=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"LastTradeTime")
Earnings Date=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"Earnings Date")
Earnings Date Start=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"Earnings Date Start")
Earnings Date End=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"Earnings Date End")
52-Week Range=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"52-Week Range")
Day's Range=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"Day's Range")
BidX=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"BidX")
AskX=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"AskX")
Synonyms:
Symb=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"Symb")
Last Trade DateTime=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"Last Trade DateTime")
Last Trade Date=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"Last Trade Date")
Last Trade Time=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"Last Trade Time")
Price=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"Price")
Change in Percent=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"Change in Percent")
PercentChange=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"PercentChange")
Percent Change=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"Percent Change")
ChangePercent=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"ChangePercent")
Change Percent=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"Change Percent")
% Change=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"% Change")
Ask Size=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"Ask Size")
Bid Size=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"Bid Size")
PrevClose=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"PrevClose")
PreviousClose=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"PreviousClose")
Previous Close=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"Previous Close")
DaysRange=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"DaysRange")
Days Range=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"Days Range")
YearLow=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"YearLow")
YearHigh=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"YearHigh")
Year Low=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"Year Low")
Year High=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"Year High")
52WeekLow=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"52WeekLow")
52WeekHigh=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"52WeekHigh")
ChangeFromYearHigh=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"ChangeFromYearHigh")
ChangeFromYearLow=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"ChangeFromYearLow")
ChangeFrom52WeekHigh=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"ChangeFrom52WeekHigh")
ChangeFrom52WeekLow=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"ChangeFrom52WeekLow")
PercentChangeFromYearHigh=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"PercentChangeFromYearHigh")
PercentChangeFromYearLow=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"PercentChangeFromYearLow")
%ChangeFrom52WeekHigh=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"%ChangeFrom52WeekHigh")
%ChangeFrom52WeekLow=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"%ChangeFrom52WeekLow")
PercentChangeFrom52WeekHigh=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"PercentChangeFrom52WeekHigh")
PercentChangeFrom52WeekLow=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"PercentChangeFrom52WeekLow")
Avg Vol (3 Month)=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"Avg Vol (3 Month)")
AvgVol3Month=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"AvgVol3Month")
AverageDailyVolume=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"AverageDailyVolume")
Average Daily Volume=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"Average Daily Volume")
MarketCap=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"MarketCap")
EPS=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"EPS")
Diluted EPS=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"Diluted EPS")
DilutedEPS=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"DilutedEPS")
Forward P/E=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"Forward P/E")
ForwardPE=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"ForwardPE")
P/E=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"P/E")
PE=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"PE")
PERatio=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"PERatio")
PE Ratio=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"PE Ratio")
Trailing P/E=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"Trailing P/E")
TrailingPE=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"TrailingPE")
EPSEstCurrentYear=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"EPSEstCurrentYear")
EPS Estimate Current Year=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"EPS Estimate Current Year")
EPSEstimateCurrentYear=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"EPSEstimateCurrentYear")
Trailing Annual Dividend Rate=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"Trailing Annual Dividend Rate")
Trailing Annual Dividend Yield=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"Trailing Annual Dividend Yield")
Dividend Date=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"Dividend Date")
Company Name=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"Company Name")
Name=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"Name")
Stock Exchange=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"Stock Exchange")
priceBook=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"priceBook")
Price/Book=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"Price/Book")
RTD server values:
rtd_LastUpdate=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"rtd_LastUpdate")
rtd_LastUpdateDate=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"rtd_LastUpdateDate")
rtd_LastUpdateTime=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"rtd_LastUpdateTime")
rtd_LastError=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"rtd_LastError")
rtd_LastMessage=RTD("market.rtd",,"YahooFinanceQuotes",[Symbol],"rtd_LastMessage")

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.