asked on

Define Position Numbers

Without changing the order of the original at all, we need to define static Position Numbers as well. Note that the Leg#'s and Strategy#'s should be static as well as we may end up using them for sorting purposes.

Positions can be more than one spread of a particular symbol. There is only one type of position that encompasses two types of spreads so for now, there is no need to go there.

Rule1: There is never more than one symbol for any one position.
Rule2: 'Today' there is never more than one spread for any one position.

Given those two (2) rules, it should be relatively easy to figure out what makes up a position, and simply number them. Each position has one number for every row in that position.
TradeHist-2.2c.xlsm

Makrini

again not quite sure what a position number is. I don't know your data very well is all.

Can you type a couple in for me?

rtod2

ASKER

Here you go. Should be a little clearer. Before we go much further, I just noticed something else I should have corrected. The Expiration Date should be Month, Year for each. This is from a CSV export and the column doesn't matter right now but down the road it should be corrected to show in that format.
TradeHist-2.2d.xlsm

ASKER CERTIFIED SOLUTION

rtod2

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Makrini

Is the spy = 3 because the first time spy diagonal appears is strategy number 3?

Makrini

By the way I have to step out for a couple hours, but I will get back to this and do it for you.

rtod2

ASKER