I want to share my investment tracking spreadsheet. I experimented with several forms and concepts for worksheets to help me effectively track my returns before I settled on this. I'm quite happy with it.
Sheet 1 (use tabs at bottom to switch between sheets) simply tracks all the money I've fed into my investing accounts, and the current account values, and calculates my returns.
Sheet 2 has an entry for each investment that I have sold, and thus calculates the return on investment including comissions and fees. I update the sheet about once a week with current account values and any transfers, to see how I am doing. I date and save each time as a seperate file.
|