ROI

[galway2]

Mark-

I have several investments that are returning N.A. for the ROI end and I cannot figure out why. Here is what I have checked:

The prices have been downloaded for all 4 investments well beyond the report range.

I have allowed interpolation prior to earliest recorded data.

I have disabled the enforce maximum interpolation range.

What am I missing?

Thanks-
Lisa G

[Mark]

Hi Lisa,

This all sounds good. Are you maybe annualizing yields for a term that is only a few days long? If so, this can cause very large numbers, that causes no yield to return. If this doesn't help, please email me one investment, along with instructions for reproducing the yield that you are calculating.