Excel Formula Reference: FX Rates

The Add-in provides comprehensive coverage of live currency exchange rates to enable currency conversion in Excel via simple formulas.

Yahoo Finance Excel Formulas FX Rates Summary

All of these formulas require just a currency pair code, for example: =EPF.Yahoo.Price("EURUSD=X")

If you don't know the currency pair symbol then you can use the search function on the Configuration Pane.

Formula Description
EPF.Yahoo.Price Current mid price.
EPF.Yahoo.DayChange Change in price today.
EPF.Yahoo.DayChangePercent Percentage change in price today.
EPF.Yahoo.PrevClose Previous market close price.
EPF.Yahoo.MarketOpen Market open price.
EPF.Yahoo.DayLow Day low.
EPF.Yahoo.DayHigh Day high.
EPF.Yahoo.52WeekLow 52 week low.
EPF.Yahoo.52WeekHigh 52 week high.
EPF.Yahoo.52WeekChange 52 Week Change in price (%).