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
Get step-by-step solutions from verified subject matter experts
