NexusFi: Find Your Edge


Home Menu

 





My Excel Journal TEMPLATE


Discussion in Trading Journals

Updated
      Top Posters
    1. looks_one tradergino with 2 posts (5 thanks)
    2. looks_two xplorer with 2 posts (3 thanks)
    3. looks_3 Quick Summary with 1 posts (0 thanks)
    4. looks_4 stumbras with 1 posts (0 thanks)
      Best Posters
    1. looks_one Bermudan Option with 4 thanks per post
    2. looks_two tradergino with 2.5 thanks per post
    3. looks_3 Marty087 with 2 thanks per post
    4. looks_4 xplorer with 1.5 thanks per post
    1. trending_up 9,461 views
    2. thumb_up 14 thanks given
    3. group 7 followers
    1. forum 7 posts
    2. attach_file 2 attachments




 
Search this Thread

My Excel Journal TEMPLATE

  #1 (permalink)
 Marty087 
Sydney NSW Australia
 
Experience: Intermediate
Platform: Ninjatrader 7 / MT4
Broker: KINETICK
Trading: EUR/USD, AUS200(SPI)
Posts: 40 since May 2012
Thanks Given: 15
Thanks Received: 98

Hi Guys,

I have been lurking around without much participation for too long, I recently had this journal template made up to make my market journalling easier. It is quick, no fuss way of managing multiple journals from the one worbook with automatic timestamping and the ablity to reference any image that may be stored in the IMAGES folder.

See the video for a breif description here

Hopefully some of you may find it helpful!

Cheers.

Marty.

Attached Files
You must login first File Type: zip JOURNAL.zip (40.5 KB, 605 views)
Started this thread Reply With Quote
The following 2 users say Thank You to Marty087 for this post:

Can you help answer these questions
from other members on NexusFi?
NexusFi Journal Challenge - May 2024
Feedback and Announcements
Request for MACD with option to use different MAs for fa …
NinjaTrader
Looking for an MQL4 MetaTrader programmer/coder
The Elite Circle
Ninja Trader 8 Drawing Tools Wanted
NinjaTrader
ZombieSqueeze
Platforms and Indicators
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Retail Trading As An Industry
51 thanks
NexusFi site changelog and issues/problem reporting
46 thanks
Battlestations: Show us your trading desks!
34 thanks
GFIs1 1 DAX trade per day journal
32 thanks
What percentage per day is possible? [Poll]
19 thanks

  #3 (permalink)
 tradergino 
Chicago, IL
 
Experience: Intermediate
Platform: Tradingview
Broker: AMP Futures
Trading: NQ
Frequency: Daily
Duration: Minutes
Posts: 38 since Jan 2012
Thanks Given: 15
Thanks Received: 39


Greetings,
I found this simple but elegant spreadsheet that i'd like to use for trading E-mini micro's. Ive inputed commission levels and $$ per tick ( that was easy and some sample trades in NQ. The limitation at this point is that it only calculates data for one contract ( I am trading 3). I am Excel ignorant so can somone please add a column that would reflect trading 3 or more contracts? Obviously, you are free to use/modify this spreadsheet if you wish. Many thanks.

Attached Files
You must login first File Type: xlsx GinoTradeSheetv1.xlsx (32.2 KB, 331 views)
Follow me on Twitter Reply With Quote
The following 5 users say Thank You to tradergino for this post:
  #4 (permalink)
 
xplorer's Avatar
 xplorer 
London UK
Site Moderator
 
Experience: Beginner
Platform: CQG
Broker: S5
Trading: Futures
Frequency: Never
Duration: Never
Posts: 5,924 since Sep 2015
Thanks Given: 15,417
Thanks Received: 15,231


tradergino View Post
Greetings,
I found this simple but elegant spreadsheet that i'd like to use for trading E-mini micro's. Ive inputed commission levels and $$ per tick ( that was easy and some sample trades in NQ. The limitation at this point is that it only calculates data for one contract ( I am trading 3). I am Excel ignorant so can somone please add a column that would reflect trading 3 or more contracts? Obviously, you are free to use/modify this spreadsheet if you wish. Many thanks.

With this spreadsheet structure, adding a column with number of contracts would imply that you always will go all-in and all-out.

Is this the case?

Reply With Quote
  #5 (permalink)
 tradergino 
Chicago, IL
 
Experience: Intermediate
Platform: Tradingview
Broker: AMP Futures
Trading: NQ
Frequency: Daily
Duration: Minutes
Posts: 38 since Jan 2012
Thanks Given: 15
Thanks Received: 39

Yes, but with a scale-out, i.e. all-in at entry, 2 contracts exited at X price, last one at X price. ATM strategy in NT7.

Follow me on Twitter Reply With Quote
  #6 (permalink)
 
xplorer's Avatar
 xplorer 
London UK
Site Moderator
 
Experience: Beginner
Platform: CQG
Broker: S5
Trading: Futures
Frequency: Never
Duration: Never
Posts: 5,924 since Sep 2015
Thanks Given: 15,417
Thanks Received: 15,231


tradergino View Post
Yes, but with a scale-out, i.e. all-in at entry, 2 contracts exited at X price, last one at X price. ATM strategy in NT7.

So, it's not an all-in, all-out then

You can't add a column in your spreadsheet with the current structure to do what you want. Adding a column will not resolve the fact that you are exiting at a different price across multiple contracts.

You are better off recording a trade with multiple contracts on multiple rows with this spreadsheet.


If that's not clear, for more info about what I'm talking about, check this post, under "Trade Id and Size" paragraph.

Reply With Quote
The following 3 users say Thank You to xplorer for this post:
  #7 (permalink)
 
Bermudan Option's Avatar
 Bermudan Option 
Chicago, Illinois
1% better Daily
 
Experience: Beginner
Platform: TradingView
Broker: ThinkOrSwim
Trading: Forex, Stock & Options
Posts: 673 since May 2011
Thanks Given: 838
Thanks Received: 471

Here are some additional templates I've come across recently:
Built for backtesting but works well with live trading I'd imagine (Costs $20)



Free, but read-only. The formulae are all viewable to replicate on your own though:
https://docs.google.com/spreadsheets/d/1WNJdp9t9bq5a__KZqWVayXaz4ckPnJn_jfupvOZ6x6M/edit



Here are some more (mostly investment-focused) free templates I've come across:
https://docs.google.com/spreadsheets/d/1Wzh2MrMt5puKLuh2elQNUyMom8DPJ6Enc9EdBNQx1Xc/edit
https://docs.google.com/spreadsheets/d/1ZbA6ndteuqy3bNHl2wn1vE2F6NSN7rCSaoVUHApoaHQ/edit
https://docs.google.com/spreadsheets/d/1xpaK9k7cLs9A49JOGxFftKLYUbmTjrXLvj7J9SKaXWc/edit

Visit my NexusFi Trade Journal Reply With Quote
The following 4 users say Thank You to Bermudan Option for this post:
  #8 (permalink)
 stumbras 
Denver, Colorado
 
Experience: Beginner
Platform: Trdstation Trgview Motiwa
Broker: EdgeClear, Tradestation
Trading: Futures and Forex
Posts: 42 since Apr 2021
Thanks Given: 9
Thanks Received: 20

Thanks,
Looking for editable Google Sheets template for Daytrading, Crypto investments, with time stamps and ability to do year end profit/loss.
Maybe one of these will work.

Reply With Quote





Last Updated on May 20, 2021


© 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