Dark Theme
Light Theme
Trading Articles
Article Categories
Article Tools
Welcome to NexusFi: the best trading community on the planet, with over 150,000 members Sign Up Now for Free
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 for basic access, or support us by becoming an Elite Member -- see if you qualify for a discount below.
-- Big Mike, Site Administrator
(If you already have an account, login at the top of the page)
Updated June 2, 2023
Top Posters
looks_one
vvhg
with 354 posts (690 thanks)
looks_two
madLyfe
with 202 posts (104 thanks)
looks_3
petrmac
with 73 posts (106 thanks)
looks_4
Big Mike
with 35 posts (165 thanks)
Best Posters
looks_one
PandaWarrior
with 75 thanks per post
looks_two
Big Mike
with 4.7 thanks per post
looks_3
vvhg
with 1.9 thanks per post
looks_4
petrmac
with 1.5 thanks per post
trending_up
376,071 views
thumb_up
1,509 thanks given
group
234 followers
forum
946 posts
attach_file
252 attachments
January 4th, 2012, 07:51 AM
Northern Germany
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
Posts: 1,580 since Mar 2011
Thanks Given: 1,016
Thanks Received: 2,824
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
Can you help answer these questions from other members on NexusFi?
Best Threads (Most Thanked) in the last 7 days on NexusFi
January 4th, 2012, 10:28 AM
Des Moines, Iowa
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
Posts: 1,641 since Feb 2011
Thanks Given: 9,220
Thanks Received: 1,021
vvhg
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
¯\_(ツ)_/¯
(╯°□°)╯︵ ┻━┻
January 4th, 2012, 10:43 AM
Des Moines, Iowa
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
Posts: 1,641 since Feb 2011
Thanks Given: 9,220
Thanks Received: 1,021
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
¯\_(ツ)_/¯
(╯°□°)╯︵ ┻━┻
January 4th, 2012, 11:11 AM
Northern Germany
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
Posts: 1,580 since Mar 2011
Thanks Given: 1,016
Thanks Received: 2,824
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
January 4th, 2012, 11:15 AM
Des Moines, Iowa
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
Posts: 1,641 since Feb 2011
Thanks Given: 9,220
Thanks Received: 1,021
vvhg
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
¯\_(ツ)_/¯
(╯°□°)╯︵ ┻━┻
January 4th, 2012, 11:21 AM
Northern Germany
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
Posts: 1,580 since Mar 2011
Thanks Given: 1,016
Thanks Received: 2,824
madLyfe
was hard to do anything with the compile errors firing off every time you clicked anywhere..
Just delete the top 2 rows.
vvhg
January 4th, 2012, 11:22 AM
Des Moines, Iowa
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
Posts: 1,641 since Feb 2011
Thanks Given: 9,220
Thanks Received: 1,021
vvhg
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
¯\_(ツ)_/¯
(╯°□°)╯︵ ┻━┻
January 4th, 2012, 12:24 PM
Northern Germany
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
Posts: 1,580 since Mar 2011
Thanks Given: 1,016
Thanks Received: 2,824
madLyfe
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
Attached Files
Elite Membership required to download: Journal 2 .3beta7.rar
January 4th, 2012, 12:28 PM
Des Moines, Iowa
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
Posts: 1,641 since Feb 2011
Thanks Given: 9,220
Thanks Received: 1,021
vvhg
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
¯\_(ツ)_/¯
(╯°□°)╯︵ ┻━┻
January 4th, 2012, 12:34 PM
Des Moines, Iowa
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
Posts: 1,641 since Feb 2011
Thanks Given: 9,220
Thanks Received: 1,021
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
¯\_(ツ)_/¯
(╯°□°)╯︵ ┻━┻
Last Updated on June 1, 2023