(XLS) Trading Journal Spreadsheet Template

16. July 2009
Comments (0)

Excel Spreadsheet:  This is an example trading journal spreadsheet (with an example entry) that I personally use. Feel free to modify it all you want and share it with whomever. 

  • The gray columns are automatically generated from the other data entered (day of week from the date and the risk from the entry and stop). 

  • "Pot Result" is the potential result if you want to record how the trade would've gone if you stuck to your rules or was a bit more patient and let it hit your targets. It is good to have these numbers to illustrate how patience can serve you well long-term... or not.

  • "Notes" is the free-form area to say whatever you were seeing that the time such as "risky trade", "exited too soon because of blah", "choppy with low volume, so I tightened my stops", etc. In other words, whatever the numbers don't tell you by themselves if you were to review the trade at a later date. 

 


  
 

Study

Disclaimer

By downloading and using any of our studies, you agree to the following disclaimer:  
 
Past performance is not necessarily indicative of future results. The risk of loss in trading commodities can be substantial. You should therefore carefully consider whether such trading is suitable for you in light of your financial condition.  
 
In considering whether to trade or to authorize someone else to trade for you, you should be aware of the following:
  • If you purchase a commodity option, you may sustain a total loss of the premium and of all transaction costs.
  • If you purchase or sell a commodity future or sell a commodity option, you may sustain a total loss of the initial margin funds and any additional funds that you deposit with your broker to establish or maintain your position.
  • If the market moves against your position, you may be called upon by your broker to deposit a substantial amount of additional margin funds, on short notice, in order to maintain your position.
  • If you do not provide the requested funds within the prescribed time, your position may be liquidated at a loss, and you will be liable for any resulting deficit in your account.
  • Under certain market conditions, you may find it difficult or impossible to liquidate a position. This can occur, for example, when the market makes a "limit move".
  • The placement of contingent orders by you or your trading advisor, such as a "stop-loss" or "stop-limit" order, will not necessarily limit your losses to the intended amounts, since market conditions may make it impossible to execute such orders.
  • The high degree of leverage that is often obtainable in commodity trading can work against you as well as for you. The use of leverage can lead to large losses as well as gains. This brief statement cannot disclose all the risks and other significant aspects of the commodity markets. Before you trade you should inquire about any rules relevant to your particular contemplated transactions and ask the firm with which you intend to trade for details about the types of redress available in both your local and other relevant jurisdictions.
 
 
neoTOOLBOX.com does not guarantee results, information, or EFS studies and scripts in any shape or form.