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)
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.
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....)
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.....
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.
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.