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 wh with 2 posts (6 thanks)
    4. looks_4 Big Mike with 2 posts (69 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,193 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)

 
 
Big Mike's Avatar
 Big Mike 
Manta, Ecuador
Site Administrator
Developer
Swing Trader
 
Experience: Advanced
Platform: Custom solution
Broker: IBKR
Trading: Stocks & Futures
Frequency: Every few days
Duration: Weeks
Posts: 50,398 since Jun 2009
Thanks Given: 33,173
Thanks Received: 101,537

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
Searching for trading reviews? Review this list
Lifetime Elite Membership: Sign-up for only $149 USD
Exclusive money saving offers from our Site Sponsors: Browse Offers
Report problems with the site: Using the NexusFi changelog thread
Attached Files
Elite Membership required to download: BMT Trading Journal.xlsx
Follow me on Twitter Visit my NexusFi Trade Journal Started this thread

Can you help answer these questions
from other members on NexusFi?
New Micros: Ultra 10-Year & Ultra T-Bond -- Live Now
Treasury Notes and Bonds
Are there any eval firms that allow you to sink to your …
Traders Hideout
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
Better Renko Gaps
The Elite Circle
The space time continuum and the dynamics of a financial …
Emini and Emicro Index
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Get funded firms 2023/2024 - Any recommendations or word …
61 thanks
Funded Trader platforms
38 thanks
NexusFi site changelog and issues/problem reporting
26 thanks
GFIs1 1 DAX trade per day journal
19 thanks
The Program
18 thanks
 
 
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
 
 
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
 
 
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.

 
 
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.
 
 
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
Elite Membership required to download: BMT Trading Journal.xls
Thanked by:
 
 
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
 
 
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.

 
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

 
 
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
Elite Membership required to download: TRADING PLAN.doc

 



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