Calculating my portfolio's yield

[hendi_alex]

I really like Google Docs. Here are two views of my setup for calculating stock and portfolio yields. The second image shows the formulas that need to be typed in. This spreadsheet automatically updates the market price, but the dividend amounts have to be keyed in, as well as the tickers and the share count. All other fields are calculated.

I can't figure a way to post the images so will provide a link to my I.V. site to view the spreadsheet. If the link to I.V. doesn't work, let me know, and I'll figure another way to show the info, perhaps will give a link to the chart at the Google Docs site.

http://premium.investorvillage.com/group...d=13151537