I have been investing in UK stocks since 2008 almost 8 years now. Very keen to calculate my annualised portfolio returns inclusive of dividends over these years.
Is there an excel workbook someone as prepared already? Also if someone could guide what should be the best way to calculate these returns.
Is this a good place to start with
http://boards.fool.co.uk/how-to-calcula ... e#10784327 found it on the old fool forum?
Thanks in advance.
Got a credit card? use our Credit Card & Finance Calculators
Thanks to johnstevens77,Bhoddhisatva,scotia,Anonymous,Cornytiv34, for Donating to support the site
Portfolio Returns Excel
-
- Lemon Quarter
- Posts: 1584
- Joined: November 5th, 2016, 11:16 am
- Has thanked: 672 times
- Been thanked: 479 times
Re: Portfolio Returns Excel
I apologise but I can't load that link, I got an error message.
To monitor my performance in a way comparable to the indexes, I calculate both Accumulation and Income units for my dividend growth portfolio using an adapted version of pinchthepennies' unitisation spreadsheet here: http://lemonfoolfinancialsoftware.weebl ... folio.html
However it is very hard to work back in time with unitisation. Did you keep good records?
Best wishes
Mark.
To monitor my performance in a way comparable to the indexes, I calculate both Accumulation and Income units for my dividend growth portfolio using an adapted version of pinchthepennies' unitisation spreadsheet here: http://lemonfoolfinancialsoftware.weebl ... folio.html
However it is very hard to work back in time with unitisation. Did you keep good records?
Best wishes
Mark.
-
- Lemon Quarter
- Posts: 4179
- Joined: November 4th, 2016, 9:42 pm
- Has thanked: 999 times
- Been thanked: 1855 times
Re: Portfolio Returns Excel
ADrunkenMarcus wrote:I apologise but I can't load that link, I got an error message...
That's odd - it loads OK for me. Try the archived copy in the Wayback machine instead...
https://web.archive.org/web/20110713055 ... sort=whole
-
- Lemon Quarter
- Posts: 1584
- Joined: November 5th, 2016, 11:16 am
- Has thanked: 672 times
- Been thanked: 479 times
Re: Portfolio Returns Excel
Success!
And I now know the original works in Firefox but not Google Chrome.
Best wishes
Mark.
And I now know the original works in Firefox but not Google Chrome.
Best wishes
Mark.
Return to “Financial Software - Discussion”
Who is online
Users browsing this forum: No registered users and 10 guests