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 67,987 views
    2. thumb_up 112 thanks given
    3. group 33 followers
    1. forum 24 posts
    2. attach_file 11 attachments




 
 

Trading Journal example (Excel spreadsheet)

(login for full post details)
 
 
Big Mike's Avatar
 Big Mike 
Manta, Ecuador
Site Administrator
Developer
Swing Trader
 
Experience: Advanced
Platform: Custom solution
Broker: IBKR
Trading: Stocks & Futures
Posts: 50,241 since Jun 2009
Thanks Given: 33,109
Thanks Received: 101,362

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 the community or contact our Help Desk

Quick Links: Change your Username or Register as a Vendor


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


Lifetime Elite Membership: Sign-up for only $149 USD
Receive exclusive offers from our Site Sponsors: Browse Offers
Report problems with the site: Using the NexusFi changelog thread
Attached Files
Register to download File Type: xlsx BMT Trading Journal.xlsx (10.4 KB, 2098 views)
Follow me on Twitter Visit my NexusFi Trade Journal Started this thread

Can you help answer these questions
from other members on NexusFi?
ZombieSqueeze
Platforms and Indicators
Futures Close-Out Policy
Commodities
The space time continuum and the dynamics of a financial …
Emini and Emicro Index
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
Request for MACD with option to use different MAs for fa …
NinjaTrader
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Supertradersams Thread Journal on NQ/MNQ
32 thanks
Daytrading ES & NQ
29 thanks
Spoo-nalysis ES e-mini futures S&P 500
28 thanks
Just another trading journal: PA, Wyckoff & Trends
28 thanks
Deaddogs Stock Trading
21 thanks

(login for full post details)
 
 
sharp2be's Avatar
 sharp2be 
Canada
 
Experience: Advanced
Platform: NT, TS
Broker: Amp
Trading: ES
Posts: 57 since Sep 2009
Thanks Given: 1
Thanks Received: 69

Great ! Thanks Mike.

Visit my NexusFi Trade Journal
(login for full post details)
 
 
cclsys's Avatar
 cclsys 
Sydney, NS
 
Experience: Intermediate
Platform: Ninja
Broker: Zen-Fire
Trading: TF,S,GC
Posts: 605 since Nov 2009
Thanks Given: 248
Thanks Received: 393


how does one open an xlsx file?

Visit my NexusFi Trade Journal
(login for full post details)
 
 
Mindset's Avatar
 Mindset 
Singapore
 
Experience: Intermediate
Platform: NT
Broker: ib
Trading: MES
Posts: 365 since Sep 2009
Thanks Given: 90
Thanks Received: 291

You need excel 2007 or beyond to open xlsx files.

(login for full post details)
 
 
wh's Avatar
 wh 
Neubrandenburg, Germany
 
Experience: Advanced
Platform: R
Trading: Stocks
Posts: 538 since Jun 2009
Thanks Given: 298
Thanks Received: 512

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.
(login for full post details)
 
 
Mindset's Avatar
 Mindset 
Singapore
 
Experience: Intermediate
Platform: NT
Broker: ib
Trading: MES
Posts: 365 since Sep 2009
Thanks Given: 90
Thanks Received: 291

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, 550 views)
The following 4 users say Thank You to Mindset for this post:
(login for full post details)
 
 
cclsys's Avatar
 cclsys 
Sydney, NS
 
Experience: Intermediate
Platform: Ninja
Broker: Zen-Fire
Trading: TF,S,GC
Posts: 605 since Nov 2009
Thanks Given: 248
Thanks Received: 393

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 NexusFi Trade Journal
(login for full post details)
 
 
Mindset's Avatar
 Mindset 
Singapore
 
Experience: Intermediate
Platform: NT
Broker: ib
Trading: MES
Posts: 365 since Sep 2009
Thanks Given: 90
Thanks Received: 291

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

(login for full post details)
 
GolferDude
Las Vegas, NV
 
Posts: 3 since Dec 2009
Thanks Given: 0
Thanks Received: 2

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

(login for full post details)
 
 
wh's Avatar
 wh 
Neubrandenburg, Germany
 
Experience: Advanced
Platform: R
Trading: Stocks
Posts: 538 since Jun 2009
Thanks Given: 298
Thanks Received: 512


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, 925 views)
The following 6 users say Thank You to wh for this post:

 




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