Is it possible to create a factor like IAD but not translated for currency? So the metric should return the same value regardless of the currency. I like to look at the rate of change of IAD to look for cuts and hikes, but when a company pays its dividends in another currency the change in fx takes over. Is this something that factset has available or is there a formula that could make sense?
This should return IAD in w/o currency conversion; IAD*FXRate.
Thanks, but that doesn’t look like it’ll work. I looked at QSR:CAN and AEM:CAN, for example, but FXRate was 1 for both whether or not I looked at the CAN or USA listings. I was looking at them in Fundamental Charts in case that matters.
My reply was focused on FXRate currency in screen/simulations.
I'm going to reconsider what you're trying to do,
Same results in the screener: FXrate doesn’t appear to be helpful here. More context - the screen is for Canada only, results in CAD. Many Cdn companies pay their dividends in USD. I’m comparing IAD vs IAD52W.
Ex.
QSR:USD IAD = 2.48, IAD52W = 2.32;
QSR:CAD IAD = 3.35, IAD52W = 3.36
I’d like to see, if possible, a version of IAD and IAD52W that is not impacted at all by currency so it would show 2.48 and 2.32 regardless of what currency is in the screen.
We're talking about different things here. FXRate works for screen/simulations currency settings. With the attached screen, @IADFX and @Close0FX always display CAD prices irrespective of the screener currency setting.
You want to account for the currency of the ticker's exchange. I don't see a way to do that.
