Question: Create a Monte Carlo simulation in Microsoft excel to answer the following questions: You are trading futures for a proprietary trading firm. In order to

Create a Monte Carlo simulation in Microsoft excel to answer the following questions:

You are trading futures for a proprietary trading firm. In order to pass their test you have to make $1500 before hitting a trailing drawdown of $1500 in a $25000 account. The trailing drawdown starts at $23500 and increases with the maximum account balance so if a trade were to be made that results in a profit of $500 then the total account balance increases to $25500 and the trailing drawdown threshold increases to $24000. If you were to lose a trade for $250 then the account balance would be $25250 but the trailing threshold amount would remain at $24000 because it is $1500 below the maximum account balance. Each contract has an average risk of $175 and reward of $175. The probability of having a winning trade is 75%.

Please provide the formulas used in excel.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!