Checking Report - Custom Settings

[ThomasK]

Hi Mark,

I'm trying to understand the Custom Settings equations to make the best Custom report I can.

I created a Custom Report and I would like to verify/clarify the rightmost column: "Gain/s (end)" as Gain per share (inception) heading.

My issue is that for the first stock, Aurora Cannabis, there's no way the Gain/s (end) should be -$4.02 as there are no dividends/distributions. I checked the CASH account for that as well as the Data Register for the stock. Whereas the $5.37 for Bausch Health makes sense.

What do you think I am doing wrong? I don't need the column BUT I do want to figure it out.

Thanks,
Thomas

[Mark]

Hi Thomas,

That field starts from the very first price date recorded in the investment. Open up that investment in the Data Register, and look under "Prices" data type. How much has the price changed from the earliest recorded price to the report's ending date. It does not matter what the starting report date is for this report, thus the Beg NAV may be incorrect, as the formula uses the Beg NAV of the investment, not as of the report's starting date.