Solved

Add position numbers

Posted on 2011-03-13
13
273 Views
Last Modified: 2012-05-11
Start numbering Pos#'s at 1 from top to bottom and look for rows with matching Symbol and Instruments.  If any rows exist where both Symbol and Instrument matches, then they take on the same Pos#.  Also, only one Pos# per Spread# can exist.  

It is important at this stage to re-confirm that the order has still not changed from the original.

Assistance is greatly appreciated.
TradeHist-2.3g.xlsm
0
Comment
Question by:rtod2
  • 8
  • 5
13 Comments
 
LVL 10

Expert Comment

by:Makrini
ID: 35124721
TradeHist-2.3g-1-.xlsm

Does this do that?
0
 

Author Comment

by:rtod2
ID: 35124754
I should have expanded the question to include the grouping of items within the same position.  Note that each spread# must stay together and sort in tandem.  The positions should be separated by an empty row.  I expect this to be the most difficult one to perfect but hopefully, I have done enough defining prior to this step to get is there.  It looks like we are almost home free surprisingly.  Let me know if you want me to re-ask in another thread and I will be glad to do that.  Thank you for your help.
0
 
LVL 10

Expert Comment

by:Makrini
ID: 35124761
Can I clarify?

1. Sort by Position number, then by spread number

2. Insert a blank row after every position number

?

0
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 

Author Comment

by:rtod2
ID: 35124770
Yes, I think so.  I could be completely off on this but I believe so.  The following will also improve readability I think.

Change Pos# and Spread# contents to reflect the actual name of the the column Ii.e. Pos1, Pos2, Pos3, etc; and Spread1, Spread2, Spread3 respectively)
0
 

Author Comment

by:rtod2
ID: 35124796
Just noticed an issue.  It doesn't stand to reason that there would be as many Pos#'s as there are Spread#'s.  Instead there would be considerably less.
0
 
LVL 10

Accepted Solution

by:
Makrini earned 500 total points
ID: 35124820
TradeHist-2.3h.xlsm

This should be there depending on whether our "Pos" theory is correct
0
 
LVL 10

Expert Comment

by:Makrini
ID: 35124822
Didn't read your last comment till this.  We can have a look and find out where is wrong
0
 

Author Comment

by:rtod2
ID: 35124843
Yeah, not quite there.  Not sure where we went wrong in the logic.  It's difficult to define position.  Still looking for one that is wrong.  I think once the spreads/pairs are moved under their respective positions such that all the same position numbers appear together, it will be easier to sort out.  Not at all sure at this stage.
0
 
LVL 10

Expert Comment

by:Makrini
ID: 35124862
Try this with the sort working

 TradeHist-2.3j.xlsm
0
 

Author Comment

by:rtod2
ID: 35124891
Every leg (usually every spread), if the trade is finished, should have two spread numbers at least associated with it in order to form a position.
0
 

Author Comment

by:rtod2
ID: 35124893
That's not the right way to say it.
0
 

Author Comment

by:rtod2
ID: 35124915
Every Spread has at least an Entry side (consisting of at least 1 leg), and an Exit side (consisting of at least 1 leg).  Often, there is an adjusting spread or two in between.  Each position contains only one type of spread with only one exception.  We don't need to discuss the exception yet.
0
 

Author Closing Comment

by:rtod2
ID: 35130035
Starting over here.   Position number bad definition on my part.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

772 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