%Gain-V (Inception) calculation

[Bsrr]

Hi Mark - I have tried to figure out why I am seeing what I think are incorrect calculated values in a custom report I created using the above Subject setting. Here is my example:

Stock purchased 1/13/25 for let's say $10K (example figures are a bit off of original but very close). One Dividend Reinvestment on 2/25/25 of $125. Another purchase of $15K on 3/11/25. Total OOP $25K. Value on 5/13/25 is 25.1K. But for the report I have using %Gain-V (inception) the values is 149.8. Ending date for the report is today 5/13/25. I have tried varying the starting date range (current month, Q or year for example) but assume that would not matter anyway as this computation uses the inception date of the investment. The investment price per share at inception was $20.90, the 5/13/25 price per share is $21.79 and the highest price during the inception date to 5/13/25 date range was $27.10

Can you advise how the %Gain-V (inception) would be 149.8? Is there something I am just not understanding correctly (I have read the definition of this setting and maybe I just don't understand)? I have other investments that seem "off" too by a lot and others that appear to be correct.

Thanks.

[Mark]

Hi Bsrr,

The price you paid and dividends don't directly come into play in this %Gain-V calculation. The only 2 numbers that matter are the market value at the beginning and the market value at the end. See the equation here:

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

This figure is the difference between market values, divided by the beginning market value. The ending market value is for the date of the report. For the %Gain-V (inception) figure the beginning market value is the market value on the date you first purchased. So, for example, if you purchased it originally on 1/13/25, the beginning market value would be whatever the investment was worth on the close of market that day.

To see these market values, you can also look in the Data Register under the "Prices" data type, and you'll see the daily market values under the "Value" column. Look at the market value on your report date, and then also on the date when you first bought it.

[Bsrr]

Hi Mark - OK this all makes sense now. I assumed there was something I was just not understanding regarding %Gain-V (Inception).

Also, in looking at Custom Settings choices I always read the definition and sometimes there is a formula in the definition as well. I did not think to also follow the links to the online help documentation for more detail.

One comment: I was also confused with the term "Gain" as meaning more like "I bought this for $100 and now it is worth $150 so my gain is 50%". I was not thinking also of additional purchases made during the time frame in question. I better understand "Gain" and its meaning going forward.

Thanks as always for the support.