Sharing Daily Trading Journal Setup - futures io
futures io



Sharing Daily Trading Journal Setup


Discussion in Trading Journals

Updated
    1. trending_up 3,287 views
    2. thumb_up 5 thanks given
    3. group 1 followers
    1. forum 5 posts
    2. attach_file 2 attachments




Welcome to futures io: the largest futures trading community on the planet, with well over 150,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
 

Sharing Daily Trading Journal Setup

(login for full post details)
  #1 (permalink)
 jonesr9 
FL
 
Experience: Intermediate
Platform: NinjaTrader
Trading: ES, 6E, CL
 
Posts: 71 since Jul 2009
Thanks: 159 given, 34 received

Thought I would share my journal that I use on a daily basis. This is still a work in progress b/c (as allot of you already know from my previous post) that I'm rebuilding my system after losing all of my data.

I believe in automating as much as possible to eliminate the need for extra leg work when it's not necessary. This journal is designed for E-Minis only and can be modified for anything that you would like to use it for. Of course, you would have to make the changes and reprogram the Macro code(VBA Code).

Worksheet Names and what they stand for:
JE - Jul 2009 ------ Journal Entries for the month of July. I added some example data.

JR - Jul 2009 ------ Journal Records for the month of July. Only updates from the beginning of the month to the current date. Does not update past todays date. You can clear out the data(except for the dates) and Update the worksheet again if you had made adjustments/changes to your Journal Entries.

On the Journal Entries worksheet, any part of the header(in light yellow) can be changed. Everything else updates automatically. When trading Multiple Contracts, use the alphabet to indicate groupings of contracts traded for a trade. The reason for this is that each contract can have its own exit point. Start out using "a" then "b" then "c" etc...for groupings. I already used "a" so the next multi-contract trade would use "b". If not trading multiple contracts then just leave the field blank.
For Long Trades I use "Lng" and for Short Trades I use "Shrt". Not sure why I abbreviated these but after awhile you'll get used to them. If not, just modify the code and you'll be all set.

When creating a new day in the Journal Entries, just copy the gray colored line and place it after your last trade, then type in the next trading days date. Now you are all set for the next trading day.

When a new month comes along, just copy the worksheets into the new months worksheet, rename it(using the abbreviated names), and create the trading dates(in the Journal Records) and create the first trading day in the Journal Entries. It's easier than you think. Once done you can always copy and create additional months ahead of time.

If the macro doesn't work, you'll need to change your security settings within Excel to medium so that you can enable the macro to work.

It's always a work in progress as new things appear or old ways just need to be modified. Hope this helps anybody new or old to Trading.

Rich

Started this thread Reply With Quote
The following 3 users say Thank You to jonesr9 for this post:

Can you help answer these questions
from other members on futures io?
Market on Close data within IB
Platforms and Indicators
in depth understanding of last, bid, and ask volume in c …
NinjaTrader
How to pay for market data with Dorman LLC
NinjaTrader
Big Mo Indicator for NT8
NinjaTrader
help with take profit several targets
TradeStation
 
Best Threads (Most Thanked)
in the last 7 days on futures io
Is anyone actually making money?
88 thanks
An embarrassing, honest confession
25 thanks
ApexTraderFunding.com experience and review
8 thanks
Sierra vs. Ninja : why I chose .....
8 thanks
Want your NinjaTrader indicator created, free?
7 thanks
 
(login for full post details)
  #2 (permalink)
 jonesr9 
FL
 
Experience: Intermediate
Platform: NinjaTrader
Trading: ES, 6E, CL
 
Posts: 71 since Jul 2009
Thanks: 159 given, 34 received

I'm looking to add one other page in this journal. It will be similiar to the monthly worksheet but instead take all monthly data and incorporate it into one Main worksheet. This will give you an overall performance perview on how your trading direction is really going. Feel free to download and/or make changes.

Started this thread Reply With Quote
 
(login for full post details)
  #3 (permalink)
 jonesr9 
FL
 
Experience: Intermediate
Platform: NinjaTrader
Trading: ES, 6E, CL
 
Posts: 71 since Jul 2009
Thanks: 159 given, 34 received


Okay, here’s an updated version of my Trading Journal. I’ve added all the spreadsheets for the rest of the year 2009 including Main 2009. Main 2009 just combines all the months information into one worksheet. This is nice because you don’t have to go searching month to month to look up information.

Started this thread Reply With Quote
The following 2 users say Thank You to jonesr9 for this post:
 
(login for full post details)
  #4 (permalink)
 benharrell 
Pittsburgh, Pa
 
Experience: Intermediate
Platform: Ninjatrader
Broker: Zen-Fire
Trading: CL,ES,6E
 
benharrell's Avatar
 
Posts: 235 since Aug 2009
Thanks: 350 given, 96 received

Hi Rich,

I'm always a sucker for a good excel file. Thanks for posting. I'll use this to keep track of my trading. This tool will change the way I reflect on my trading.

Awesome!

-BH

Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #5 (permalink)
 jonesr9 
FL
 
Experience: Intermediate
Platform: NinjaTrader
Trading: ES, 6E, CL
 
Posts: 71 since Jul 2009
Thanks: 159 given, 34 received

Hello Everyone,

Added a couple of columns of data on the JR(Journal Records) pages. Cleaned up the Headers as well. I added ROI(Return On Investment) on the JE(Journal Entry) pages.

Feel free to download and/or make changes. I'm always opened for sugguestions.

-Rich

Attached Files
Register to download File Type: zip Copy of Trading Journal.zip (315.6 KB, 36 views)
Started this thread Reply With Quote
 
(login for full post details)
  #6 (permalink)
 jonesr9 
FL
 
Experience: Intermediate
Platform: NinjaTrader
Trading: ES, 6E, CL
 
Posts: 71 since Jul 2009
Thanks: 159 given, 34 received

Hello Everyone,

I removed "Over All Performance" on the "JR" pages and added "Over All Winners" and "Over All Losers" in a percentage format. "Over ALL Performance" was kindof misleading if you didn't know how to read it so "Over All Winners" and "Over All Losers" should clear things up.

-Rich

Attached Files
Register to download File Type: zip Revised Trading Journal On 20090821.zip (316.2 KB, 46 views)
Started this thread Reply With Quote


futures io Trading Community Trading Journals > Sharing Daily Trading Journal Setup


Last Updated on August 21, 2009


Upcoming Webinars and Events
 

NinjaTrader Indicator Challenge!

Ongoing
     



Copyright © 2023 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