My stock portfolio includes things I bought last month and things I bought 20 years ago. I've been trying to devise a report that tells what each has earned but I'd like to take time-owned into consideration. Right now I have a column for date of inception, and one for total gain (I am using Gain-C (end)) and one for total dividends received (Dist-C (end).
What I would like to do is create a total time owned variable (today's date minus inception date) and a total gain (Gain-C plus Dist-C) and then divide the gain by time so I can say, eg, this stock has returned $X.00 per year.
Is this feasible? Is Anything close to it feasible?