[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Define Position Numbers

Posted on 2011-03-12
11
Medium Priority
?
262 Views
Last Modified: 2012-05-11
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
0
Comment
Question by:rtod2
  • 8
  • 3
11 Comments
 
LVL 10

Expert Comment

by:Makrini
ID: 35118754
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
 

Author Comment

by:rtod2
ID: 35118800
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
 

Accepted Solution

by:
rtod2 earned 0 total points
ID: 35118899
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 10

Expert Comment

by:Makrini
ID: 35118933
Is the spy = 3 because the first time spy diagonal appears is strategy number 3?
0
 
LVL 10

Expert Comment

by:Makrini
ID: 35118936
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
 

Author Comment

by:rtod2
ID: 35118937
Yes, Exactly!
0
 

Author Comment

by:rtod2
ID: 35118939
Thank you very much for working on it.
0
 

Author Comment

by:rtod2
ID: 35119754
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question