[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Define Position Numbers

Posted on 2011-03-12
11
Medium Priority
?
265 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
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
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: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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

If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

591 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