Find Jobs
Hire Freelancers

Excel and VBA script for monte carlo simulation - some statistics needed

$25-250 USD

Imekamilika
Imechapishwa over 8 years ago

$25-250 USD

Kulipwa wakati wa kufikishwa
Hello, I\'d like somoene to code for me an Excel script, I\'m guessing which will require custom VBA coding, that performs a monte carlo style simulation based on some very simple betting assumptions. This is extremely straightforward. The only part that\'s not as basic is the \"Probability distribution\" part below, which requires some understanding of statistics. - Specifics - Assume I\'m betting in such a way that I win 50% of the time, lose 50% of the time. When I win, my typical return is 0.45% of my total bankroll. When I lose, my typical return is -0.20% of my total bankroll. Assume that my total bankroll is $100,000. Assume each bet ranges randomly between being between $375,000 and $750,000. Assume that I\'m paying a commission on my bets at a rate $0.000051 per $1 bet and subtract that from total bankroll on each bet. -Probability distribution of returns- In each bet simulation, you need to assume my average -0.20% loss amount can range from between -0.50% and -0.05%. So you\'ll need to figure out some kind of statistical formula that assumes a certain dispersion/distribution so that values fall in that range, yet the average still equals -0.20%. It should look somewhat like a bell curve in distribution, but adjusted to accommodate the dispersion I\'m assuming. For winners, the same applies, but the average 0.45% win amount needs to vary between 1.50% and a minimum 0.05%. -Changeable inputs and user interface- In the excel script, I\'d like to be able to easily change all of the above variables (numbers), each as a cell I can change, and once they are set, I\'d like to choose how many bets I\'d like to simulate. So once I enter, say, 5000 bets, then I\'d like to hit RUN and it runs the simulation. I\'d like the output to include a chart, a simple line chart, where the Y axis is Total bankroll (i.e., total capital in $) and the X axis is Number of Bets (i.e., cumulative count of bets). I\'ll be super happy if you can make the chart progress/draw live as the simulation is occurring. I\'d also like it to return as a percentage separately from the chart a figure called \"Maximum draw down\" which is expressed as a percent. Maximum draw down means that if you were to chart your cumulative $ returns over time as you bet, a draw downs are the moves down, in percentage terms, that you see on the chart after dropping below a previous high before the chart reaches a new high. The maximum draw down figure I\'d like in the output is the maximum (i.e., one highest) drawn down over the entire period of the chart. I\'d also love if this number live updates with the simulation. In addition to expressing the % maximum drawdown, I\'d also like to know how many bets it required before reaching a new high (i.e., how many bets before the max draw down ended). - Bids- That is all. The only other thing I\'d like is simple instructions for how to run the script, because I\'m not very familiar with running custom scripts in Excel. I\'d like this as fast as possible, but there is no strict deadline. So please note in your bid how long you estimate this will take, and I\'ll consider time vs. cost. Thanks for your bids!
Kitambulisho cha mradi: 9351512

Kuhusu mradi

2 mapendekezo
Mradi wa mbali
Inatumika 8 yrs ago

Unatafuta kupata pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa
Pata malipo kwa kazi yako
Eleza pendekezo lako
Ni bure kujiandikisha na kutoa zabuni kwa kazi
Imetolewa kwa:
Picha ya Mtumiaji
Hello there, I have been working excel and vba for multiple engineering application. I have built monte carlo simulation in vba as well. Looking to hearing from you. Regards
$166 USD ndani ya siku 3
4.4 (10 hakiki)
3.6
3.6
2 wafanyakazi huru wana zabuni kwa wastani $166 USD kwa kazi hii
Picha ya Mtumiaji
A proposal has not yet been provided
$166 USD ndani ya siku 6
0.0 (0 hakiki)
0.0
0.0

Kuhusu mteja

Bedera ya UNITED STATES
Seattle, United States
5.0
235
Njia ya malipo imethibitishwa
Mwanachama tangu Mac 2, 2007

Uthibitishaji wa Mteja

Asante! Tumekutumia kiungo cha kudai mkopo wako bila malipo kwa barua pepe.
Hitilafu fulani imetokea wakati wa kutuma barua pepe yako. Tafadhali jaribu tena.
Watumiaji Waliosajiliwa Jumla ya Kazi Zilizochapishwa
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Onyesho la kukagua linapakia
Ruhusa imetolewa kwa Uwekaji wa Kijiografia.
Muda wako wa kuingia umeisha na umetoka nje. Tafadhali ingia tena.