Solved

Define Position Numbers

Posted on 2011-03-12
11
258 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

 
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

705 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