Trading Metrics for journals/record keeping - futures io
futures io futures trading



Trading Metrics for journals/record keeping


Discussion in Psychology and Money Management

Updated
      Top Posters
    1. looks_one vvhg with 354 posts (687 thanks)
    2. looks_two madLyfe with 202 posts (104 thanks)
    3. looks_3 petrmac with 73 posts (105 thanks)
    4. looks_4 Big Mike with 35 posts (161 thanks)
      Best Posters
    1. looks_one PandaWarrior with 71.5 thanks per post
    2. looks_two Big Mike with 4.6 thanks per post
    3. looks_3 vvhg with 1.9 thanks per post
    4. looks_4 petrmac with 1.4 thanks per post
    1. trending_up 235,229 views
    2. thumb_up 1,485 thanks given
    3. group 221 followers
    1. forum 940 posts
    2. attach_file 252 attachments




Welcome to futures io: the largest futures trading community on the planet, with well over 125,000 members
  • Genuine reviews from real traders, not fake reviews from stealth vendors
  • Quality education from leading professional traders
  • We are a friendly, helpful, and positive community
  • We do not tolerate rude behavior, trolling, or vendors advertising in posts
  • We are here to help, just let us know what you need
You'll need to register in order to view the content of the threads and start contributing to our community.  It's free and simple.

-- Big Mike, Site Administrator

(If you already have an account, login at the top of the page)

 
Search this Thread
 

Trading Metrics for journals/record keeping

(login for full post details)
  #301 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

Ok, obviously there is sth wrong...
Tested 2.0.8 my 2.2 and the 2.2 I posted, see screenshots for CPU usage! I will post an update real soon.

vvhg

Hic Rhodos, hic salta.
Attached Thumbnails
Click image for larger version

Name:	cpuusage1.JPG
Views:	73
Size:	64.3 KB
ID:	57726   Click image for larger version

Name:	cpuusage2.JPG
Views:	55
Size:	68.4 KB
ID:	57727  
Reply With Quote
The following user says Thank You to vvhg for this post:
 
(login for full post details)
  #302 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

Minor update.
Last version was hogging CPU. Should be fixed now.

vvhg

Hic Rhodos, hic salta.
Attached Files
Register to download File Type: rar Journal 2.3.rar (2.12 MB, 86 views)
Reply With Quote
The following 4 users say Thank You to vvhg for this post:
 
(login for full post details)
  #303 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received


vvhg View Post
Minor update.
Last version was hogging CPU. Should be fixed now.

vvhg

seems to be much better now thanks @vvhg!

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

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #304 (permalink)
Vernon, BC, Canada
 
Experience: Beginner
Platform: Sierra Charts
Broker: Zaner Group (Transact)
Trading: ES
 
Posts: 103 since Apr 2010
Thanks: 113 given, 63 received

I went through the screens you showed on post #295 (I was unable to find screen #3 or Screen #4) so here is my question. Each time I bring up journal.xlsm I get the screen below with the security warning. Should I get this screen each time and each time I need to "enable content". If I look further for screen #3 and #4 will this solve the problem of the security warning coming up each time I start up Journal.xlsm?

Attached Thumbnails
Click image for larger version

Name:	2011-12-20_0722.png
Views:	92
Size:	57.6 KB
ID:	57756  
Reply With Quote
 
(login for full post details)
  #305 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received


Superdoug3 View Post
I went through the screens you showed on post #295 (I was unable to find screen #3 or Screen #4) so here is my question. Each time I bring up journal.xlsm I get the screen below with the security warning. Should I get this screen each time and each time I need to "enable content". If I look further for screen #3 and #4 will this solve the problem of the security warning coming up each time I start up Journal.xlsm?

Well, you can also choose to enable macros by default, but I would recommend to NOT do that as macros can be harmful (just like a virus). So I leave it on this setting that excel asks me each time.

vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #306 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received


Superdoug3 View Post
I was unable to find screen #3 or Screen #4

Have a look again, you posted a screenshot showing the same than my screenshot3. If you click on it, the dialog as shown on screenshot4 pops up.

vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #307 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

I'm at the moment redesigning the Monte Carlo simulation more or less from scratch to make it much more powerful and perhaps even faster at the same time.
The reasons for this are:
1. limited functionality and poor performance of the old one
2. this thread: Risk of Ruin as I had the feeling that the available risk models are greatly inferior to Monte Carlo simulations (at least in this field where there is no strong correlation between individual datapoints) and we hit a brick wall with these models....

What I would be really interested in is:

1. how many trades per iteration (in a row) would you like to simulate (maximum)
2 How many iterations would you like to run (always fixed)


tellmetellmetellmetellme


vvhg

P.S. I had to use some smileys as the topic is rather dull (yes, even I think it's dull....)

Hic Rhodos, hic salta.
Reply With Quote
The following user says Thank You to vvhg for this post:
 
(login for full post details)
  #308 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

HELP!!!

Now that I converted the mayor parts of the MC to VBA this whole thing is waaaaaaaaay too slow. At some point in the code I seem to have f****d up quite badly.
But I have not the faintest idea of where that might be! Note to myself: Remember that I am not a programmer, not even a bad one!

If any VBA gurus are out there, now is the time I could really use your help.....


vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #309 (permalink)
the coin hunter
virginia
 
Experience: Intermediate
Platform: ninja
Trading: NQ
 
cory's Avatar
 
Posts: 6,013 since Jun 2009
Thanks: 836 given, 7,857 received

the hard part is debugging, add print statements to display time to see how long it take to reach a particular print statement keep narrow it down until you find which line of code creates slowness.

Reply With Quote
The following user says Thank You to cory for this post:
 
(login for full post details)
  #310 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

I'll try that tomorrow, and I think I might have an idea where to look for it, but the main thing is probably my elegant coding style, haha.
If the debugging doesn't get me further, I'll post it here.

Vvhg


Sent from my iPad using Tapatalk HD

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #311 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

Thanks to @cory again!
I found the brakes, it was the way I wrote output to the cells:

instead of this method:

 
Code
Range("$N$2").Offset(iTerations - 1, 0).Value = myval
I now use this:

 
Code
Range(.Cells(2, 14), .Cells(10000 + 1, 14)) = myvariant
and now it's a f*****g race horse.
500 iterations with 1000 trades each take about 10 seconds on my machine.

You can chose now how many iterations of how many trades you want to run.
You can also chose to perform the simulation with fixed position sizing or with fixed fractional position sizing (money management).




Attached is the beta to play around with (@madLyfe hint, hint ) (Excel 2007 & up only).

As soon as we have some confidence and the glitches are out, I am happy to call it a final....


vvhg

Hic Rhodos, hic salta.
Reply With Quote
The following 5 users say Thank You to vvhg for this post:
 
(login for full post details)
  #312 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received


vvhg View Post
Thanks to @cory again!
I found the brakes, it was the way I wrote output to the cells:

instead of this method:

 
Code
Range("$N$2").Offset(iTerations - 1, 0).Value = myval
I now use this:

 
Code
Range(.Cells(2, 14), .Cells(10000 + 1, 14)) = myvariant
and now it's a f*****g race horse.
500 iterations with 1000 trades each take about 10 seconds on my machine.

You can chose now how many iterations of how many trades you want to run.
You can also chose to perform the simulation with fixed position sizing or with fixed fractional position sizing (money management).


Attachment 58596

Attached is the beta to play around with (@madLyfe hint, hint ) (Excel 2007 & up only).

As soon as we have some confidence and the glitches are out, I am happy to call it a final....


vvhg

cool cool! thanks for taking the time to make this an awesome journal! ill play around with it today and report back!

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

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #313 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received

here is what im getting right on load of the new journal:



and then after i push ok on that i get this:


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

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
The following user says Thank You to madLyfe for this post:
 
(login for full post details)
  #314 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

OK, the compile error is easily fixed, but the link.... I hate links!
Have you got any idea of where the link is and where it points to?

vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #315 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received


vvhg View Post
OK, the compile error is easily fixed, but the link.... I hate links!
Have you got any idea of where the link is and where it points to?

vvhg

no i have no idea, but it was just the fresh journal.. was hard to do anything with the compile errors firing off every time you clicked anywhere..

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

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #316 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received


madLyfe View Post
was hard to do anything with the compile errors firing off every time you clicked anywhere..


Just delete the top 2 rows.

vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #317 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received


vvhg View Post
Just delete the top 2 rows.

vvhg

heh im sorry, but the top two rows of what?

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

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #318 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received


madLyfe View Post
heh im sorry, but the top two rows of what?

lol, quite true, doesn't work that well when I type the same way I think!!!! Sorry, lol!

Don't delete anything, I have attached a new version, should have killed the links and the compile error.

vvhg

Hic Rhodos, hic salta.
Attached Files
Register to download File Type: rar Journal 2 .3beta7.rar (1.27 MB, 44 views)
Reply With Quote
The following 2 users say Thank You to vvhg for this post:
 
(login for full post details)
  #319 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received


vvhg View Post
lol, quite true, doesn't work that well when I type the same way I think!!!! Sorry, lol!

Don't delete anything, I have attached a new version, should have killed the links and the compile error.

vvhg

ya i know how that goes.. man this is alot nicer.. it loads much faster and there is almost no loading when flipping between pages!

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

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
The following user says Thank You to madLyfe for this post:
 
(login for full post details)
  #320 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received

i know i have no idea about the inner workings, but does this happen to be where the link issues are?


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

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
The following 2 users say Thank You to madLyfe for this post:
 
(login for full post details)
  #321 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received


madLyfe View Post
i know i have no idea about the inner workings, but does this happen to be where the link issues are?

No, this is simply due to half entered data, wanted to give you sth to play around with.
The links were very well hidden in charts, in fact, I had to delete the charts, these links can be like viruses.....
Have you tried the MC yet, it should be rather quick now?

vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #322 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received


vvhg View Post
No, this is simply due to half entered data, wanted to give you sth to play around with.
The links were very well hidden in charts, in fact, I had to delete the charts, these links can be like viruses.....
Have you tried the MC yet, it should be rather quick now?

vvhg

ya everything seems really snappy.. i dont use MC at all, but going through the options it does seem to be working well.. i dunno if its working correctly tho(i wouldnt know what that looked like).. im not getting any errors either...

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

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #323 (permalink)
Czech Republic
 
Experience: Beginner
Platform: NinjaTrader
Trading: E7, M6E
 
petrmac's Avatar
 
Posts: 175 since Jun 2011
Thanks: 275 given, 210 received

Hi guys and girls. I have made a new version of my importer of the results from Ninja.



New version now supports:
1. The en-US locale (choosable) which might have been a issue for those of you having it as default in your system:-)
2. Definable delimiter of the cells in the csv file (defaults to ",").
3. Better handling of the dates and times

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.
2. Load the file in the program
3. Click Import and choose the destination to save the journal.


done...

The built exe is standard .NET assembly. If you have .NET you should be able to run it. If you have NinjaTrader it will run:-)
I have attached also the sources, so feel free to modify.

Happy browsing through your data...

Attached Files
Register to download File Type: zip bin.zip (3.90 MB, 29 views)
Register to download File Type: zip ResultsImport-src.zip (1.87 MB, 30 views)
Visit my futures io Trade Journal Reply With Quote
The following 5 users say Thank You to petrmac for this post:
 
(login for full post details)
  #324 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received


petrmac View Post
Hi guys and girls. I have made a new version of my importer of the results from Ninja.

It is amazing what is possible when someone knows what he is doing, (unlike me trying to fry my cpu with the worst vba code known to mankind).

Thank you a lot @petrmac! I will play with it tomorrow, also a good way to test my MC engine a bit more....I want to have a few more performance tests.

And perhaps I find a way to make it a bit faster (although it is probably fairly optimized now, at least for my skill level which pretty much reflects the fact that until two days ago I only ever copy pasted vb code).

The amazing thing is that although this time is obviously too short to learn vb, it is plenty to learn to dislike vb.....I rather have C#.

vvhg

Sent from my iPad using Tapatalk HD

Hic Rhodos, hic salta.
Reply With Quote
The following user says Thank You to vvhg for this post:
 
(login for full post details)
  #325 (permalink)
Site Administrator
Swing Trader
Data Scientist & DevOps
Manta, Ecuador
 
Experience: Advanced
Platform: My own custom solution
Trading: Emini Futures
 
Big Mike's Avatar
 
Posts: 49,397 since Jun 2009
Thanks: 32,062 given, 96,675 received


petrmac View Post
Hi guys and girls. I have made a new version of my importer of the results from Ninja.


Just so I better understand, this will take trades from NinjaTrader and import them into the Journal being developed in this thread?

I am so proud of you guys, taking my example and making it 100x better

Mike

We're here to help -- just ask

For the best trading education, watch our webinars
Searching for trading reviews? Review this list

Follow us on Twitter, YouTube, and Facebook

Support our community as an Elite Member:
https://futures.io/elite/
Follow me on Twitter Visit my Facebook Visit my futures io Trade Journal Reply With Quote
The following user says Thank You to Big Mike for this post:
 
(login for full post details)
  #326 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received


petrmac View Post
Hi guys and girls. I have made a new version of my importer of the results from Ninja.



New version now supports:
1. The en-US locale (choosable) which might have been a issue for those of you having it as default in your system:-)
2. Definable delimiter of the cells in the csv file (defaults to ",").
3. Better handling of the dates and times

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.
2. Load the file in the program
3. Click Import and choose the destination to save the journal.


done...

The built exe is standard .NET assembly. If you have .NET you should be able to run it. If you have NinjaTrader it will run:-)
I have attached also the sources, so feel free to modify.

Happy browsing through your data...


Big Mike View Post
Just so I better understand, this will take trades from NinjaTrader and import them into the Journal being developed in this thread?

I am so proud of you guys, taking my example and making it 100x better

Mike

actually i was gunna post in hopes in thats what hes talking about! i was reading about his tool awhile ago but thought it was a dead project.. if its able to import trades into our journal i have some cool ideas for it!

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

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #327 (permalink)
Czech Republic
 
Experience: Beginner
Platform: NinjaTrader
Trading: E7, M6E
 
petrmac's Avatar
 
Posts: 175 since Jun 2011
Thanks: 275 given, 210 received


Big Mike View Post
Just so I better understand, this will take trades from NinjaTrader and import them into the Journal being developed in this thread?

I am so proud of you guys, taking my example and making it 100x better

Mike


Yes Mike,

just like you write here. Some little example will help:

1. first you open the trades list like in the picture. (The values must be in points as seen in picture) and on the grid press Save as...


2. I have attached the resulting csv file
test.csv

3. And finally the rustling excel file that is created to a specific location you choose after the Import button is pressed.
test-journal.zip


Hope this is self explanatory enough...

No need to mention that the grid for live/sim trades is exactly the same so the trades could be imported as well.

Visit my futures io Trade Journal Reply With Quote
The following 2 users say Thank You to petrmac for this post:
 
(login for full post details)
  #328 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

Yes, it's awesome, makes my efforts look like a kindergarden project, lol!

The only thing I ask myself is whether it has to import into a clean journal or whether it finds the end of the existing records and pastes them below....
I also have a few ideas what more to do with it, but that's entirely out of my league.

vvhg

Hic Rhodos, hic salta.
Reply With Quote
The following user says Thank You to vvhg for this post:
 
(login for full post details)
  #329 (permalink)
Czech Republic
 
Experience: Beginner
Platform: NinjaTrader
Trading: E7, M6E
 
petrmac's Avatar
 
Posts: 175 since Jun 2011
Thanks: 275 given, 210 received


madLyfe View Post
actually i was gunna post in hopes in thats what hes talking about! i was reading about his tool awhile ago but thought it was a dead project.. if its able to import trades into our journal i have some cool ideas for it!

If so, write them here. The ideas might come handy. Perhaps me or someone else who knows C# could help.
The sources are available.

Petr

Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #330 (permalink)
Czech Republic
 
Experience: Beginner
Platform: NinjaTrader
Trading: E7, M6E
 
petrmac's Avatar
 
Posts: 175 since Jun 2011
Thanks: 275 given, 210 received


vvhg View Post
Yes, it's awesome, makes my efforts look like a kindergarden project, lol!

The only thing I ask myself is whether it has to import into a clean journal or whether it finds the end of the existing records and pastes them below....
I have also a few ideas what more to do with it, but that's entirely out of my league.

vvhg


It creates a new journal each time (it is compiled in the program as embedded resource). But I guess the adding to existing could be implemented. It would just take some time.

I might also add in a more recent version of the journal, once it is stable.

Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #331 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received


petrmac View Post
It creates a new journal each time (it is compiled in the program as embedded resource). But I guess the adding to existing could be implemented. It would just take some time.

If that would be possible.....awesome!

The other idea spooking around in my head is probably quite complicated: grouping of individual trades to one trade with multiple cars and exits. the grouping will probably require some rather complicated logic, the reformatting bit is probably the easier part of it.



petrmac View Post
I might also add in a more recent version of the journal, once it is stable.

That should be rather easy as the journal tab hasn't changed since a few versions, don't know which one you are using though...


vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #332 (permalink)
Czech Republic
 
Experience: Beginner
Platform: NinjaTrader
Trading: E7, M6E
 
petrmac's Avatar
 
Posts: 175 since Jun 2011
Thanks: 275 given, 210 received

Well, go and check the example.

The import is compatible with the journal in terms that it takes the trades and if they have a numeric suffix in the EntryName lets say:

KumoBreakout
KumoBreakout2
KumoBreakout3

it will aggregate those three into one trade as three vehicles. The only thing you have to do is to mark each individual trade properly. I do that that I have three profit targets (two trailed to some extent and one runner) with different name for each and they merge nicely in the excel.

When there is new entry that has no suffix it starts counting again.

So this is already supported.

The version of the journal is something like 2.1 or something... not terribly old, but not new either.

Visit my futures io Trade Journal Reply With Quote
The following user says Thank You to petrmac for this post:
 
(login for full post details)
  #333 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received


petrmac View Post
Well, go and check the example.

The import is compatible with the journal in terms that it takes the trades and if they have a numeric suffix in the EntryName lets say:

KumoBreakout
KumoBreakout2
KumoBreakout3

it will aggregate those three into one trade as three vehicles. The only thing you have to do is to mark each individual trade properly. I do that that I have three profit targets (two trailed to some extent and one runner) with different name for each and they merge nicely in the excel.

OK, I just had a look, nicely done!
Though I have no idea how to mark the trades outside a strategy ( I use the ATM).
Could that be done with minutes as well?



petrmac View Post
The version of the journal is something like 2.1 or something... not terribly old, but not new either.

But the journal tab has not changed since then, if I'm not mistaken.

vvhg

Hic Rhodos, hic salta.
Reply With Quote
The following user says Thank You to vvhg for this post:
 
(login for full post details)
  #334 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received


petrmac View Post
It creates a new journal each time (it is compiled in the program as embedded resource). But I guess the adding to existing could be implemented. It would just take some time.

I might also add in a more recent version of the journal, once it is stable.

would you be able to make it import to our journals? and if thats possible i would suggest some feature requests from there depending on how the whole process works..

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

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
The following user says Thank You to madLyfe for this post:
 
(login for full post details)
  #335 (permalink)
Czech Republic
 
Experience: Beginner
Platform: NinjaTrader
Trading: E7, M6E
 
petrmac's Avatar
 
Posts: 175 since Jun 2011
Thanks: 275 given, 210 received

OK

one feature at a time. It takes tome time...

here we have two top wanted:

1. grouping by time for those using ATM strategies
2. adding the newly parsed record to an existing journal (requires xml excel file and user needs to locate it on the disk). I don't want to perform the heuristic analysis, so it will be perhaps required to insert a line after which to append...

What do you think?

Visit my futures io Trade Journal Reply With Quote
The following user says Thank You to petrmac for this post:
 
(login for full post details)
  #336 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received


petrmac View Post
OK

one feature at a time. It takes tome time...

here we have two top wanted:

1. grouping by time for those using ATM strategies
2. adding the newly parsed record to an existing journal (requires xml excel file and user needs to locate it on the disk). I don't want to perform the heuristic analysis, so it will be perhaps required to insert a line after which to append...

What do you think?

ya that would be awesome to work with this project/journal that way the users here at futures.io (formerly BMT) have something stable/reliable/relatively simple.. i think @vvhg has the journal fields pretty solidified so imputing to them shouldnt be an issue(future changes wise)..

one issue i can see off the top of my head is that the instrument list that is in the journal is not standardized.. i say that in we are allow to name the instruments anything with want in the instruments list.. we will most likely have to adopt the ninja naming scheme..

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

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
The following user says Thank You to madLyfe for this post:
 
(login for full post details)
  #337 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received


petrmac View Post
OK

one feature at a time. It takes tome time...

Take all the time you need! Greatly appreciating your efforts!



petrmac View Post
I don't want to perform the heuristic analysis, so it will be perhaps required to insert a line after which to append...

???


petrmac View Post
What do you think?

Great! I can't wait....

vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #338 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received


madLyfe View Post
ya that would be awesome to work with this project/journal that way the users here at futures.io (formerly BMT) have something stable/reliable/relatively simple..

I second that!


madLyfe View Post
i think @vvhg has the journal fields pretty solidified so imputing to them shouldnt be an issue(future changes wise)..

Yep, I think the journal tab will probably not change ( that much or too soon at least, you know: never say never).


madLyfe View Post
one issue i can see off the top of my head is that the instrument list that is in the journal is not standardized.. i say that in we are allow to name the instruments anything with want in the instruments list.. we will most likely have to adopt the ninja naming scheme..

Yes, I think you are right, we would have to adopt the NT naming scheme, but who would name CL "that black smelly stuff" in his journal anyways!??


vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #339 (permalink)
Czech Republic
 
Experience: Beginner
Platform: NinjaTrader
Trading: E7, M6E
 
petrmac's Avatar
 
Posts: 175 since Jun 2011
Thanks: 275 given, 210 received

Ok, one issue I am not able to overcome is the destruction of the header format in milt line cells.
Perhaps we could do something with them in the excel first..
It is not a big issue, but the lib I am using for writing excel cannot do anything about it.

We could either replace by shorter text so that it fits one line or use "real multiple lines".

Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #340 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received


petrmac View Post
Ok, one issue I am not able to overcome is the destruction of the header format in milt line cells.
Perhaps we could do something with them in the excel first..
It is not a big issue, but the lib I am using for writing excel cannot do anything about it.

We could either replace by shorter text so that it fits one line or use "real multiple lines".

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

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #341 (permalink)
Czech Republic
 
Experience: Beginner
Platform: NinjaTrader
Trading: E7, M6E
 
petrmac's Avatar
 
Posts: 175 since Jun 2011
Thanks: 275 given, 210 received

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
Register to download File Type: zip bin.zip (3.90 MB, 36 views)
Visit my futures io Trade Journal Reply With Quote
The following 3 users say Thank You to petrmac for this post:
 
(login for full post details)
  #342 (permalink)
Czech Republic
 
Experience: Beginner
Platform: NinjaTrader
Trading: E7, M6E
 
petrmac's Avatar
 
Posts: 175 since Jun 2011
Thanks: 275 given, 210 received


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 futures io Trade Journal Reply With Quote
The following user says Thank You to petrmac for this post:
 
(login for full post details)
  #343 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received


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 futures io Trade Journal Reply With Quote
 
(login for full post details)
  #344 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received


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 futures io Trade Journal Reply With Quote
 
(login for full post details)
  #345 (permalink)
Czech Republic
 
Experience: Beginner
Platform: NinjaTrader
Trading: E7, M6E
 
petrmac's Avatar
 
Posts: 175 since Jun 2011
Thanks: 275 given, 210 received


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 futures io Trade Journal Reply With Quote
The following user says Thank You to petrmac for this post:
 
(login for full post details)
  #346 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received


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
 
(login for full post details)
  #347 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received


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 futures io Trade Journal Reply With Quote
The following 2 users say Thank You to madLyfe for this post:
 
(login for full post details)
  #348 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received


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 futures io Trade Journal Reply With Quote
The following 2 users say Thank You to madLyfe for this post:
 
(login for full post details)
  #349 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received

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 futures io Trade Journal Reply With Quote
The following 2 users say Thank You to madLyfe for this post:
 
(login for full post details)
  #350 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received


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
The following 4 users say Thank You to vvhg for this post:
 
(login for full post details)
  #351 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received


vvhg View Post
I have got the following list now:
Attachment 58855

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


vvhg

ok cool! im not sure the 6S and 6J have the right values in there as i just used the values as fillers and havnt actually traded them..

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

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #352 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received


madLyfe View Post
ok cool! im not sure the 6S and 6J have the right values in there as i just used the values as fillers and havnt actually traded them..

Fixed it, 6J is 12.500.000

vvhg

Hic Rhodos, hic salta.
Reply With Quote
The following user says Thank You to vvhg for this post:
 
(login for full post details)
  #353 (permalink)
Czech Republic
 
Experience: Beginner
Platform: NinjaTrader
Trading: E7, M6E
 
petrmac's Avatar
 
Posts: 175 since Jun 2011
Thanks: 275 given, 210 received


madLyfe View Post
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.

- formatting is according to the selected locale. Should I add other ones? It has to correspond with the csv locale though.
so if the system locale is en-US the dates would be formatted in that way... but let's say this is minor issue
- yes it is writing everything that could be read from the csv - that includes instrument and method. In case you have multiple entry methods in you strategy, this makes sense.
- minutes were written incorrectly - now will be fixed in new version
- Notifications might be nice but let's try to fix more important issues first like trade grouping. Keep in mind, that this could prolong the import, especially when there are many down in the journal already.

Visit my futures io Trade Journal Reply With Quote
The following 2 users say Thank You to petrmac for this post:
 
(login for full post details)
  #354 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received


petrmac View Post
- formatting is according to the selected locale. Should I add other ones? It has to correspond with the csv locale though.
so if the system locale is en-US the dates would be formatted in that way... but let's say this is minor issue
- yes it is writing everything that could be read from the csv - that includes instrument and method. In case you have multiple entry methods in you strategy, this makes sense.
- minutes were written incorrectly - now will be fixed in new version
- Notifications might be nice but let's try to fix more important issues first like trade grouping. Keep in mind, that this could prolong the import, especially when there are many down in the journal already.

Would it be possible to choose to write method or not in a future version?
I think a slightly slower import is a small price to pay....

I'll post a new journal soon that you could try out (hopefully it fixes the heading issue...), it also includes the extended instrument list.

vvhg

Hic Rhodos, hic salta.
Reply With Quote
The following 2 users say Thank You to vvhg for this post:
 
(login for full post details)
  #355 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

The other thing I was thinking about is if it would be possible (within practical limits of course) to make the import tool an excel add-in?? It would be quite cool to import data into your journal where you only had to point to the csv and the settings are all saved in there so that's really all you have to do....

vvhg

Hic Rhodos, hic salta.
Reply With Quote
The following user says Thank You to vvhg for this post:
 
(login for full post details)
  #356 (permalink)
Czech Republic
 
Experience: Beginner
Platform: NinjaTrader
Trading: E7, M6E
 
petrmac's Avatar
 
Posts: 175 since Jun 2011
Thanks: 275 given, 210 received


vvhg View Post
The other thing I was thinking about is if it would be possible (within practical limits of course) to make the import tool an excel add-in?? It would be quite cool to import data into your journal where you only had to point to the csv and the settings are all saved in there so that's really all you have to do....

vvhg

Hmm,

that might be tricky. I have never made any excel plugin. But maybe you could call a exe from the VBscript if there is command line version available?

Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #357 (permalink)
Czech Republic
 
Experience: Beginner
Platform: NinjaTrader
Trading: E7, M6E
 
petrmac's Avatar
 
Posts: 175 since Jun 2011
Thanks: 275 given, 210 received

One more feature we might need to implement:

On currency products, due to the error in Ninja export, there is no MAE / MFE / ETD value when exported in points (the values are zero in the csv).
How do you suggest to fix that? Maybe calculate the amount of ticks from the money value???

Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #358 (permalink)
Czech Republic
 
Experience: Beginner
Platform: NinjaTrader
Trading: E7, M6E
 
petrmac's Avatar
 
Posts: 175 since Jun 2011
Thanks: 275 given, 210 received


vvhg View Post
Would it be possible to choose to write method or not in a future version?

I don't understand what you mean. It currently writes the method, isn't it?
You mean to skip writing of the method to the journal so that you could fill it yourself??

Visit my futures io Trade Journal Reply With Quote
The following user says Thank You to petrmac for this post:
 
(login for full post details)
  #359 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

OK, here is my RC: the bugs I could find and the ones pointed out to me are killed.
@petrmac, try this one to see if the problem with the heading is gone...


vvhg

Hic Rhodos, hic salta.
Attached Files
Register to download File Type: rar Journal 2 .3beta8.rar (1.38 MB, 37 views)
Reply With Quote
The following 2 users say Thank You to vvhg for this post:
 
(login for full post details)
  #360 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received


petrmac View Post
One more feature we might need to implement:

On currency products, due to the error in Ninja export, there is no MAE / MFE / ETD value when exported in points (the values are zero in the csv).
How do you suggest to fix that? Maybe calculate the amount of ticks from the money value???

I don't see any other option, just remember to factor in commissions....


petrmac View Post
I don't understand what you mean. It currently writes the method, isn't it?
You mean to skip writing of the method to the journal so that you could fill it yourself??

Exactly, the best would be to make it user selectable to write or skip it. As you pointed out, for strategies it makes sense to write it.
But for discretionary trading it would be better to skip it, so while trading you indert method, grades, comment and thoughts and after trading hours you just import all the numbers....

vvhg

Hic Rhodos, hic salta.
Reply With Quote
The following user says Thank You to vvhg for this post:
 
(login for full post details)
  #361 (permalink)
Czech Republic
 
Experience: Beginner
Platform: NinjaTrader
Trading: E7, M6E
 
petrmac's Avatar
 
Posts: 175 since Jun 2011
Thanks: 275 given, 210 received

OK,

here is the new version of the importer.

Fixed issue:
minutes in trade are now calculated correctly

Now featuring new embedded version of the journal. Thanks @vvhg. It is MUCH faster and also a bit smaller. Also the headers are now displayed properly.

Just one problem... the dashboard does not recalculate. Am I missing something?

Attached Files
Register to download File Type: zip bin.zip (5.34 MB, 15 views)
Visit my futures io Trade Journal Reply With Quote
The following 2 users say Thank You to petrmac for this post:
 
(login for full post details)
  #362 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

Sorry, what do you mean by dashboard?

vvhg


Sent from my iPad using Tapatalk HD

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #363 (permalink)
Czech Republic
 
Experience: Beginner
Platform: NinjaTrader
Trading: E7, M6E
 
petrmac's Avatar
 
Posts: 175 since Jun 2011
Thanks: 275 given, 210 received

Sorry, I meant the Overview tab.

Somehow the current balance stays the same after import (used to recalculate after defining the starting balance) and the equity curve stays the same...

Same for some other fields... I'll do some more tests...

Visit my futures io Trade Journal Reply With Quote
The following user says Thank You to petrmac for this post:
 
(login for full post details)
  #364 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

OK, can you post or send me the file, so I can have a look tomorrow?

vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #365 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

@petrmac, could you have a look at the following link? It might be helpful/interesting? Import to excel programmatically


Vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #366 (permalink)
Czech Republic
 
Experience: Beginner
Platform: NinjaTrader
Trading: E7, M6E
 
petrmac's Avatar
 
Posts: 175 since Jun 2011
Thanks: 275 given, 210 received


vvhg View Post
OK, can you post or send me the file, so I can have a look tomorrow?

vvhg

Here you go....

test.zip

Visit my futures io Trade Journal Reply With Quote
The following user says Thank You to petrmac for this post:
 
(login for full post details)
  #367 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received


vvhg View Post
Exactly, the best would be to make it user selectable to write or skip it. As you pointed out, for strategies it makes sense to write it.
But for discretionary trading it would be better to skip it, so while trading you indert method, grades, comment and thoughts and after trading hours you just import all the numbers....

vvhg

i agree with ability to omit method and wether we followed the rules or not..

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

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #368 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received

do you guys have to have a sample import file? i find myself going into sim and making random trades to be able to test..

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

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #369 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received

@vvhg im still getting these in beta8:


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

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
The following user says Thank You to madLyfe for this post:
 
(login for full post details)
  #370 (permalink)
Site Administrator
Swing Trader
Data Scientist & DevOps
Manta, Ecuador
 
Experience: Advanced
Platform: My own custom solution
Trading: Emini Futures
 
Big Mike's Avatar
 
Posts: 49,397 since Jun 2009
Thanks: 32,062 given, 96,675 received


vvhg View Post
I have got the following list now:
Attachment 58855

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


vvhg

M6E should be 12,500 point value, $1.25 a tick.

Mike

We're here to help -- just ask

For the best trading education, watch our webinars
Searching for trading reviews? Review this list

Follow us on Twitter, YouTube, and Facebook

Support our community as an Elite Member:
https://futures.io/elite/
Follow me on Twitter Visit my Facebook Visit my futures io Trade Journal Reply With Quote
The following 3 users say Thank You to Big Mike for this post:
 
(login for full post details)
  #371 (permalink)
Czech Republic
 
Experience: Beginner
Platform: NinjaTrader
Trading: E7, M6E
 
petrmac's Avatar
 
Posts: 175 since Jun 2011
Thanks: 275 given, 210 received


madLyfe View Post
do you guys have to have a sample import file? i find myself going into sim and making random trades to be able to test..

Just run a sample strategy in ninja (strategy analyzer) and then export.

Visit my futures io Trade Journal Reply With Quote
The following user says Thank You to petrmac for this post:
 
(login for full post details)
  #372 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received


madLyfe View Post
@vvhg im still getting these in beta8:




Did I say that I hate links?

I'll track them down and kill them.




vvhg

Hic Rhodos, hic salta.
Reply With Quote
The following user says Thank You to vvhg for this post:
 
(login for full post details)
  #373 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received


Big Mike View Post
M6E should be 12,500 point value, $1.25 a tick.

Mike

Thanks, fixed it. I pulled it out of NT, apparently they've got it wrong!


madLyfe View Post
@vvhg im still getting these in beta8:


Next try attached.
Did I ever mention that I hate links???


petrmac View Post
Sorry, I meant the Overview tab.

Somehow the current balance stays the same after import (used to recalculate after defining the starting balance) and the equity curve stays the same...

Same for some other fields... I'll do some more tests...

This should hopefully be fixed as well. What I could find was due to that lin....sorry can't say that word any more.

vvhg

Hic Rhodos, hic salta.
Attached Files
Register to download File Type: rar Journal 2 .3beta9.rar (1.37 MB, 42 views)
Reply With Quote
The following 5 users say Thank You to vvhg for this post:
 
(login for full post details)
  #374 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received


vvhg View Post
Thanks, fixed it. I pulled it out of NT, apparently they've got it wrong!



Next try attached.
Did I ever mention that I hate links???



This should hopefully be fixed as well. What I could find was due to that lin....sorry can't say that word any more.

vvhg

nicely done! this version seems to be holding up well!

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

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
The following 2 users say Thank You to madLyfe for this post:
 
(login for full post details)
  #375 (permalink)
Czech Republic
 
Experience: Beginner
Platform: NinjaTrader
Trading: E7, M6E
 
petrmac's Avatar
 
Posts: 175 since Jun 2011
Thanks: 275 given, 210 received

Thanks for the new version, vvhg. I'll give it a try....

In the meantime I am working on the correct ticks count for currencies futures... mostly there. Now just have to do the math during the import (deduct the commissions etc).

I'll post a new version today.

Petr

Visit my futures io Trade Journal Reply With Quote
The following 3 users say Thank You to petrmac for this post:
 
(login for full post details)
  #376 (permalink)
Czech Republic
 
Experience: Beginner
Platform: NinjaTrader
Trading: E7, M6E
 
petrmac's Avatar
 
Posts: 175 since Jun 2011
Thanks: 275 given, 210 received

vvhg, I actually have a tip for the feature in the journal.
Wouldn't it be nice to have some graph showing the gap between the real vs unrealized profit? (i.e. the amount of money left on the table due to the bad exit).
Perhaps even link that to the time series - so that we can see whether we are getting better or not.

I am struggling with the exits in my discretionary trading and this could help me a lot.

Visit my futures io Trade Journal Reply With Quote
The following 3 users say Thank You to petrmac for this post:
 
(login for full post details)
  #377 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received


petrmac View Post
vvhg, I actually have a tip for the feature in the journal.
Wouldn't it be nice to have some graph showing the gap between the real vs unrealized profit? (i.e. the amount of money left on the table due to the bad exit).
Perhaps even link that to the time series - so that we can see whether we are getting better or not.

I am struggling with the exits in my discretionary trading and this could help me a lot.


Absolutely, have you got specific ideas how to visualize that best? I'll also think about it, perhaps draw a few sketches or so....


vvhg

Hic Rhodos, hic salta.
Reply With Quote
The following user says Thank You to vvhg for this post:
 
(login for full post details)
  #378 (permalink)
Czech Republic
 
Experience: Beginner
Platform: NinjaTrader
Trading: E7, M6E
 
petrmac's Avatar
 
Posts: 175 since Jun 2011
Thanks: 275 given, 210 received

Hello,

here is the new version of the importer.


New features:

- calculates the MAE/MFE from the currency amount of the trade (the export with units in currency is now supported). To do so it loads a csv with the instruments settings (instrument-list.txt) attached to the program.
- skips the Method and Comments fields in excel if data handling set to discretional (it puts there name of entry and followed rules for automatic)
- now features embedded journal excel beta 9


Here I would like to ask someone to fill in the settings for instruments into the instrument-list.txt file in order to support the currency format of data export:-)



Next feature to implement is to group the trades based on entry time (minute).

Attached Files
Register to download File Type: zip bin.zip (3.51 MB, 27 views)
Visit my futures io Trade Journal Reply With Quote
The following 3 users say Thank You to petrmac for this post:
 
(login for full post details)
  #379 (permalink)
Czech Republic
 
Experience: Beginner
Platform: NinjaTrader
Trading: E7, M6E
 
petrmac's Avatar
 
Posts: 175 since Jun 2011
Thanks: 275 given, 210 received


vvhg View Post
Absolutely, have you got specific ideas how to visualize that best? I'll also think about it, perhaps draw a few sketches or so....


vvhg


Well, I had an idea to show the line/or bar graph with the horizontal axis = time and vertical = ticks and display to series (realized profit, max unrealized profit per trade).
However the time is not hour in day, but rather each day (and in more detailed view each trade).

Maybe something like in the picture here but the lines in same graph or perhaps stacked bars (two for each trade).



What do you think?

Visit my futures io Trade Journal Reply With Quote
The following user says Thank You to petrmac for this post:
 
(login for full post details)
  #380 (permalink)
Czech Republic
 
Experience: Beginner
Platform: NinjaTrader
Trading: E7, M6E
 
petrmac's Avatar
 
Posts: 175 since Jun 2011
Thanks: 275 given, 210 received


vvhg View Post
@petrmac, could you have a look at the following link? It might be helpful/interesting? Import to excel programmatically


Vvhg

This is essentially what I am doing in the importer except I don't want to have anything to do with Microsoft Interop libraries. The are difficult to handle and the API is not well made. I prefer the library I am using right now.

Anyway, this does not solve the issue how to import to excel from within the excel:-)

I can do some research when I have more time...

Visit my futures io Trade Journal Reply With Quote
The following user says Thank You to petrmac for this post:
 
(login for full post details)
  #381 (permalink)
Czech Republic
 
Experience: Beginner
Platform: NinjaTrader
Trading: E7, M6E
 
petrmac's Avatar
 
Posts: 175 since Jun 2011
Thanks: 275 given, 210 received

Hey folks,

what do you think about the icon for the program? Perhaps if you have some ideas...

@Big Mike do you have some vertical logo image? I would paste it in the about box.

Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #382 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received


petrmac View Post
Well, I had an idea to show the line/or bar graph with the horizontal axis = time and vertical = ticks and display to series (realized profit, max unrealized profit per trade).
However the time is not hour in day, but rather each day (and in more detailed view each trade).

Maybe something like in the picture here but the lines in same graph or perhaps stacked bars (two for each trade).

What do you think?

I tried that, as can be seen below but I didn't like that....



So I tried the "potential profit 5 trades SMA "- "realised profit 5 trades SMA " here:



petrmac View Post
This is essentially what I am doing in the importer except I don't want to have anything to do with Microsoft Interop libraries. The are difficult to handle and the API is not well made. I prefer the library I am using right now.

Anyway, this does not solve the issue how to import to excel from within the excel:-)

I can do some research when I have more time...

I found something the other day, but it's on my ipad.... I'll post that link later...

Here is some pretty basic stuff, don't know if it is of any value to you....

vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #383 (permalink)
Czech Republic
 
Experience: Beginner
Platform: NinjaTrader
Trading: E7, M6E
 
petrmac's Avatar
 
Posts: 175 since Jun 2011
Thanks: 275 given, 210 received

I don't like the first graph either. It is to jagged so that one is easily lost in it.
But I think that losers (SL hit) are not that interesting in this case, since we are now concentrating on the money on the table... What about omitting the losers?

Just keep it simple... Two lines, one realized, one potential...

how does that appeal

Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #384 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received

this is an error that happened with the new version trying out these settings: also it is happening when appending to an existing journal as well..


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

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #385 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received

IDEA! ok i know were working on getting everything working for the normal features that we have outlined, but if i dont get this out it might get lost in the space that is my head!

i think an updater needs to be built into this importer.. so it will become and importer/updater app.. when new journal versions come out, all one will have to do is load up the old journal with all of the users trades, and then load up the new version of the journal, and it will import all the data safely so the end user doesnt have to worry about any mistakes complications! this would also help in diagnosing issues here because we could eliminate the end users error of 'mismigration'..

what you guys think?


petrmac View Post
I don't like the first graph either. It is to jagged so that one is easily lost in it.
But I think that losers (SL hit) are not that interesting in this case, since we are now concentrating on the money on the table... What about omitting the losers?

Just keep it simple... Two lines, one realized, one potential...

how does that appeal

this sounds pretty solid to me, but i also dont use all of the graphs as much either..

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

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
The following user says Thank You to madLyfe for this post:
 
(login for full post details)
  #386 (permalink)
Czech Republic
 
Experience: Beginner
Platform: NinjaTrader
Trading: E7, M6E
 
petrmac's Avatar
 
Posts: 175 since Jun 2011
Thanks: 275 given, 210 received


madLyfe View Post
this is an error that happened with the new version trying out these settings: also it is happening when appending to an existing journal as well..


Hmm, seems to me like an error in date.
Either there is a mismatch in the locale used to export the csv and the one selected in the importer or there is some malformed input.
Could you please send me a sample export file so that I am able to see how the dates are formatted?

Thanks

Visit my futures io Trade Journal Reply With Quote
The following user says Thank You to petrmac for this post:
 
(login for full post details)
  #387 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received


petrmac View Post
Here I would like to ask someone to fill in the settings for instruments into the instrument-list.txt file in order to support the currency format of data export:-)

hey @petrmac, im working on the text file for ya.. are you taking the description/name from NT? that way we can be consistent? also is this just for currencies?

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

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
The following 2 users say Thank You to madLyfe for this post:
 
(login for full post details)
  #388 (permalink)
Czech Republic
 
Experience: Beginner
Platform: NinjaTrader
Trading: E7, M6E
 
petrmac's Avatar
 
Posts: 175 since Jun 2011
Thanks: 275 given, 210 received


madLyfe View Post
hey @petrmac, im working on the text file for ya.. are you taking the description/name from NT? that way we can be consistent? also is this just for currencies?


Cool, that helps.
I have there just two entries for testing... so the description doesn't matter. You can easily use the ones from NT.

As for the list... no not just currencies, it is needed for all instruments if you for some reason want to import file that is in currency format (i.e. not points).
So put there anything you like...

Visit my futures io Trade Journal Reply With Quote
The following user says Thank You to petrmac for this post:
 
(login for full post details)
  #389 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received


petrmac View Post
Cool, that helps.
I have there just two entries for testing... so the description doesn't matter. You can easily use the ones from NT.

As for the list... no not just currencies, it is needed for all instruments if you for some reason want to import file that is in currency format (i.e. not points).
So put there anything you like...

ok ill use the NT description as the standard naming scheme them.. i am going to include the currencies that i have currently added(the most popular and a few extras) and then ill add the rest of what we have built into the journal as default. does that sound good? and like the journal, users and add their own instruments to suit their needs as they like beyond the defaults?

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

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #390 (permalink)
Czech Republic
 
Experience: Beginner
Platform: NinjaTrader
Trading: E7, M6E
 
petrmac's Avatar
 
Posts: 175 since Jun 2011
Thanks: 275 given, 210 received

Here is another update.

The issue pointed to is fixed.
I improved the error handling and thanks to @madLyfe there are already some instruments in the list. The importer can now read trades with them.

USAGE comment:
be careful when deciding the delimiter and the locale. Ninja will export the data based on the Windows regional settings and that can make a huge difference in the format of almost everything (decimal numbers - "." or ",", dates).

If there is a locale that is gravely needed, just drop me a line and I will add it. This is not a big change.

Attached Files
Register to download File Type: zip bin.zip (3.56 MB, 36 views)
Visit my futures io Trade Journal Reply With Quote
The following 5 users say Thank You to petrmac for this post:
 
(login for full post details)
  #391 (permalink)
Site Administrator
Swing Trader
Data Scientist & DevOps
Manta, Ecuador
 
Experience: Advanced
Platform: My own custom solution
Trading: Emini Futures
 
Big Mike's Avatar
 
Posts: 49,397 since Jun 2009
Thanks: 32,062 given, 96,675 received


petrmac View Post
@Big Mike do you have some vertical logo image? I would paste it in the about box.

Attached are some logos I have for the site. I generally just design them as needed, I don't have one that is very vertical.

Mike

We're here to help -- just ask

For the best trading education, watch our webinars
Searching for trading reviews? Review this list

Follow us on Twitter, YouTube, and Facebook

Support our community as an Elite Member:
https://futures.io/elite/
Attached Files
Register to download File Type: zip logos.zip (145.9 KB, 27 views)
Follow me on Twitter Visit my Facebook Visit my futures io Trade Journal Reply With Quote
The following 4 users say Thank You to Big Mike for this post:
 
(login for full post details)
  #392 (permalink)
Czech Republic
 
Experience: Beginner
Platform: NinjaTrader
Trading: E7, M6E
 
petrmac's Avatar
 
Posts: 175 since Jun 2011
Thanks: 275 given, 210 received


madLyfe View Post
IDEA! ok i know were working on getting everything working for the normal features that we have outlined, but if i dont get this out it might get lost in the space that is my head!

i think an updater needs to be built into this importer.. so it will become and importer/updater app.. when new journal versions come out, all one will have to do is load up the old journal with all of the users trades, and then load up the new version of the journal, and it will import all the data safely so the end user doesnt have to worry about any mistakes complications! this would also help in diagnosing issues here because we could eliminate the end users error of 'mismigration'..

what you guys think?



this sounds pretty solid to me, but i also dont use all of the graphs as much either..

Sounds solid:-) Let's do that. Maybe we could write somewhere all the features on the wish list at one place. I am already losing track.

Visit my futures io Trade Journal Reply With Quote
The following 2 users say Thank You to petrmac for this post:
 
(login for full post details)
  #393 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received


vvhg View Post
I found something the other day, but it's on my ipad.... I'll post that link later...

Here it is, could be helpful....


vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #394 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received


madLyfe View Post
ok ill use the NT description as the standard naming scheme them.. i am going to include the currencies that i have currently added(the most popular and a few extras) and then ill add the rest of what we have built into the journal as default. does that sound good? and like the journal, users and add their own instruments to suit their needs as they like beyond the defaults?

Great, just watch out, NT seems to have it wrong sometimes, see M6E.....


Vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #395 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received


petrmac View Post
Sounds solid:-) Let's do that. Maybe we could write somewhere all the features on the wish list at one place. I am already losing track.

I could do a list, that would at least be within the scope of my computer skills

Do you all want to send me PMs with your ideas?
I could collect them and then post all in a single reply.

Vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #396 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received


madLyfe View Post
ok ill use the NT description as the standard naming scheme them.. i am going to include the currencies that i have currently added(the most popular and a few extras) and then ill add the rest of what we have built into the journal as default. does that sound good? and like the journal, users and add their own instruments to suit their needs as they like beyond the defaults?


Reminder to myself....maybe when fully integrated any instruments not in the list could be pulled out of the journal?

Vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
(login for full post details)
  #397 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received


vvhg View Post
Reminder to myself....maybe when fully integrated any instruments not in the list could be pulled out of the journal?

Vvhg

that's perfect..

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

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #398 (permalink)
Victoria, Australia
 
Experience: Intermediate
Platform: NT, MT4
Broker: NT
Trading: Bund , ASX 200
 
Linds's Avatar
 
Posts: 409 since Jul 2010
Thanks: 879 given, 514 received

The following is a PM exchange I had with vvhg - posting here at his suggestion:


Hi VVHG

Just looking at your spreadsheet and thx for your efforts! I am not clear as to where the raw data comes from? Does it somehow feed in from NT? Or can I migrate data into it from existing spreadsheets? I do have spreadsheets of a different format and without some field information - ie I have not tracked mae/mfe or time in trade and I dont use VWAP. If have some fields blank will this cause serious functional issues? Also I am an all in all out trader so do I simply leave exit2 and 3 blank?

Sorry if some of these questions are answered in the thread.


many thx

Lindsay

Unfortunately at the moment you have to enter the data manually ( or use copy paste column by column from other excel files, but make sure to not paste the format, only paste values. How to do that can be found in a liknk in post #2 "migrating from older versions"), but we are working on a tool that will be able to import from NT, you can download it in the thread to play around with it.
If you don't enter mae and mfe that's ok but obviously some tools of the journal related to mae and mfe will not work. If you plan on using mae and mfe in the future, I would suggest to use two journals, one for the old data and one for the new data including mae and mfe ( otherwise when mae and mfe are only entered for half the trades it may lead to skewed results). Vwap can be omitted, I don't track it myself...the only thing not working then of course is the vwap statistics on the overview tab.
Regarding exits, it is up to three but if you only need one, that's fine ( obviously exit three statistics would not show as they don't apply).

Vvhg

Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #399 (permalink)
Victoria, Australia
 
Experience: Intermediate
Platform: NT, MT4
Broker: NT
Trading: Bund , ASX 200
 
Linds's Avatar
 
Posts: 409 since Jul 2010
Thanks: 879 given, 514 received

Thx vvhg

Another question/suggestion

Would it be possible for the spreadsheet to have the capacity to accept previously calculated trade system statistics so that it could generate synthetic trades/curves and other stats? For example - I know my

ave win
ave loss
win %
% of account I risk per trade

this defines my methodolgy

It would be great to be able to input those and be able to access the other functions on the SS.

thx

Lindsay

Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #400 (permalink)
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received


Linds View Post
Thx vvhg

Another question/suggestion

Would it be possible for the spreadsheet to have the capacity to accept previously calculated trade system statistics so that it could generate synthetic trades/curves and other stats? For example - I know my

ave win
ave loss
win %
% of account I risk per trade

this defines my methodolgy

It would be great to be able to input those and be able to access the other functions on the SS.

thx

Lindsay

I'm not sure I completely understand...are you referring to the Monte Carlo tab or the overview tab?

vvhg

Hic Rhodos, hic salta.
Reply With Quote
The following user says Thank You to vvhg for this post:


futures io Trading Community Psychology and Money Management > Trading Metrics for journals/record keeping


Last Updated on April 29, 2020


Upcoming Webinars and Events
 

NinjaTrader Indicator Challenge!

Ongoing
 

Finding Trading Opportunities Using Profile Charts w/Tradovate

Jan 28
 

Journal Challenge!

February
 

Battlestations!

March
     



Copyright © 2021 by futures io, s.a., Av Ricardo J. Alfaro, Century Tower, Panama, +507 833-9432, info@futures.io
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.
no new posts