Solved

Define Position Numbers

Posted on 2011-03-12
11
251 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
 
LVL 10

Expert Comment

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

Expert Comment

by:Makrini
Comment Utility
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
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 

Author Comment

by:rtod2
Comment Utility
Yes, Exactly!
0
 

Author Comment

by:rtod2
Comment Utility
Thank you very much for working on it.
0
 

Author Comment

by:rtod2
Comment Utility
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
 

Author Comment

by:rtod2
Comment Utility
0
 

Author Comment

by:rtod2
Comment Utility
0
 

Author Closing Comment

by:rtod2
Comment Utility
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

763 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

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now