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)
  #1 (permalink)
Site Administrator
Manta, Ecuador
 
Experience: Advanced
Platform: My own custom solution
Trading: Emini Futures
 
Big Mike's Avatar
 
Posts: 49,061 since Jun 2009
Thanks: 31,668 given, 95,108 received

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.



Tip


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






Mike

We're here to help -- just ask

For the best trading education, watch our webinars
Searching for trading reviews? Review this list

Follow us on Twitter, YouTube, and Facebook

Support our community as an Elite Member:
https://futures.io/elite/
Attached Files
Register to download File Type: xlsx BMT Trading Journal.xlsx (10.4 KB, 1718 views)
Follow me on Twitter Visit my Facebook Visit my futures io Trade Journal Reply With Quote

Can you help answer these questions
from other members on futures io?
Degiro Negative Balance Advice
Traders Hideout
Show bar number above each tick bar
EasyLanguage Programming
QDEL
Stocks and ETFs
3x Fangdango
Traders Hideout
The Journey
Traders Hideout
 
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)
  #2 (permalink)
Canada
 
Experience: Advanced
Platform: NT, TS
Broker: Amp
Trading: ES
 
sharp2be's Avatar
 
Posts: 57 since Sep 2009
Thanks: 1 given, 69 received

Great ! Thanks Mike.

Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #3 (permalink)
Sydney, NS
 
Experience: Intermediate
Platform: Ninja
Broker: Zen-Fire
Trading: TF,S,GC
 
cclsys's Avatar
 
Posts: 607 since Nov 2009
Thanks: 248 given, 391 received


how does one open an xlsx file?

Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #4 (permalink)
Singapore
 
Experience: Intermediate
Platform: NT
Broker: ib
Trading: MES
 
Mindset's Avatar
 
Posts: 360 since Sep 2009
Thanks: 88 given, 287 received

You need excel 2007 or beyond to open xlsx files.

Reply With Quote
 
(login for full post details)
  #5 (permalink)
Neubrandenburg, Germany
 
Experience: Advanced
Platform: R
Trading: Stocks
 
wh's Avatar
 
Posts: 538 since Jun 2009
Thanks: 298 given, 503 received

or someone with 2007 convert down to 97. so all people can read the file.
but you can also open with open office.

Causality is the relationship between an event (the cause) and a second event (the effect), where the second event is a consequence of the first.
Reply With Quote
 
(login for full post details)
  #6 (permalink)
Singapore
 
Experience: Intermediate
Platform: NT
Broker: ib
Trading: MES
 
Mindset's Avatar
 
Posts: 360 since Sep 2009
Thanks: 88 given, 287 received

I am sure Mike has plenty to do so here is a 'normal' xls version - some formatting has been lost.

Attached Files
Register to download File Type: xls BMT Trading Journal.xls (21.0 KB, 498 views)
Reply With Quote
The following 4 users say Thank You to Mindset for this post:
 
(login for full post details)
  #7 (permalink)
Sydney, NS
 
Experience: Intermediate
Platform: Ninja
Broker: Zen-Fire
Trading: TF,S,GC
 
cclsys's Avatar
 
Posts: 607 since Nov 2009
Thanks: 248 given, 391 received

Thanks, Mindset. Do you know what those drop-down menus are called in Excel so I can find them in the Help index? I would like to learn how to make some in my own SS's but never saw them before and didn't know about them. I guess I must have seen them somewhere but never thought it was something an 'ordinary' user could make.

Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #8 (permalink)
Singapore
 
Experience: Intermediate
Platform: NT
Broker: ib
Trading: MES
 
Mindset's Avatar
 
Posts: 360 since Sep 2009
Thanks: 88 given, 287 received

well they are a form of combo box eg list but I haven't used them myself in excel.

Reply With Quote
 
(login for full post details)
  #9 (permalink)
Las Vegas, NV
 
 
Posts: 3 since Dec 2009
Thanks: 0 given, 2 received

FYI,

I have Excel 2003 on my Vista laptop and when I clicked on Mike's Excel spreadsheet it automatically did a conversion and then opened. I compared it to the one that Mindset had converted and they look the same, so evidently it lost some formatting when it did the conversion but the main point was that I was able to open it.

Bryan

Reply With Quote
 
(login for full post details)
  #10 (permalink)
Neubrandenburg, Germany
 
Experience: Advanced
Platform: R
Trading: Stocks
 
wh's Avatar
 
Posts: 538 since Jun 2009
Thanks: 298 given, 503 received


nice and simple

Causality is the relationship between an event (the cause) and a second event (the effect), where the second event is a consequence of the first.
Attached Files
Register to download File Type: doc TRADING PLAN.doc (26.0 KB, 819 views)
Reply With Quote
The following 6 users say Thank You to wh for this post:


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, info@futures.io
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