I have looked far and wide for a good site to use to track my portfolio on. At first I tried Google's, but theirs needs lots of improvement. They recently updated it to allow partial shares beyond 2 decimals (that right there was a major deal breaker - since my mutual funds in my 401k are done to 3 decimals the amounts never were correct). Also, it is a pain entering information (the import tool has never worked).
Yahoo's tool was a little better, but still very tedious to add information to. I tried Morningstar's, e-trades', Bloomberg's, and MSNmoney's. Bloomberg's was nice because it would break it down into the individual transactions (so that you could see what each transaction resulted in), but it limited you to 20 entries per portfolio (not 20 stocks, 20 entries!) and you were limited to 5 portfolios. That made it useless.
The main problem I found with most of them was concerning the entry of your data. None of them had any kind of bulk entry - so if you had a lot of transactions to enter it would take forever - entering each one individually, then clicking next, then repeating it over and over.
So I came up with my own. The layout of the spreadsheet I based on one I found from Dividends4life, so I feel I should give credit to where credit is due. But I did modify it quite a bit to meet my needs (and you are welcome to take this and modify it for your needs). You can find the portfolio on Google Docs
here. If you would like a copy of it as an *xls file, just send me an e-mail.
Each stock gets it's own tab. The first tab contains a summary of each one. This is also where I enter the current price for each stock (and it's updated on the individual tabs). This main tab shows me the basic information - how many shares, how much I've invested, my dollar average per share, the current value, and how much have I gained/loss. Since I am a dividend investor I also included the annual dividend amount and the percentage of that amount each stock makes up. The next three columns record any amounts that will effect my taxes - and there's a a different column for each type. Next are to percentages - the first one is how much they cost me, the 2nd column is how much they currently make up of my portfolio, and the color of the text will change depending on the percentage.
The tabs for each stock are all set up the same. All the current values are derived from the main tab. Up at the top you'll find an summary of the stock. To the right is information on the dividend - you just enter in the # of times a year dividends are paid and the current amount, and it calculates the amounts. Importing this file into Google Docs seems to have changed the # of times the dividend is paid into a $ amount, but the result is still the same.
I use different background colors for different types of transactions. Purchases are the normal background color, dividends are a teal blue, etc.
I've also found it helpful to me to have a spot that I can put in the current dividend information - the declaration date, ex-date, etc, so I know when the dividend is due. When you enter a transaction there are two spaces between the Activity and the Shares to put in a note if needed. You enter the # of shares, the total dollar amount invested and the commision (if any) and it calculates the rest. I got the idea for the gain/loss from Bloomberg's portfolio. So you can see the results for each transaction you made. Also, if you were to sell the stock, this ends up telling you how much you stopped yourself from loosing (or gaining). This will also tell you your current yield on purchase, so 3 years down the road when you have added a ton of purchases and the company has increased its dividend several times you'll be able to see what your yield ended up being for each specific transaction. The Cumulative section lets you see how you've averaged down (or up) in your average purchase price. Lastly, the Percent of Portfolio lets you see the results of each transaction compared to your portfolio as a whole.
Though not included in this file I have also made an additional tab for my main portfolio that I record any selling/dividends/options, etc. On this tab I have separate columns for the types of dividends, any taxes paid for dividends from Canadian stocks, capital gains (both long and short term), losses, options, etc. Since I have 3 different brokers (Schwab, Sharebuilder, and Zecco) this allows me to have everything all together.
I also have another tab where I have entered each stock's sector, industy, and market cap, and I am able to see what my portfolio consists. The beauty of making your own portfolio manager is that it is so highly customizable.
If you do use my file and change it, I'd love to see what you do with it - maybe it's something I can use with mine, too.