I have a spreadsheet with 2 columns of values that I would like to use to determine the results of a series of transactions, being able to rerun the sorts numerous times to obtain different possible outcomes.
A copy of this file is attached.
Column A is the trade numbers from 1 to 100. Column B is whether the particular trade number is a winner or loser. For my purposes, I am assuming that 80% of the trades will be winners and 20% will be losers.
Once the columns are sorted, I need to be able to once again sort Column A back into normal ascending order while retaining the corresponding Column B values that were determined by the first 2 sorts.
I will then be able to able to apply my hypothetical rates of return for winners and losers to determine my maximum drawdown and highest trade balance for the total of 100 trades.
I want to be able to run this scenario as many times as I wish to get a good set of statistics from my win/loss parameters.
I have no idea as to how to accomplish this and would appreciate any help you can give me. I am more than willing to share and brainstorm stock and option trading ideas with any and all who are interested.
Thank you.
Bookmarks