Access Real-Time Yahoo Finance Currencies in Excel

Access Real-Time Yahoo Finance Currencies in Excel

Overview

The YahooFinanceCurrencies provider delivers real-time foreign exchange (FX) data from Yahoo Finance directly into Microsoft Excel.

It supports major and exotic currency pairs, including USD, EUR, GBP, JPY, CHF, CNY, and others.

Use the following RTD formula:

=RTD("market.rtd",,"YahooFinanceCurrencies","<Ticker>","<Data Field>")

Example:

=RTD("market.rtd",,"YahooFinanceCurrencies","EURUSD=X","Last")

Supported Ticker Formats

For the EURUSD pair, you can use the following ticker formats:

  • EURUSD
  • UER/USD
  • EUR-USD
  • EUR_USD
  • EURUSD=X

You can find these codes in the Symbol1 - Symbol5 columns.

Use the Formula Builder to construct and copy formulas into Excel.

Customizing the Refresh Interval

By default, data refreshes every minute. To change this interval, use the following formula:

=RTD("market.rtd",,"YahooFinanceHistoricalPrices","rtd_RefreshInterval",1*60)

Data Fields and Excel Formulas

Data FieldExcel Formula
Symbol=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","Symbol")
language=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","language")
region=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","region")
quoteType=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","quoteType")
typeDisp=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","typeDisp")
quoteSourceName=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","quoteSourceName")
triggerable=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","triggerable")
customPriceAlertConfidence=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","customPriceAlertConfidence")
currency=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","currency")
regularMarketChange=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","regularMarketChange")
regularMarketDayHigh=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","regularMarketDayHigh")
regularMarketDayLow=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","regularMarketDayLow")
regularMarketPreviousClose=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","regularMarketPreviousClose")
bid=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","bid")
ask=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","ask")
regularMarketOpen=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","regularMarketOpen")
fiftyTwoWeekLow=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","fiftyTwoWeekLow")
fiftyTwoWeekHigh=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","fiftyTwoWeekHigh")
fiftyDayAverage=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","fiftyDayAverage")
twoHundredDayAverage=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","twoHundredDayAverage")
shortName=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","shortName")
longName=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","longName")
regularMarketPrice=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","regularMarketPrice")
regularMarketChangePercent=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","regularMarketChangePercent")
hasPrePostMarketData=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","hasPrePostMarketData")
firstTradeDateMilliseconds=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","firstTradeDateMilliseconds")
priceHint=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","priceHint")
regularMarketDayRange=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","regularMarketDayRange")
regularMarketVolume=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","regularMarketVolume")
bidSize=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","bidSize")
askSize=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","askSize")
fullExchangeName=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","fullExchangeName")
averageDailyVolume3Month=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","averageDailyVolume3Month")
averageDailyVolume10Day=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","averageDailyVolume10Day")
fiftyTwoWeekLowChange=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","fiftyTwoWeekLowChange")
fiftyTwoWeekLowChangePercent=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","fiftyTwoWeekLowChangePercent")
fiftyTwoWeekRange=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","fiftyTwoWeekRange")
fiftyTwoWeekHighChange=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","fiftyTwoWeekHighChange")
fiftyTwoWeekHighChangePercent=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","fiftyTwoWeekHighChangePercent")
fiftyTwoWeekChangePercent=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","fiftyTwoWeekChangePercent")
fiftyDayAverageChange=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","fiftyDayAverageChange")
fiftyDayAverageChangePercent=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","fiftyDayAverageChangePercent")
twoHundredDayAverageChange=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","twoHundredDayAverageChange")
twoHundredDayAverageChangePercent=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","twoHundredDayAverageChangePercent")
sourceInterval=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","sourceInterval")
exchangeDataDelayedBy=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","exchangeDataDelayedBy")
tradeable=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","tradeable")
cryptoTradeable=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","cryptoTradeable")
marketState=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","marketState")
corporateActions_0=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","corporateActions_0")
regularMarketTime=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","regularMarketTime")
exchange=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","exchange")
messageBoardId=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","messageBoardId")
exchangeTimezoneName=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","exchangeTimezoneName")
exchangeTimezoneShortName=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","exchangeTimezoneShortName")
gmtOffSetMilliseconds=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","gmtOffSetMilliseconds")
market=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","market")
esgPopulated=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","esgPopulated")
quoteResponse_error=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","quoteResponse_error")
Symbol1=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","Symbol1")
Symbol2=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","Symbol2")
Symbol3=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","Symbol3")
Symbol4=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","Symbol4")
Symbol5=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","Symbol5")
Avg Vol(3m)=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","Avg Vol(3m)")
StockExchange=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","StockExchange")
50-Day Moving Average=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","50-Day Moving Average")
52-Week High=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","52-Week High")
Change from 52-Week High=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","Change from 52-Week High")
% Change from 52-Week High=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","% Change from 52-Week High")
52-Week Low=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","52-Week Low")
Change from 52-Week Low=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","Change from 52-Week Low")
% Change from 52-Week Low=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","% Change from 52-Week Low")
Change=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","Change")
ChangeInPercent=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","ChangeInPercent")
High=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","High")
Low=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","Low")
Open=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","Open")
Prev Close=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","Prev Close")
Last=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","Last")
LastTradeDateTime=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","LastTradeDateTime")
Volume=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","Volume")
Name=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","Name")
200-Day Moving Average=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","200-Day Moving Average")
LastTradeDate=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","LastTradeDate")
LastTradeTime=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","LastTradeTime")
52-Week Range=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","52-Week Range")
Day's Range=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","Day's Range")
BidX=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","BidX")
AskX=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","AskX")
Synonyms:
Symb=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","Symb")
Company Name=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","Company Name")
CompanyName=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","CompanyName")
Last Trade DateTime=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","Last Trade DateTime")
Last Trade Date=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","Last Trade Date")
Last Trade Time=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","Last Trade Time")
Price=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","Price")
LastTradePriceOnly=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","LastTradePriceOnly")
PrevClose=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","PrevClose")
PreviousClose=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","PreviousClose")
Previous Close=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","Previous Close")
Percent Change=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","Percent Change")
PercentChange=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","PercentChange")
Change in Percent=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","Change in Percent")
ChangePercent=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","ChangePercent")
Change%=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","Change%")
% Change=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","% Change")
Ask Size=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","Ask Size")
Bid Size=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","Bid Size")
Year High=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","Year High")
Year Low=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","Year Low")
52WeekHigh=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","52WeekHigh")
52WeekLow=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","52WeekLow")
DaysHigh=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","DaysHigh")
DaysLow=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","DaysLow")
DaysRange=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","DaysRange")
Days Range=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","Days Range")
YearRange=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","YearRange")
Year Range=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","Year Range")
52wk Range=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","52wk Range")
52WeekRange=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","52WeekRange")
YearLow=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","YearLow")
YearHigh=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","YearHigh")
ChangeFromYearHigh=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","ChangeFromYearHigh")
ChangeFromYearLow=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","ChangeFromYearLow")
ChangeFrom52WeekHigh=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","ChangeFrom52WeekHigh")
ChangeFrom52WeekLow=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","ChangeFrom52WeekLow")
PercentChangeFromYearHigh=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","PercentChangeFromYearHigh")
PercentChangeFromYearLow=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","PercentChangeFromYearLow")
%ChangeFrom52WeekHigh=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","%ChangeFrom52WeekHigh")
%ChangeFrom52WeekLow=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","%ChangeFrom52WeekLow")
PercentChangeFrom52WeekHigh=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","PercentChangeFrom52WeekHigh")
PercentChangeFrom52WeekLow=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","PercentChangeFrom52WeekLow")
RTD server values:
rtd_LastUpdate=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","rtd_LastUpdate")
rtd_LastUpdateDate=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","rtd_LastUpdateDate")
rtd_LastUpdateTime=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","rtd_LastUpdateTime")
rtd_LastError=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","rtd_LastError")
rtd_LastMessage=RTD("market.rtd",,"YahooFinanceCurrencies","USDEUR=X","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.