NexusFi: Find Your Edge


Home Menu

 





Trading Metrics for journals/record keeping


Discussion in Psychology and Money Management

Updated
      Top Posters
    1. looks_one vvhg with 354 posts (690 thanks)
    2. looks_two madLyfe with 202 posts (104 thanks)
    3. looks_3 petrmac with 73 posts (106 thanks)
    4. looks_4 Big Mike with 35 posts (165 thanks)
      Best Posters
    1. looks_one PandaWarrior with 75 thanks per post
    2. looks_two Big Mike with 4.7 thanks per post
    3. looks_3 vvhg with 1.9 thanks per post
    4. looks_4 petrmac with 1.5 thanks per post
    1. trending_up 331,848 views
    2. thumb_up 1,509 thanks given
    3. group 234 followers
    1. forum 946 posts
    2. attach_file 252 attachments




 
Search this Thread

Trading Metrics for journals/record keeping

  #921 (permalink)
 Cesar12 
bs as , argentina
 
Experience: Intermediate
Platform: ninja trader
Trading: CL
Posts: 22 since Sep 2016
Thanks Given: 15
Thanks Received: 17

Hi, thanks for this amazing excel. I am trying to start use it, but I am having problems. When I use the 2nd row in the journal, my results are out of sense. I tried in different excels versions and i have the same problem.

Thank you in advance

Attached Thumbnails
Click image for larger version

Name:	excel.png
Views:	754
Size:	151.3 KB
ID:	239695  
Reply With Quote

Can you help answer these questions
from other members on NexusFi?
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
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
ZombieSqueeze
Platforms and Indicators
Better Renko Gaps
The Elite Circle
 
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
Battlestations: Show us your trading desks!
26 thanks
The Program
18 thanks
  #922 (permalink)
 
xplorer's Avatar
 xplorer 
London UK
Site Moderator
 
Experience: Beginner
Platform: CQG
Broker: S5
Trading: Futures
Posts: 5,944 since Sep 2015
Thanks Given: 15,446
Thanks Received: 15,291


Cesar12 View Post
Hi, thanks for this amazing excel. I am trying to start use it, but I am having problems. When I use the 2nd row in the journal, my results are out of sense. I tried in different excels versions and i have the same problem.

Thank you in advance

Hi Cesar - are you able to attach a version of the file with some data that show the problem?

Reply With Quote
  #923 (permalink)
 Cesar12 
bs as , argentina
 
Experience: Intermediate
Platform: ninja trader
Trading: CL
Posts: 22 since Sep 2016
Thanks Given: 15
Thanks Received: 17



xplorer View Post
Hi Cesar - are you able to attach a version of the file with some data that show the problem?

Hi xplorer. I am sorry for my bad english. I attached my version. The problem is 2nd row in the journal. the results are bad calculated, i dont understand why.

thank you!

Attached Files
Elite Membership required to download: Journal 4.5.zip
Reply With Quote
Thanked by:
  #924 (permalink)
 
xplorer's Avatar
 xplorer 
London UK
Site Moderator
 
Experience: Beginner
Platform: CQG
Broker: S5
Trading: Futures
Posts: 5,944 since Sep 2015
Thanks Given: 15,446
Thanks Received: 15,291


Cesar12 View Post
Hi xplorer. I am sorry for my bad english. I attached my version. The problem is 2nd row in the journal. the results are bad calculated, i dont understand why.

thank you!

There are some hidden columns in the spreadsheet where other entries are stored - but they appear to be entries related to a different instrument.

See the picture with the cells circled in red.

If you unhide those columns and remove those values it should work.


Reply With Quote
Thanked by:
  #925 (permalink)
 Cesar12 
bs as , argentina
 
Experience: Intermediate
Platform: ninja trader
Trading: CL
Posts: 22 since Sep 2016
Thanks Given: 15
Thanks Received: 17


xplorer View Post
There are some hidden columns in the spreadsheet where other entries are stored - but they appear to be entries related to a different instrument.

See the picture with the cells circled in red.

If you unhide those columns and remove those values it should work.


really thank you for your help! It is working well right now. This was my mistake.

thank you xplorer!

Reply With Quote
Thanked by:
  #926 (permalink)
 
xplorer's Avatar
 xplorer 
London UK
Site Moderator
 
Experience: Beginner
Platform: CQG
Broker: S5
Trading: Futures
Posts: 5,944 since Sep 2015
Thanks Given: 15,446
Thanks Received: 15,291


Cesar12 View Post
really thank you for your help! It is working well right now. This was my mistake.

thank you xplorer!

No problem, glad you sorted it

Reply With Quote
  #927 (permalink)
 Cesar12 
bs as , argentina
 
Experience: Intermediate
Platform: ninja trader
Trading: CL
Posts: 22 since Sep 2016
Thanks Given: 15
Thanks Received: 17

This excel is amazing! It is very important tool in my road to become a professional trader! Really thank everyone who did this work! I want to ask if there are more excel like this but for options or stocks

Sent using the NexusFi mobile app

Reply With Quote
  #928 (permalink)
alyzar
NYC NY
 
Posts: 1 since May 2017
Thanks Given: 1
Thanks Received: 0

Just found this and thank you very much. I have everything pretty much setup except that I also trade forex. Having an issue with the instrument setup. Sometime i trade mini and other times I will use micro lots. Suggestions on how to setup EUR/USD pair as an example. Thanks

Reply With Quote
  #929 (permalink)
 
xplorer's Avatar
 xplorer 
London UK
Site Moderator
 
Experience: Beginner
Platform: CQG
Broker: S5
Trading: Futures
Posts: 5,944 since Sep 2015
Thanks Given: 15,446
Thanks Received: 15,291


alyzar View Post
Just found this and thank you very much. I have everything pretty much setup except that I also trade forex. Having an issue with the instrument setup. Sometime i trade mini and other times I will use micro lots. Suggestions on how to setup EUR/USD pair as an example. Thanks

Try adjusting the value in column AZ (Point Value) and BA (Tick Size). The spreadsheet uses those to give you PnL so by varying those numbers you should get the result you want in Forex as well.

Reply With Quote
  #930 (permalink)
 
ChrisTinaBruce's Avatar
 ChrisTinaBruce 
Dallas, TX
 
Experience: Intermediate
Platform: TradeStation/Sierra Chart
Broker: Tradestation
Trading: ES
Posts: 66 since Oct 2012
Thanks Given: 56
Thanks Received: 33


Anyone use this spreadsheet in Google Sheets? I do not have Excel and opening the file I am seeing Invalid inputs such as instruments tab, etc.

Follow me on Twitter Reply With Quote




Last Updated on June 1, 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