Hey all,

I have attached the spreadsheet but what I am looking for is a way to randomise the Win/Loss outcome based on the select Win%.

In the spreadsheet I have the CHOOSE command which appears to work but only on a 50% outcome. I have tested this by coping and pasting (values only) the outcomes on a 2nd sheet, using the IF command to assign a value based on Win =1 and Loss = 0, Autosumming the totals and dividing against the total outcomes. From the last 15 refreshes the best result I have got is 57% Wins.

I know the sample size is small but ideally I would like to see a higher % than 57 if I am looking at a system of 85% wins (or what ever the amount is).

Thanks

Ill be around so please drop a question if my ramble makes no sense.

Trading Random Outcome and Growth.xlsx