From 1993 to 2019, ~6500 days - scenarios, each is a bunch of calculation on option prices, combinations.... If I ran 10 scenarios, it took a few seconds for the computer to spit out the answer.
The professor who taught Excel VBA in Coursera said it is better to use Window for computation heavy tasks rather than Mac. So, I am looking at PC desktops, way cheaper than Mac with the same Intel processor. I will follow TheBidShort and look for core i9 with lots of cache and ram. Thank you for all your helps.
iron chef, I was only being sarcastic! You don't need a core i9. Macs are awesome. I still love my core i5 mac book pro that's 3 years old. Your code is off. Your Mac loves running monte carlo simulations. That's like the easiest task for it. You know whats going to give me a good laugh? You end up paying 5k for a high end desktop only to see your monte carlo simulation take 6 hours! also that professor has a few screws loose. Excel is single threaded. Your not going to get that big of a speed boost (very minimal) going from a core i7 to a core i9. Where you get the speed boost is making use of the additional cores by running the code in parallel. How many steps do you have in this simulation? It sounds like 1000000000000 With all that said. It's not a bad idea to spend the cash to build your own PC (what i did recetnly). Make sure you buy a top of the line mother board and a decent size case so you have room to "grow". This will save you money in the long run. FWIW I have a core i7 with 8 cores (same as what you have).
I almost forgot to mention the most important part. If you are going to be doing these often and you want to do more in depth analysis. Learn a programming language. That will make your simulations run way faster than any hardware upgrade. $30 a month for data camp or $10 a month for skill share. Better bang for your buck and long term goals.
Absolutely. Nothing is more cumbersome than vba. Every kid can learn python and they have packages that generate MC simulations and all associated stats and graphs. Same with R. Anyone who states they are too old to learn this should probably retire for good.
Building my own PC? Like asking a baby to do calculus. I am just starting to program VBA, so there are a lot of rooms for improvement. How do I know the codes are correct? I hand calculated the equations and verified that all the numbers and steps came out in agreement. Thank you for your coaching.
I thought VBA is sort of a programming language? I took classes in Excel and Excel VBA from Coursera. I am starting another class: programming in MATLAB? Why, I want to see if it is a better language for doing noise filtering?
Thanks for the suggestion. I will drop MATLAB and find classes in python and R. How do they interface with my Excel data sets?