NexusFi: Find Your Edge


Home Menu

 





Trade tracking spreadsheet


Discussion in Trading Journals

Updated
    1. trending_up 8,509 views
    2. thumb_up 12 thanks given
    3. group 3 followers
    1. forum 3 posts
    2. attach_file 1 attachments




 
Search this Thread

Trade tracking spreadsheet

  #1 (permalink)
 
Saroj's Avatar
 Saroj 
Arcata, CA
 
Experience: Intermediate
Platform: NinjaTrader
Trading: index futures, oil
Posts: 485 since Jun 2009
Thanks Given: 232
Thanks Received: 415

Attached is a spreadsheet that you can use as is, if the design suits your trading plan, or modify to fit. It is set up to collect data on sets of 25 trades each for analysis.

It assumes that a portion of a multiple contract trade will be exited on a target... all could be as well of course. It is derived from one that Paul Comoke (Woodie's group) published a number of years ago.

If you want to make modifications, you will need to understand a bit of Excel formula language... but feel free.

The first tab "Description" explains the fields.
The second tab "Criteria" shows my initial criteria (somewhat complex because I'm expecting to automate this - trying to replicate the brain isn't easy! )
The third tab "Sample Trade Sheet" shows the spreadsheet where I have entered a trade to show you how the spreadsheet computes other columns. (Note: don't use this one for your trades, use the corrected "Blank Trade Sheet")
The fourth tab "Blank Trade Sheet" is a blank sheet except that it is set up for CL. Be sure to make a copy so that you have a blank one for the next set of 25 trades.

Attached Files
Elite Membership required to download: Consolidation entry analysis.xls
Started this thread Reply With Quote

Can you help answer these questions
from other members on NexusFi?
My NT8 Volume Profile Split by Asian/Euro/Open
NinjaTrader
Better Renko Gaps
The Elite Circle
NexusFi Journal Challenge - April 2024
Feedback and Announcements
The space time continuum and the dynamics of a financial …
Emini and Emicro Index
New Micros: Ultra 10-Year & Ultra T-Bond -- Live Now
Treasury Notes and Bonds
 
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
39 thanks
NexusFi site changelog and issues/problem reporting
26 thanks
GFIs1 1 DAX trade per day journal
18 thanks
The Program
18 thanks
  #2 (permalink)
 
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,396 since Jun 2009
Thanks Given: 33,172
Thanks Received: 101,536

Looks good Saroj, thx for sharing.

The importance of a journal and a well written plan cannot be understated. In fact, I just finished making a lengthy video that talks about journals briefly. I'll be uploading it in a few minutes.

I like to be able to select from a pre-defined list for certain things, like maybe the instrument or the reason you entered or exited, or any number of uses. So in the journal I posted (not as sophisticated as yours) I created a simple way to plug in some pre-defined values that you can later select from a drop down list.

If anyone is interested in enhancing the two ideas and making them one, here is mine:


My hope is that more people will start to journal their trades. Privately at minimum, and publicly if they want to take it to the "next" level, as you can conquer a whole new set of obstacles once you have some more accountability from your peers.

Journaling is incredibly important!

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
Follow me on Twitter Visit my NexusFi Trade Journal Reply With Quote
  #3 (permalink)
 
Saroj's Avatar
 Saroj 
Arcata, CA
 
Experience: Intermediate
Platform: NinjaTrader
Trading: index futures, oil
Posts: 485 since Jun 2009
Thanks Given: 232
Thanks Received: 415


I am doing a trade analysis and finding errors in some of the calculations... I'll correct and repost later tonight.

Started this thread Reply With Quote
  #4 (permalink)
jamusued
Diamonda Bar, CA/USA
 
Posts: 21 since Jan 2013
Thanks Given: 4
Thanks Received: 11

Thanks for sharing. Is there a good free website to upload my trades and perform analysis?

Reply With Quote




Last Updated on May 14, 2013


© 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