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

  #811 (permalink)
 
jmccabeVA's Avatar
 jmccabeVA 
Washington DC/USA
 
Experience: Advanced
Platform: Sierra Chart
Broker: Dorman Trading, IBKR
Trading: ES
Posts: 24 since Oct 2011
Thanks Given: 1
Thanks Received: 11

That would require excel for windows which I don't have. I do run Win7 in Fusion. Oh well. On to my search for a trading journal.

Follow me on Twitter Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Ninja Mobile Trader VPS (ninjamobiletrader.com)
Trading Reviews and Vendors
The space time continuum and the dynamics of a financial …
Emini and Emicro Index
ZombieSqueeze
Platforms and Indicators
Futures True Range Report
The Elite Circle
Are there any eval firms that allow you to sink to your …
Traders Hideout
 
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
22 thanks
GFIs1 1 DAX trade per day journal
22 thanks
The Program
20 thanks
  #812 (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


jmccabeVA View Post
That would require excel for windows which I don't have. I do run Win7 in Fusion. Oh well. On to my search for a trading journal.

If you would be willing to help, I could probably fix it...but I would need screenshots of the errors ...and you would have to be willing to do some testing.

vvhg

Hic Rhodos, hic salta.
Reply With Quote
  #813 (permalink)
 
NoMagic's Avatar
 NoMagic 
Sydney, Australia
 
Experience: Intermediate
Platform: NinjaTrader
Broker: Kinetick/IB
Trading: ES
Posts: 13 since Nov 2012
Thanks Given: 33
Thanks Received: 4



vvhg View Post
Thank you for your kind words. Regarding the importer for NT trades, I have never used it, so I can not offer any help. You would have to ask @petrmac as he created it.
I am not aware of any other settings you would have to change, just remember that the journal can only handle one currency correctly (if the account balance has to stay correct...).

vvhg

Hi vvhg

Thanks for your reply. I have now managed to get the importer to work- it was a case of the Locale setting, but also the date, time or number format.
In case anyone else encounters the same problem I found that they need to be

Control Panel > Region & language > Change location = United States
Control Panel > Date, time, or number format = English (United States)

with those settings and a restart of the computer the issue goes away.

Unfortunately I have now encountered a different set of errors from the Spreadsheet when I use it (and I am using Excel 2007), which I am trying to work through.

You mentioned that you do not use the uploader- do you upload all the data manually yourself or is there another method?

Many thanks again,

Mike

Reply With Quote
Thanked by:
  #814 (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


NoMagic View Post
Hi vvhg

Thanks for your reply. I have now managed to get the importer to work- it was a case of the Locale setting, but also the date, time or number format.
In case anyone else encounters the same problem I found that they need to be

Control Panel > Region & language > Change location = United States
Control Panel > Date, time, or number format = English (United States)

with those settings and a restart of the computer the issue goes away.

Unfortunately I have now encountered a different set of errors from the Spreadsheet when I use it (and I am using Excel 2007), which I am trying to work through.

You mentioned that you do not use the uploader- do you upload all the data manually yourself or is there another method?

Many thanks again,

Mike

Thanks for your workaround regarding the importer!

What errors do you get in the journal? There shouldn't be any using Excel 2007...so either the importer broke something or you found a bug...

vvhg

P.S. when you address someone directly you can use an "@" as prefix to their name like @NoMagic, this way they get notified...

Hic Rhodos, hic salta.
Reply With Quote
Thanked by:
  #815 (permalink)
 
NoMagic's Avatar
 NoMagic 
Sydney, Australia
 
Experience: Intermediate
Platform: NinjaTrader
Broker: Kinetick/IB
Trading: ES
Posts: 13 since Nov 2012
Thanks Given: 33
Thanks Received: 4


vvhg View Post
Thanks for your workaround regarding the importer!

What errors do you get in the journal? There shouldn't be any using Excel 2007...so either the importer broke something or you found a bug...

vvhg

P.S. when you address someone directly you can use an "@" as prefix to their name like @NoMagic, this way they get notified...



@vvhg

many thanks for the tip- I am new here so I can use all the advice you can give! PLease keep it coming.

As for the errors, there were a few of them so I will try and recreate them and post.

Thanks

Reply With Quote
  #816 (permalink)
 
NoMagic's Avatar
 NoMagic 
Sydney, Australia
 
Experience: Intermediate
Platform: NinjaTrader
Broker: Kinetick/IB
Trading: ES
Posts: 13 since Nov 2012
Thanks Given: 33
Thanks Received: 4


vvhg View Post
Thanks for your workaround regarding the importer!

What errors do you get in the journal? There shouldn't be any using Excel 2007...so either the importer broke something or you found a bug...

vvhg

P.S. when you address someone directly you can use an "@" as prefix to their name like @NoMagic, this way they get notified...

@vvhg

I have been working with the latest Journal4.3 and I think that I have found a very small bug- I have managed to recreate it by doing the following:


Open a brand new Journal direct from the Journal 4.3
Open the Journal Tab and change the time on the 2 existing trade examples to 0600 and 0800
Go to Overview tab

You will now see a 'phantom' profit in the Hourly Profit chart on in the 7 column.

Unfortunately my excel skills have not allowed me to fix this. What will happen though is tha this 'phantom' trade/profit will continue to affect your stats going forward so that your 7 hour stats never look right.

Oddly, when I recreate it this way there is a profit in the 7 column but in my own Journal there is a loss.

Still, I don't rule out user error on my part so please let me know.


Thanks

Mike

Reply With Quote
Thanked by:
  #817 (permalink)
 
NoMagic's Avatar
 NoMagic 
Sydney, Australia
 
Experience: Intermediate
Platform: NinjaTrader
Broker: Kinetick/IB
Trading: ES
Posts: 13 since Nov 2012
Thanks Given: 33
Thanks Received: 4


vvhg View Post
Thanks for your workaround regarding the importer!

What errors do you get in the journal? There shouldn't be any using Excel 2007...so either the importer broke something or you found a bug...

vvhg

P.S. when you address someone directly you can use an "@" as prefix to their name like @NoMagic, this way they get notified...

@vvhg

Hi

I have managed to spend some time on the uploader and the errors that I encounter are persistent and reproduceable.
Use the uploader on with an NT7 .csv exported file & add it to an existing one.
On opening the new saved file the error encountered is 'Excel found unreadable content in 'test1.xlsm'. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes'

On clicking yes
'Run-time error '1004''
Cannot use this functionality on a protected worksheet'

On clicking 'End' - Excel crashes
On clicking 'Debug'- Debugger opens and you can exit out without Excel crashing

The following error is in the Attachment.

I have reproduced this more than 3 times and it is consistent.
Hope this helps.

Thanks,

Mike

Attached Thumbnails
Click image for larger version

Name:	Uploader error.png
Views:	270
Size:	37.6 KB
ID:	95396  
Reply With Quote
  #818 (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


NoMagic View Post
@vvhg

Hi

I have managed to spend some time on the uploader and the errors that I encounter are persistent and reproduceable.
Use the uploader on with an NT7 .csv exported file & add it to an existing one.
On opening the new saved file the error encountered is 'Excel found unreadable content in 'test1.xlsm'. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes'

On clicking yes
'Run-time error '1004''
Cannot use this functionality on a protected worksheet'

On clicking 'End' - Excel crashes
On clicking 'Debug'- Debugger opens and you can exit out without Excel crashing

The following error is in the Attachment.

I have reproduced this more than 3 times and it is consistent.
Hope this helps.

Thanks,

Mike


It looks like the importer is incompatible with this version of the journal...
Maybe @petrmac can shed some light, I can't really help with that, sorry. If you depend on the importer, I'd suggest an older version that is known to be compatible with the importer, then once the importer has been updated, just migrate to the new version.


vvhg

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

Fixed the bug with the hour 7 on overview, thanks for spotting it.

vvhg


NoMagic View Post
...I have been working with the latest Journal4.3 and I think that I have found a very small bug- I have managed to recreate it by doing the following:


Open a brand new Journal direct from the Journal 4.3
Open the Journal Tab and change the time on the 2 existing trade examples to 0600 and 0800
Go to Overview tab

You will now see a 'phantom' profit in the Hourly Profit chart on in the 7 column...


Hic Rhodos, hic salta.
Attached Files
Elite Membership required to download: Journal 4.4.rar
Reply With Quote
  #820 (permalink)
 MarpleTrading 
Nederland
 
Experience: Advanced
Platform: Sierra charts
Broker: IB/IQFeed
Trading: Crude
Posts: 66 since Nov 2012
Thanks Given: 18
Thanks Received: 40


@vvhg

First of all a big danke schön for this excellent work I have been using this now for a couple of days and the information I can extract from it is fantastic.

I have one question @petrmac:

You have created an importer for this spreadsheet. Is it only working for Ninjatrader, or can it also be used with Sierra charts?

Thanks

Visit my NexusFi Trade Journal 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