NexusFi: Find Your Edge


Home Menu

 





Trading Journal example (Excel spreadsheet)


Discussion in Psychology and Money Management

Updated
      Top Posters
    1. looks_one Mindset with 4 posts (6 thanks)
    2. looks_two cclsys with 3 posts (6 thanks)
    3. looks_3 Big Mike with 2 posts (69 thanks)
    4. looks_4 AfewUniversesBelo with 2 posts (0 thanks)
      Best Posters
    1. looks_one Big Mike with 34.5 thanks per post
    2. looks_two StockJock with 14 thanks per post
    3. looks_3 wh with 3 thanks per post
    4. looks_4 Mindset with 1.5 thanks per post
    1. trending_up 68,368 views
    2. thumb_up 112 thanks given
    3. group 33 followers
    1. forum 24 posts
    2. attach_file 11 attachments




 
Search this Thread

Trading Journal example (Excel spreadsheet)

  #21 (permalink)
 tedposobiec 
Grand Rapids Michigan
 
Experience: Beginner
Platform: Ninja Trader
Trading: OIL
Posts: 1 since Jan 2012
Thanks Given: 6
Thanks Received: 0

This is one of the things that I need to keep up with and doing this is a nice excel sheet I will add this to my daily trading.


Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Trade idea based off three indicators.
Traders Hideout
How to apply profiles
Traders Hideout
Better Renko Gaps
The Elite Circle
Pivot Indicator like the old SwingTemp by Big Mike
NinjaTrader
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Spoo-nalysis ES e-mini futures S&P 500
41 thanks
Just another trading journal: PA, Wyckoff & Trends
30 thanks
Tao te Trade: way of the WLD
24 thanks
Bigger Wins or Fewer Losses?
23 thanks
GFIs1 1 DAX trade per day journal
21 thanks
  #22 (permalink)
 AfewUniversesBelo 
Bel Air, Maryland
 
Posts: 22 since Jul 2017

Hello,

After an interest in weather all of my life, I surprisingly pursued weather forecasting after 1997-8. My interest was long range experimental. Thoughts went into space and mathematical angles planets as a 3-way geometry, predicting infinite time, or to compare global warming, but no interest in computer programming and these ideas were solo, so I found futures trading goals to be something to pass the time (money). This began in 2010 and in 2011 I was trading an account worth $80,000. In the beginning, made it as high as $220,000, which is enough to cover what would have been college, then the account dropped on some identified as anomalous activity. For the next few years, I went through some pretty odd experiences considering my person: Homelessness, jail, eventually mental hospital, all while attempting to plot futures data with money making goal in mind. I knew how to trade the futures in this time, but "energies" made it need to be science-based for presentation, and my laziness because life is always enjoyable. <3

After returning to family in 2015, I began to "heal" . In this time, I focused a serious effort on the market. 154,381 data points plotted, from most of 32 Futures in the time periods of 1day, 2day, 3day, 4day, 1week (thinkorswim). The result was what I expected: in the +/+ part of an X-Y graph, the next day had probability for positive price and a linear opposite correlation on the reverse side, -/-. See image below.



Of course, separated for grains-grains, currencies-currencies. It became silly plotting the market, because running positives were positive and running negatives,. The market is, on average, advantageous.

My research of mathematical studies showed one to be best in opposition of the market. This is what I began practice trading on November 18, 2016. The practice trade account, with TD Ameritrade was worth $100,000. Every day, moves were made, and most trades were reverse-pattern predictions. I have to be honest when I say that when my practice trade account moved into times when good presentation could become possible, I learned so much. Good-Bad, the significance of meditation. 173 trading days later, this same account is worth $645,000. 97 days have been positive days, 76 days negative. This is 15-20% chance. With average standard deviation of +6%, 15-20% also. I would like to be top 5%, which it was before the last 2-3 weeks. (has been a peaceful time but generally disinterested in the market).

This is my practice trade results:





173 days, 8 months and 6 days.

This doesn't include the statistical method which is still a work in progress because I don't have a computer fast enough to manage the level of Excel computing. It's 99% complete. The program is more than 400mb, and government record makes it difficult to get a short term job to afford better computer. Can trade futures well. Always open and willing to learn more.

Reply With Quote
  #23 (permalink)
aw2636
RIYADH
 
Posts: 1 since Apr 2018
Thanks Given: 0
Thanks Received: 0


Nice one. It would have been better if items were described.




cclsys View Post
Not saying this is excellent but might give someone a start. Has rudimentary stats section that stays at top of page. (Need to delete all my entries but make sure to keep the formulas! Some of the early columns have less in them than the latest ones so best to paste in the formulas from the bottom columns into a top column underneath the stats before deleting the other entries.


Reply With Quote
  #24 (permalink)
FuturesRus
Edmonton, Alberta
 
Posts: 2 since Feb 2020
Thanks Given: 2
Thanks Received: 0


Shivaya View Post
One of the most useful figures I want to know is my Profit Factor. When I can trade a strategy with a PF over 2.0 I know I can compound it.

Most systems are below 1.5

Another figure that gives me confidence in my strategy is in the number of trades to recover from a drawdown. Experience shows me this wants to be no greater 25 trades. So when you take a trade that sends you into a hole and you can get out of that hole inside 25 trades all is OK.

If it takes longer than that your edge needs sharpening.

So a PF above 2.0 will most always recover a drawdown in less than 25 trades.

Cheers.

Shivaya

Sounds like a great nugget of info to incorporate into a trading plan, thanks for sharing Shivaya.

Reply With Quote
  #25 (permalink)
Trading in Canada
Burlington, ON Canada
 
Posts: 66 since Feb 2021
Thanks Given: 17
Thanks Received: 30

Thank you sooo much for that template. I have been struggling how to have a smart quick journal system and you just provided the answer


Big Mike View Post
First, I encourage you to journal your trades here on the forum. By doing so you'll take your trading to a whole new level, you can read more why I think so here:


Now if you are unwilling to do that then at least journal your trades in a spreadsheet, one is provided below.

This journal needs to reflect what actually happened. There is no benefit to CYA here (covering your ass). Let it all hang out, you've got to be honest with yourself.

Most any trader can come up with a set of trading rules that, if followed, will be profitable. The problems occur when those rules are not followed, which is the majority of the time for many traders. By journaling, you can go back and see exactly which trades worked, and which failed. Then, out of those that worked, how many followed your rules? etc.

Once you become profitable, the journal can take you to the next level -- determining which of your setups or which trading rule is working best for you, and which is working the worst. Basically you can use the journal to optimize your trades.

I welcome your input on how to improve this journal. I hope to see you posting on the Journal section of the forum, or at least using this spreadsheet! The version of the spreadsheet I have attached allows you to enter "Entry reasons" and "Exit reasons" as a pre-defined list that will be available via a drop-down menu when you are entering trades. Look at the screen shot for an example.

Attachment 508

Tip


Edit: Check here for a more detailed journal in excel:






Mike


Reply With Quote




Last Updated on August 15, 2023


© 2024 NexusFi™, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
All information is for educational use only and is not investment advice. There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Privacy Policy - Downloads - Top
no new posts