Devam Ediyor

Monte Carlo Excel Add-In

I need to create a Monte Carlo excel add-in that will allow me to run simulations while displaying a pop up status bar for say "completing 1 of 50,000 simulations" or something like that, which also has a pause, start, and stop button on the window so if I need to cancel the simulation then I can. I already have an excel spreadsheet that is set up with a hidden personal file that also opens that has a formula I use to simulate random normal variables, but my problem is I don't know how to make this more efficient. Also, I would like to find a way to store data from the simulations and have it create a summary tab afterwards, but I don't know if that's possible. Right now, I just have a copy/paste built into the macro to drop the values into another worksheet. My problem is I would like to be able to use this simulation add-in for multiple projects which will have different setups, so I would like to be able to click on the Monte Carlo add-in allow me to basically define how many simulations, then select say the yearly simulated return and the ending simulated portfolio value and have those values stored somehow or summarized somewhere to make data analysis easier. I'm not that familiar with all this, so I could use some help. I need everything done in excel though because I would like to be able to send my colleagues the add-in to use as well. If you look in the attached macro file you'll see in Visual Basic editor Module97 has the coding I have been using to simulate random normal variables and the function. The excel file below is the file I am using to simulate portfolio returns which I want to have a way where I can store the simulated returns and the final portfolio value so I can use those in a summary somehow. The add-in will be used for multiple files though that's why I want to find a way to program it so that it can be used in various applications. For someone who knows what they are doing I don't expect this project to be that difficult.

There are also a ton of macros in the macro file that are for formatting styles and what not, I was wondering how easy it would be to make those macros into some kind of add-in so I don't have to have the hidden personal file.

Beceriler: Excel, Finans, İstatistik, Visual Basic

Daha fazlasını görün: monte carlo excel add, monte carlo excel, visual basic monte carlo, excel add monte carlo, monte carlo add excel, monte carlo portfolio returns excel, basic monte carlo function visual basic, visual basic excel monte carlo, monte carlo var macros, visual basic monte carlo simulation, monte carlo function excel, monte carlo add, create monte carlo excel, excel monte carlo, monte carlo simulation excel add, monte carlo formula excel, monte carlo simulation excel, where to find an editor, where find editor, where can i find a copy editor, problem set analysis, portfolio editor, i want to find an editor, how to find a editor, find my editor

İşveren Hakkında:
( 4 değerlendirme ) Farmington, United States

Proje NO: #4391505

Seçilen:

SteveP495

Excel VBA expert here (and teach the same). I have a background in Insto Finance and trading and have developed some models (including stat arb and index arb trading models for banks). My pedigree is in your PMB. Steve Daha fazlası

10 gün içinde 675$ USD
(1 Değerlendirme)
2.8

6 freelancer bu iş için ortalamada 555$ teklif veriyor

seaanddream

Hi, here is your excel vba coding expert, the top rated freelancer. I have statistics experience, ready to go ahead. regards,

in 15 gün içinde350$ USD
(20 Değerlendirme)
4.1
srdas2012

Hi We are VBA Expert Can Bring almost Vb in Macro,Please see our Past and current work,We will send you a PMB shortly

in 12 gün içinde750$ USD
(11 Değerlendirme)
3.4
JScottArnold

Good morning- I am a statistical and analytical consultant with years of experience with Excel tools and analysis. I'd be happy to take a look at your programs and convert them to addins. Let's talk and discuss the wor Daha fazlası

in 7 gün içinde605$ USD
(1 Değerlendirme)
2.8
sokhom168

I have 5 year significant experiences in Excel VBA programming and add-in development. Please leave this task to me so that I can build a great add-in Excel for you. Please refer to my portfolio on my previous jobs don Daha fazlası

in 10 gün içinde500$ USD
(0 Değerlendirme)
0.0
mathmario

Check my profile on linked in [url removed, login to view] I have been writing macros in Excel for over 10 years.

in 3 gün içinde450$ USD
(0 Değerlendirme)
0.0