[ rss / options / help ]
post ]
[ b / iq / g / zoo ] [ e / news / lab ] [ v / nom / pol / eco / emo / 101 / shed ]
[ art / A / beat / boo / com / fat / job / lit / map / mph / poof / £$€¥ / spo / uhu / uni / x / y ] [ * | sfw | o ]
logo
economics

Return ]

Posting mode: Reply
Reply ]
Subject   (reply to 7519)
Message
File  []
close
>> No. 7519 Anonymous
28th April 2019
Sunday 11:14 pm
7519 Monte carlo simulation
Ive been learning about regression analysis and monte carlo simulation.
Ive really enjoyed learning this but the @risk extension for my excel files is a bit expensive.

Ive read a an array of sources about monte carlo sim. but i was hoping someone on here might be able to help.
Can you create your own alternative to @risk and build your own monte carloe simulation on excel?

i hope this question makes sense as you can see im still a novice.

PS #7510. anti money laundering is a huge subject and perhaps reading academic journals and books would be more insightful than asking questions to strangers.

(A good day to you Sir!)
Expand all images.
>> No. 7526 Anonymous
29th April 2019
Monday 12:40 am
7526 spacer
Well, I'm not going to tell you how to commit crime. But if you really do want to build and run mathematical simulations then VBA is certainly not the way to go. It's clumsy, and you'll be stuck doing anything beyond the rudimentary.

C++ is the go-to language for this sort of thing (in my experience, though I expect to start an argument) but as a novice you'd be better off studying Python. It has a more intuitive syntax for developing your own algorithms. Get to grips with the basics of the ubiquitous NumPy package. And try following guides like this hastily-googled one:

https://towardsdatascience.com/monte-carlo-simulations-with-python-part-1-f5627b7d60b0
>> No. 7527 Anonymous
29th April 2019
Monday 6:31 am
7527 spacer
I've just read up about the algorithm here
https://www.investopedia.com/terms/m/montecarlosimulation.asp

And honestly it seems quite simple. Much simpler than formula I've built in the past.
It isn't a crystal ball for predicting the future and I'm not sold on its value as an investment tool. It clearly has real world applications but I think you would be better looking at events rather than presuming because a snapshot of the sales of pumpkins shows a significant increase of sales in October they will continue to rise in November.

>>7526
>C++ is the go-to language for this sort of thing (in my experience, though I expect to start an argument)

In my experience regardless of how obnoxious and clunky it maybe, people want these things modled in excel (not even VBA) on the vague presumption they can follow your working out. They don't trust the magic black box of 'programming'.

Return ]
whiteline

Delete Post []
Password