Excel VBA to simulate scenarios
- or -
Post a project like this€300(approx. $323)
- Posted:
- Proposals: 9
- Remote
- #2259901
- OPPORTUNITY
- Expired
Google sheets apps script GAS VBA Excel Macro VB.NET ADD-INS Web Scrap API developer
Kharkiv
57355211927981371827144947316528642367525251990725420222559045
Description
Experience Level: Expert
Estimated project duration: less than 1 week
For a project I am looking for a VBA script that can do a Monte Carlo simulation:
- Simulating the Normal, Lognormal, Uniform, Triangular, PERT, Discrete inputs, based on values selected in Excel.
- Simulate based on historical information (e.g. stock prices).
- The simulated inputs should be easily integrated in a (third party) model.
- Storing the various values, plotting graphs, basic statistics (mean, mode, stdev etc.).
- Doing millions of simulations.
I am very keen on the readability of the code and I will test the script extensively, since this code will be used for high-end deals.
Please provide me with examples of your work, so I can check if you are able to meet the standards.
- Simulating the Normal, Lognormal, Uniform, Triangular, PERT, Discrete inputs, based on values selected in Excel.
- Simulate based on historical information (e.g. stock prices).
- The simulated inputs should be easily integrated in a (third party) model.
- Storing the various values, plotting graphs, basic statistics (mean, mode, stdev etc.).
- Doing millions of simulations.
I am very keen on the readability of the code and I will test the script extensively, since this code will be used for high-end deals.
Please provide me with examples of your work, so I can check if you are able to meet the standards.
Pieter S.
100% (3)Projects Completed
5
Freelancers worked with
5
Projects awarded
31%
Last project
6 Sep 2022
Netherlands
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies