Excel Portfolio Tracker

I recently created a spread sheet to track my portfolio which I thought some other people may find useful. Should you be interested, you can download it here.

Its fairly self explanatory, simply enter div, buy or sell in the Trades worksheet and the spread sheet will (hopefully) work its magic!

Please let me know if you find it useful.


 
Press these:
What are they?

Related Posts:

  • No Related Post

Tags: , ,

23rd Jan 2006 Investing Tools Trackback


6 Comments

  • 1. Ole

    26th February 2006, 8:22 pm

    Hello! I noticed that you did not have any sales in your excample. How would that add up if you, for example sold 100 of the SCTN shares? The reason I ask is that in the “H” column of the “Current Holdings” sheet you only add the “Total buys” number.
    Thanks, Ole

  • 2. Iain

    27th February 2006, 5:55 pm

    Hi Ole, In the ‘trades’ sheet simply fill in another row, setting the action column to ’sell’. For dividends received, set the action column to ‘div’.? Sale proceeds are logged in column J, try viewing the hidden columns c,d,e and f.
    hope that helps.

  • 3. Ole

    27th February 2006, 6:56 pm

    Hi Iain, Thanks for making this spread sheet available. I still have a few problems. One is, where do I put the amount of money I have on my investment account? This number changes from day to day. The question in my previous message above is about the formula in the H-column of the “Current Holdings” sheet. You only copy the numbers from the “Total buys” column but i thought you also should subtract the numbers from the “Total Sells” column as well?
    Best Regards,
    Ole

  • 4. Iain

    28th February 2006, 4:07 pm

    Hi Ole,
    At the moment the spead sheet doesn’t track any monies that arn’t invested. I guess that you could always modify it to include a fake symbol to repersent any cash you have.

    To answer your previous question, the total buys column lists all shares ever bought in that stock, this allows an average price to be calcuated in the next column. The subtraction you are talking about occurs in the Profit column (N)

    I guess that if you are buying and selling lots of shares then this spreadsheet may not be for you as the shares you hold may change regularly and the profit etc only shows that for the current shares you hold. As I intend to hold shares for the long term this is not a problem for me (note that the annualised return takes into account everything and not just the current holdings).

  • 5. Richard

    3rd November 2006, 10:48 am

    Hi,

    It seems to be a well constructed spreadsheet (and the geeky part of me does love a well constructed spreadsheet). I don’t mean to be rude, but I am curious to why you made it, rather than using any one of a number of online portfolio tracking websites?

    Richard.

    PS - Blogrolled you, so I will be back for an answer *evil grin*

  • 6. Thomas

    9th February 2007, 7:00 am

    Hi Iain,

    Thanks for sharing your spreadsheet. Here’s a link to a simple “tool” that may also be helpful to your readers - a stock market holiday calendar. http://www.rightline.net/calendar/market-holidays.html

    Best,
    Thomas


Feed for this entry

Close
E-mail It