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 334,778 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

  #441 (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

fresh from the zip(i think it was when i clicked on target analysis(<- this is spelled wrong on the journal tab btw), if that matters):


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

¯\_(ツ)_/¯

(╯°□°)╯︵ ┻━┻
Visit my NexusFi Trade Journal Reply With Quote
Thanked by:

Can you help answer these questions
from other members on NexusFi?
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
Exit Strategy
NinjaTrader
Trade idea based off three indicators.
Traders Hideout
How to apply profiles
Traders Hideout
ZombieSqueeze
Platforms and Indicators
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Just another trading journal: PA, Wyckoff & Trends
34 thanks
Tao te Trade: way of the WLD
24 thanks
GFIs1 1 DAX trade per day journal
16 thanks
Vinny E-Mini & Algobox Review TRADE ROOM
13 thanks
My NQ Trading Journal
12 thanks
  #442 (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

OK, thanks.
I replaced the file, could you try the new one?
I corrected the typo and scanned the whole thing for ref errors and my beloved links, but that seems to be all ok. My guess would be that the stop efficiency freaked out when there are no values....changed it slightly.

You will probably get the same error message again, if so just ignore it and stick your trades into the journal tab to see if the error persists...

Thanks for your help.

vvhg

Hic Rhodos, hic salta.
Reply With Quote
Thanked by:
  #443 (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
As to migrating, I have changed some formatting on the journal tab and fixed a few formulas, so please only copy the area of your records and not the whole journal tab. Ether copy with "match destination formatting" or write back the formatting from the cels below the pasted range, if you know how to do that.

vvhg

im not seeing the "match destination formatting" option in excel.. maybe its named something diff on my end?


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

¯\_(ツ)_/¯

(╯°□°)╯︵ ┻━┻
Visit my NexusFi Trade Journal Reply With Quote
  #444 (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
im not seeing the "match destination formatting" option in excel.. maybe its named something diff on my end?


Nah, I think it's my mistake. Easiest would be to restore formatting afterwords. so highlight 2 rows below the pasted area, top highlighted row darker brown. click the format painter and then format the pasted area by highlighting the respective rows with the painter.
Hope that makes sense...

vvhg

Hic Rhodos, hic salta.
Reply With Quote
Thanked by:
  #445 (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

Just thought of an other way:

1. copy the fresh journal tab
2. paste special: formatting into new empty workbook
3. paste your trade record
4. copy the format you pasted into the empty workbook
5. paste special: formatting into journal tab


vvhg

Hic Rhodos, hic salta.
Reply With Quote
Thanked by:
  #446 (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

isnt there just a way to copy the pure data from old journal to the new journal w/o any of the formatting? also isnt that the reason the journal cells are locked so that the formatting cant be messed up?

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

¯\_(ツ)_/¯

(╯°□°)╯︵ ┻━┻
Visit my NexusFi Trade Journal Reply With Quote
  #447 (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
isnt there just a way to copy the pure data from old journal to the new journal w/o any of the formatting? also isnt that the reason the journal cells are locked so that the formatting cant be messed up?

Not that I know of, unfortunately.
That would be nice, unfortunately it is even on a protected sheet possible to mess up the formatting of the unlocked cells (which is incredibly stupid as you can select to include or exclude formatting when protecting a sheet).
So the easiest method would be to just reapply the correct formatting.

Actually, perhaps I could do that automatically via VBA.....

vvhg

Hic Rhodos, hic salta.
Reply With Quote
Thanked by:
  #448 (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
Not that I know of, unfortunately.
That would be nice, unfortunately it is even on a protected sheet possible to mess up the formatting of the unlocked cells (which is incredibly stupid as you can select to include or exclude formatting when protecting a sheet).
So the easiest method would be to just reapply the correct formatting.

Actually, perhaps I could do that automatically via VBA.....

vvhg

ya that sucks.. im not sure if its me being thick headed in the morning here but i wasnt able to make heads or tails of your previous two options.. i guess im confused as to what the diff is between entering the trades manually and just copying and pasting over values only.. unless its just that i cant get my head around not being able to only copy entered data and no formatting whats-so-ever..

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

¯\_(ツ)_/¯

(╯°□°)╯︵ ┻━┻
Visit my NexusFi Trade Journal Reply With Quote
  #449 (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
ya that sucks.. im not sure if its me being thick headed in the morning here but i wasnt able to make heads or tails of your previous two options.. i guess im confused as to what the diff is between entering the trades manually and just copying and pasting over values only.. unless its just that i cant get my head around not being able to only copy entered data and no formatting whats-so-ever..

When pasting values only, pasted formulas are turned into values.
But you are of course right, if you don't unprotect, then you can't paste any formulas.....and then pasting values is perfect....stupid me....


vvhg

Hic Rhodos, hic salta.
Reply With Quote
Thanked by:
  #450 (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
OK, thanks.
I replaced the file, could you try the new one?
I corrected the typo and scanned the whole thing for ref errors and my beloved links, but that seems to be all ok. My guess would be that the stop efficiency freaked out when there are no values....changed it slightly.

You will probably get the same error message again, if so just ignore it and stick your trades into the journal tab to see if the error persists...

Thanks for your help.

vvhg

still getting this after 30 trades have been entered.. to note i dont include these in my journal if that matters:


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

¯\_(ツ)_/¯

(╯°□°)╯︵ ┻━┻
Visit my NexusFi Trade Journal 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