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
rtod2Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
rtod2Connect With a Mentor Author Commented:
Corrected again to include the combining of columns (Symbol, Exp, Strike, Type).  This should have come first as well as it would have made what we are doing now a little easier to see.  Once the Exp date format is corrected, the columns should be combined.
TradeHist-2.2e.xlsm
0
 
MakriniCommented:
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?

0
 
rtod2Author Commented:
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
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
MakriniCommented:
Is the spy = 3 because the first time spy diagonal appears is strategy number 3?
0
 
MakriniCommented:
By the way I have to step out for a couple hours, but I will get back to this and do it for you.
0
 
rtod2Author Commented:
Yes, Exactly!
0
 
rtod2Author Commented:
Thank you very much for working on it.
0
 
rtod2Author Commented:
Sheet being worked on by others also.  First new version redirected here >> http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_26882968.html
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.