Pull major and cross currency pairs into Excel with Yahoo Finance FX tickers. Refresh the sheet whenever you need updated rates for trading, treasury or multi-currency portfolios.
EURUSD=X)=EPF.Yahoo.Price("EURUSD=X") in a cell
=EPF.Yahoo.Price("EURUSD=X")=EPF.Yahoo.Price("GBPUSD=X")=EPF.Yahoo.Price("USDJPY=X")=EPF.Yahoo.Historic.Close("EURUSD=X","1 Jan 2019")
Step-by-step tutorial for live and historic FX rates in Excel.
See automatic currency conversion inside a live portfolio sheet.
Yes. Excel Price Feed uses standard Yahoo Finance FX formulas such as =EPF.Yahoo.Price("EURUSD=X") to pull live currency exchange rates into Excel cells. No VBA macros are required.
Yahoo Finance FX pairs use ticker symbols ending in =X, for example EURUSD=X or GBPUSD=X. Pass the ticker to =EPF.Yahoo.Price to return the live exchange rate. See the FX formula reference.
Yes. Multiply each holding's local market value by the live FX rate formula for that currency pair so P&L and totals roll up into a single base currency. The Investment Portfolio tutorial shows automatic currency conversion in practice.
No. Yahoo Finance FX rates are included with Excel Price Feed and do not require a Yahoo account or API key.
Yes. Use historic close formulas such as =EPF.Yahoo.Historic.Close("EURUSD=X","1 Jan 2019") to pull past FX rates into Excel for reporting and backtesting.
Yes. The Live Exchange Rates tutorial walks through building an FX rate table in Excel with live Yahoo Finance formulas and historic rates.