Portfolio Performance: N.A.

[chris319]

In the Portfolio Performance report I am getting N.A. in the %Gain column for just one security. All of the other securities have what appear to be valid %Gain values. There is a valid value in the adjacent Gain column for the security in question.

What are the likely causes of the N.A. and is there a fix? I have checked the extrapolation period and found nothing amiss.

Thank you.

[Mark]

Hi chris319,

Select "Help / Logs / Report Calculation..." and you should get an explanation. Let me know if you need further clarification once you read that.

[chris319]

Hi chris319,

Select "Help / Logs / Report Calculation..." and you should get an explanation. Let me know if you need further clarification once you read that.

There is no Report Calculation menu item in the Help -> Logs menu.

[Mark]

Hi chris319,

Make sure you are in the report in question, and then it will be there. If you're in a non-report window (Portfolio Editor or Graph), you won't see Report Calculation....

[chris319]

Here is what the log says:

Unable to calculate %Gain for TQQQ due to non-positive OOP basis (-66830.17)
Unable to calculate %Gain-V for TQQQ. Beginning value is zero or negative (0.00)
Unable to calculate ROI for investment CASH_BAL for dates 4/17/2017 - 12/21/2021. (Negative share balance for investment "CASH_BAL" between 4/16/2017 and 12/21/2021.)
Unable to calculate %Gain for CASH_BAL due to non-positive OOP basis (-24656.60)
Unable to calculate %Gain-V for CASH_BAL. Beginning value is zero or negative (0.00)
Unable to calculate ROI for sub-portfolio Margin Account for dates 4/17/2017 - 12/21/2021. (Unable to solve object yield equation)
Unable to calculate %Gain-V for Margin Account. Beginning value is zero or negative (0.00)

[Mark]

Did you have any remaining questions after reading that log? If you're wondering about the negative OOP basis restriction on %Gain calculations, see the documentation here:

https://www.fundmanagersoftware.com/hel ... n_oop.html

The denominator of this equation is your OOP basis. As the OOP basis goes to zero, the %Gain approaches infinite. When the OOP basis is negative, the %Gain is reported as N.A..

[chris319]

For some reason I can't make the N.A. go away.

Forget it. I'll use Excel to calculate my IRR.