I'm a high school technology teacher and sponsor for the Charity Student Investment Project. Currently our students track our investment portfolio via a google spreadsheet (http://charitystudentinvestmentproject.com/index.php/portfolio) that calculates unrealized capital gain, total ROI (excluding dividend payments), market value, etc..
We are looking for a solution that will allow us to track the 'total return' including dividend payments for our entire portfolio and each individual investment. A bonus feature would be the ability to share the report on the internet, but this feature is not a requirement.
Any suggestions for free or low-cost solutions for calculating 'total return', including dividend payments?
Basically, I want a solution that 'automatically' calculates (total dividend payments + unrealized gain) to show the 'total return' of a current investment.
A little background on the Charity Student Investment Project. We are a high school student organization and part of a 501 c3. Our mission is to teach students about personal finance and how to invest in the stock markets via real-world experience and actively managing a real-money student-managed investment portfolio.