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,911 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

  #341 (permalink)
 
petrmac's Avatar
 petrmac 
Czech Republic
 
Experience: Beginner
Platform: NinjaTrader
Trading: E7, M6E
Posts: 175 since Jun 2011
Thanks Given: 275
Thanks Received: 211

Ok,

new version ready. You can test it now.


It now supports the appending to the existing file. I had some time between running backtests so I could do that one feature...

Enjoy

Attached Files
Elite Membership required to download: bin.zip
Visit my NexusFi Trade Journal Reply With Quote
Thanked by:

Can you help answer these questions
from other members on NexusFi?
Futures True Range Report
The Elite Circle
ZombieSqueeze
Platforms and Indicators
NexusFi Journal Challenge - April 2024
Feedback and Announcements
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
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 …
59 thanks
Funded Trader platforms
37 thanks
NexusFi site changelog and issues/problem reporting
24 thanks
GFIs1 1 DAX trade per day journal
22 thanks
The Program
19 thanks
  #342 (permalink)
 
petrmac's Avatar
 petrmac 
Czech Republic
 
Experience: Beginner
Platform: NinjaTrader
Trading: E7, M6E
Posts: 175 since Jun 2011
Thanks Given: 275
Thanks Received: 211


vvhg View Post
As I don't really have any clue by what means you get the data into the sheet, the next sentence might or might not make the least bit of sense.
I don't really understand why the cell gets changed in the first place as you don't write to it, or does it just break the format even when the cell is not touched?

Also what do you mean by "real multiple lines"?

I thought if the problem persists, perhaps we could tackle that problem from the vba side if that's easier...

vvhg

Sent from my iPad using Tapatalk HD


If you see the resulting file it damages text in some header cells in journal tab. I am skipping them in the program so I have no idea why they look so bad.

The cells are formatted to show two lines even though there is just one cell. That is probably the issue.

Those which fit one line are not damaged by the import.


vvhg, could you please add in more instruments in the excel? I will then update the program with newer version.

I vote for 6e, e7, nq, tf, m6e, es :-)

Visit my NexusFi Trade Journal Reply With Quote
Thanked by:
  #343 (permalink)
 
madLyfe's Avatar
 madLyfe 
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
Posts: 1,641 since Feb 2011
Thanks Given: 9,220
Thanks Received: 1,020



petrmac View Post
If you see the resulting file it damages text in some header cells in journal tab. I am skipping them in the program so I have no idea why they look so bad.

The cells are formatted to show two lines even though there is just one cell. That is probably the issue.

Those which fit one line are not damaged by the import.


vvhg, could you please add in more instruments in the excel? I will then update the program with newer version.

I vote for 6e, e7, nq, tf, m6e, es :-)

here is my current list:
6E
6S
6J
CL
FDAX
NQ
TF
GC
ES
M6E

6E $5.08 $125,000.00 $12.50 0.0001 4
6S $5.08 $125,000.00 $12.50 0.0001 4
6J $5.08 $125,000.00 $12.50 0.0001 4
CL $5.12 $1,000.00 $10.00 0.01 2
FDAX $5.12 $25.00 $12.50 0.5 2
NQ $4.50 $20.00 $5.00 0.25 2
TF $4.16 $100.00 $10.00 0.1 2
GC $5.12 $100.00 $10.00 0.1 2
ES $4.16 $50.00 $12.50 0.25 2
M6E $2.20 $12,500.00 $1.25 0.0001 4

im gunna go ahead and say that we should just add all the eminis, currencies, bonds, softs, metals, etc, otherwise will forever have requests.. here is another issue, maybe in your program @petrmac you can add an option to omit sim trades from the import to the journal?

dont believe anything you hear and only half of what you see

¯\_(ツ)_/¯

(╯°□°)╯︵ ┻━┻
Visit my NexusFi Trade Journal Reply With Quote
  #344 (permalink)
 
madLyfe's Avatar
 madLyfe 
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
Posts: 1,641 since Feb 2011
Thanks Given: 9,220
Thanks Received: 1,020


petrmac View Post
How to use:
1. Export the trades list from the backtest results from ninja in CSV format. The format of P/L must be in points, I will add the support for other two types later.

im still not sure what your talking about here on how to export our trades.. not sure ive ever played in the 'backtest results' area of NT?

dont believe anything you hear and only half of what you see

¯\_(ツ)_/¯

(╯°□°)╯︵ ┻━┻
Visit my NexusFi Trade Journal Reply With Quote
  #345 (permalink)
 
petrmac's Avatar
 petrmac 
Czech Republic
 
Experience: Beginner
Platform: NinjaTrader
Trading: E7, M6E
Posts: 175 since Jun 2011
Thanks Given: 275
Thanks Received: 211


madLyfe View Post
im still not sure what your talking about here on how to export our trades.. not sure ive ever played in the 'backtest results' area of NT?

If you aren't backtesting, there is exactly the same grid in the Ninja control panel -> Account performance tab - > Trades tab.
Then use the same way to export the results as described earlier.

Visit my NexusFi Trade Journal Reply With Quote
Thanked by:
  #346 (permalink)
 
vvhg's Avatar
 vvhg 
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
Posts: 1,583 since Mar 2011
Thanks Given: 1,016
Thanks Received: 2,824


petrmac View Post
If you see the resulting file it damages text in some header cells in journal tab. I am skipping them in the program so I have no idea why they look so bad.

The cells are formatted to show two lines even though there is just one cell. That is probably the issue.

Those which fit one line are not damaged by the import.

I'll try to change the format of those cells to sth more compatible, and if that is not possible, I will write a fix for that into the sheet VBA.



petrmac View Post
vvhg, could you please add in more instruments in the excel? I will then update the program with newer version...


madLyfe View Post
....im gunna go ahead and say that we should just add all the eminis, currencies, bonds, softs, metals, etc,


I could easily add loads of instruments, but there is one disadvantage: the manual selection in the corresponding instrument fields will take considerably more time if you use the drop down list (you have to scroll there).
If you type into these fields everything stays the same (I use Auto Fill, which makes life quite easy with the journal).
But I think this price we sure can pay, and users can always delete the symbols they don't need.

Shall I get the commissions from a broker or do you want me to leave them blank?

Could you both please revise your posts where you mention the symbols and see if the list is "complete"?

@ madLyfe I'm not searching for all the symbols myself, forget it.
If you want all metals, bonds softs, minis and what not included, tell me at least the symbols (don't even think about posting a screenshot of all NT available instruments!), also could you post your current list so I can copy/paste that?


madLyfe View Post
otherwise will forever have requests..

Well, it's actually not that hard to add an instrument, any below average excel user even without expert programming skills should manage....


madLyfe View Post
here is another issue, maybe in your program @ petrmac you can add an option to omit sim trades from the import to the journal?

You can omit them when you export the list: Account Performance > Advanced > deselect the sim accounts.

vvhg

Hic Rhodos, hic salta.
Reply With Quote
  #347 (permalink)
 
madLyfe's Avatar
 madLyfe 
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
Posts: 1,641 since Feb 2011
Thanks Given: 9,220
Thanks Received: 1,020


petrmac View Post
If you aren't backtesting, there is exactly the same grid in the Ninja control panel -> Account performance tab - > Trades tab.
Then use the same way to export the results as described earlier.

thanks that worked! things im noticing:
- for some reason the inputted date isnt taking on the journals formatting
- it is writing to the comment cells which should be user selectable like the method cells are..
- i dont think the 'minutes in the trade' in the trade are working properly.. if in a trade for under 1 minute should = 1 as well im thinking, just an idea..? my trades im testing were longer than 1min but showing 0 min.
- we are going to need some type of notification that alerts the user if they have already inputted those trades for us forgetful/clumsy traders..

im sure youve have already thought of this but cant you just have the inputter skip the top cells and start with row 3? im not a programmer so if that sounds to simple and dumb its prolly because it is..

and other than the top cells issue thats what im noticing right now..

also i am working from this journal as that will be most similar to the newest version.. just for ref incase you didnt want to go wading through the thread.

dont believe anything you hear and only half of what you see

¯\_(ツ)_/¯

(╯°□°)╯︵ ┻━┻
Visit my NexusFi Trade Journal Reply With Quote
Thanked by:
  #348 (permalink)
 
madLyfe's Avatar
 madLyfe 
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
Posts: 1,641 since Feb 2011
Thanks Given: 9,220
Thanks Received: 1,020


vvhg View Post
I could easily add loads of instruments, but there is one disadvantage: the manual selection in the corresponding instrument fields will take considerably more time if you use the drop down list (you have to scroll there).
If you type into these fields everything stays the same (I use Auto Fill, which makes life quite easy with the journal).
But I think this price we sure can pay, and users can always delete the symbols they don't need.

Shall I get the commissions from a broker or do you want me to leave them blank?

Could you both please revise your posts where you mention the symbols and see if the list is "complete"?

@ madLyfe I'm not searching for all the symbols myself, forget it.
If you want all metals, bonds softs, minis and what not included, tell me at least the symbols (don't even think about posting a screenshot of all NT available instruments!), also could you post your current list so I can copy/paste that?


Well, it's actually not that hard to add an instrument, any below average excel user even without expert programming skills should manage....



You can omit them when you export the list: Account Performance > Advanced > deselect the sim accounts.

vvhg

after looking over it, NT uses the standard naming scheme for instruments as youd expect, 6E = 6E, CL = CL, etc.. we shouldnt actually need to add an overwhelming amount of instruments for people.. maybe just a few more of the common ones for people and everything should work as expected.. plus that can be towards the end of this once we get everything running smoothly..

dont believe anything you hear and only half of what you see

¯\_(ツ)_/¯

(╯°□°)╯︵ ┻━┻
Visit my NexusFi Trade Journal Reply With Quote
Thanked by:
  #349 (permalink)
 
madLyfe's Avatar
 madLyfe 
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
Posts: 1,641 since Feb 2011
Thanks Given: 9,220
Thanks Received: 1,020

i have updated my list in this thread in case you wanted to toss some of them in now:


dont believe anything you hear and only half of what you see

¯\_(ツ)_/¯

(╯°□°)╯︵ ┻━┻
Visit my NexusFi Trade Journal Reply With Quote
Thanked by:
  #350 (permalink)
 
vvhg's Avatar
 vvhg 
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
Posts: 1,583 since Mar 2011
Thanks Given: 1,016
Thanks Received: 2,824



madLyfe View Post
i have updated my list in this thread in case you wanted to toss some of them in now:


I have got the following list now:


I have also kicked most bugs out of my beta, I think. I will post a hopefully final beta soon.


vvhg

Hic Rhodos, hic salta.
Reply With Quote
Thanked by:




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