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



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 wh with 2 posts (6 thanks)
    4. looks_4 Big Mike with 2 posts (68 thanks)
      Best Posters
    1. looks_one Big Mike with 34 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 57,707 views
    2. thumb_up 110 thanks given
    3. group 31 followers
    1. forum 23 posts
    2. attach_file 11 attachments




Welcome to futures io: the largest futures trading community on the planet, with well over 125,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)
 Big Mike 
Site Administrator
Swing Trader
Data Scientist & DevOps
Manta, Ecuador
 
Experience: Advanced
Platform: Custom solution
Trading: Futures & Crypto
 
Big Mike's Avatar
 
Posts: 50,147 since Jun 2009
Thanks: 32,651 given, 99,028 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/

Visit other sites? Please spread the word about your experience with our community!
Attached Files
Register to download File Type: xlsx BMT Trading Journal.xlsx (10.4 KB, 1848 views)
Follow me on Twitter Visit my futures io Trade Journal Started this thread Reply With Quote

Can you help answer these questions
from other members on futures io?
RangeRider for NT8 V10
The Elite Circle
Simple code to end my indicator
NinjaTrader
Alternative to Mcginley Dynamic MA
Sierra Chart
How to Register my Company in this Platform
Stocks and ETFs
Tradestation 10 work offline
TradeStation
 
Best Threads (Most Thanked)
in the last 7 days on futures io
Vinny E-Mini & Algobox Review TRADE ROOM
283 thanks
Would you share your Holy Grail?
90 thanks
EURUSD M6E/6E Euro
63 thanks
Spoo-nalysis ES e-mini futures S&P 500
47 thanks
TST/OneUp/LeeLoo/Earn2Trade
17 thanks
 
(login for full post details)
  #2 (permalink)
 sharp2be 
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)
 cclsys 
Sydney, NS
 
Experience: Intermediate
Platform: Ninja
Broker: Zen-Fire
Trading: TF,S,GC
 
cclsys's Avatar
 
Posts: 607 since Nov 2009
Thanks: 248 given, 393 received


how does one open an xlsx file?

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

You need excel 2007 or beyond to open xlsx files.

Reply With Quote
 
(login for full post details)
  #5 (permalink)
 wh 
Neubrandenburg, Germany
 
Experience: Advanced
Platform: R
Trading: Stocks
 
wh's Avatar
 
Posts: 538 since Jun 2009
Thanks: 298 given, 506 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)
 Mindset 
Singapore
 
Experience: Intermediate
Platform: NT
Broker: ib
Trading: MES
 
Mindset's Avatar
 
Posts: 362 since Sep 2009
Thanks: 89 given, 290 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, 514 views)
Reply With Quote
The following 4 users say Thank You to Mindset for this post:
 
(login for full post details)
  #7 (permalink)
 cclsys 
Sydney, NS
 
Experience: Intermediate
Platform: Ninja
Broker: Zen-Fire
Trading: TF,S,GC
 
cclsys's Avatar
 
Posts: 607 since Nov 2009
Thanks: 248 given, 393 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)
 Mindset 
Singapore
 
Experience: Intermediate
Platform: NT
Broker: ib
Trading: MES
 
Mindset's Avatar
 
Posts: 362 since Sep 2009
Thanks: 89 given, 290 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)
GolferDude
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)
 wh 
Neubrandenburg, Germany
 
Experience: Advanced
Platform: R
Trading: Stocks
 
wh's Avatar
 
Posts: 538 since Jun 2009
Thanks: 298 given, 506 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, 861 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)


Last Updated on April 17, 2020


Upcoming Webinars and Events
 

NinjaTrader Indicator Challenge!

Ongoing
     



Copyright © 2021 by futures io, s.a., Av Ricardo J. Alfaro, Century Tower, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada), 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