I downloaded Mike’s spreadsheet and modified it a little to suit my needs and added some conditional coloring to indicate the level of profit/loss, etc. (added coloring to make it more fun)
Also, I prefer having my documents online as much as possible so I converted this to a Google docs spreadsheet. You can view/copy this sheet with some sample data here
I see a lot of scope to improve this over time and make it more valuable by adding advanced charting, integrating it with Google Finance, etc. If you have any suggestions, do let me know at trader.jedi at the rate gmail dot com
To know more about the columns used, calculation, etc., read trader Mike’s original entry here
