Trade Log Spreadsheet

My spreadsheet that I've personally developed and use on a daily basis. I thought it might help some people out considering how many people have downloaded my Calculator and my Success Notes.

The Basics:

• Win/Loss Percentage
• Average Gain/Loss in Dollar amounts and Percentage amounts
• Profit Per Share
• Percentage Gain/Loss of account as a whole
• Net profit
• And a lot more

Advanced Analysis:

• R Multiple for each trade
• Expectancy
• Profit Factor
• Equity Curve Chart
• Potential Profit per trade
• Potential Percentage gain per X amount of days (you can specify the time period)

I've spent a huge amount of time coming up with formulas to calculate this data. I'm constantly going over my stats to see where I'm at, where I'd like to be, what I need to do to get there based on how I'm performing, etc.

The boxes in Orange represent data fields that can be altered/entered in by the user. Everything else is automatically calculated and doesn't need to be touched. If you need any help with certain fields or don't know what a box means, leave me a comment and I'll help you out. The data that is currently in the spreadsheet is data I've made up as an example.

Help Files for the Spreadsheet: http://www.mediafire.com/?zny3wltgyli

Download here: http://www.mediafire.com/?71gec97eytm

I hope you enjoy my spreadsheet. I find a lot of joy and feel good when I share what I've created with people. Happy trading.

Thanks for subscribing to my feed!

Realization

I've been going over my trade logs to see if I can pin point why my success rate has been declining so much. It's gone from a 68% success rate to 52%. I've been going through a 6 trade losing streak over the last couple weeks, with minimal loses but that's not the point.

 

I found out why I haven't been trading so well. My average holding period for a stock during my peak success rate was 2 days. My average holding time for a stock during my losing streak was about 10 minutes. I obviously can't day trade. I don't have the resources to make it happen and I need to realize it and stop wasting my time and money forcing something that won't work.

 

I'm going back to my old plan of swing trading. This is a classic example of how greed takes control and the losses take over. I've been thinking about this a lot this morning after that bad trade I had and I was swing trading very well back in June, July, and August and then this mortgage crisis came into play and that's when I changed my plan. I started changing my trading time frame from swing trading to day trading to try and capitalize on the new market conditions. I shouldn't of done that. I should of stuck to my plan/trading style instead of modifying it for the current conditions. If I couldn't find any opportunities, then I shouldn't of traded. Simple as that.

 

This is a pretty big breaking point for me as far as my personal development as a trader goes. I'm glad I've gone through this experience. I needed this to help me realize my goals and to not deviate from the master plan! I'm going to do what I can to learn from this last months experience and make sure it doesn't happen again.

 

del.icio.us Tags: personal devolpment , trader psychology , trading plan