Trading Journal example (Excel spreadsheet) - futures io
futures io futures trading

Trading Journal example (Excel spreadsheet)

Discussion in Psychology and Money Management

Updated by FuturesRus
      Top Posters
    1. looks_one Mindset with 4 posts (6 thanks)
    2. looks_two cclsys with 3 posts (6 thanks)
    3. looks_3 wh with 2 posts (6 thanks)
    4. looks_4 Big Mike with 2 posts (66 thanks)
      Best Posters
    1. looks_one Big Mike with 33.0 thanks per post
    2. looks_two StockJock with 13.0 thanks per post
    3. looks_3 wh with 3.0 thanks per post
    4. looks_4 Mindset with 1.5 thanks per post
    1. trending_up 51,707 views
    2. thumb_up 107 thanks given
    3. group 29 followers
    1. forum 23 replies
    2. attach_file 11 attachments

Welcome to futures io: the largest futures trading community on the planet, with well over 100,000 members
  • Genuine reviews from real traders, not fake reviews from stealth vendors
  • Quality education from leading professional traders
  • We are a friendly, helpful, and positive community
  • We do not tolerate rude behavior, trolling, or vendors advertising in posts
  • We are here to help, just let us know what you need
You'll need to register in order to view the content of the threads and start contributing to our community.  It's free and simple.

-- Big Mike, Site Administrator

(If you already have an account, login at the top of the page)

Search this Thread

Trading Journal example (Excel spreadsheet)

(login for full post details)
  #21 (permalink)
Grand Rapids Michigan
Experience: Beginner
Platform: Ninja Trader
Trading: OIL
Posts: 1 since Jan 2012
Thanks: 6 given, 0 received

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 futures io?
The value of open of bar for specific time for code.
Capping Size in Tradestation
3x Fangdango
Traders Hideout
SC parameter optimization
Sierra Chart
Show bar number above each tick bar
EasyLanguage Programming
Best Threads (Most Thanked)
in the last 7 days on futures io
Lost & losing hope
25 thanks
VWAP for stock index futures trading?
19 thanks
Emini 4 Tick Scalp still valid?
17 thanks
Coronavirus COVID-19
17 thanks
Price Action Kewltech Style
15 thanks
(login for full post details)
  #22 (permalink)
Bel Air, Maryland
Posts: 22 since Jul 2017


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
(login for full post details)
  #23 (permalink)
Posts: 1 since Apr 2018
Thanks: 0 given, 0 received

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
(login for full post details)
  #24 (permalink)
Edmonton, Alberta
Posts: 2 since Feb 2020
Thanks: 2 given, 0 received

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.



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

Reply With Quote

futures io Trading Community Psychology and Money Management > Trading Journal example (Excel spreadsheet)

April 17, 2020

Upcoming Webinars and Events

Copyright © 2020 by futures io, s.a., Av Ricardo J. Alfaro, Century Tower, Panama, +507 833-9432,
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.
no new posts