This function returns a ratio representing the change in exchange rate for a given period. It can be used to adjust a stock's return to the base currency of your system. Simply multiply stock's return by the value returned using the same period. When the stock's currency and your system's currency are the same, it always returns 1.

Why is this function needed? Currency values, regardless of the date to which they're attributed, are all converted using the most recent exchange rate, (which is precisely the FXRate factor.) This is done to avoid currency changes from obscuring changes in financial data. This function accommodates use cases where changes in exchange rates are important.

Parameters:

bars: the period in trading days
offset: bar offset from the as-of date

Example:

To adjust a stocks 1Mo return (21 bars approximates one month), enter

Ret%Chg(21) * FXPerf(21)