Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 287
  • Last Modified:

Add position numbers

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
rtod2
Asked:
rtod2
  • 8
  • 5
1 Solution
 
MakriniCommented:
TradeHist-2.3g-1-.xlsm

Does this do that?
0
 
rtod2Author Commented:
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
 
MakriniCommented:
Can I clarify?

1. Sort by Position number, then by spread number

2. Insert a blank row after every position number

?

0
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.

 
rtod2Author Commented:
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
 
rtod2Author Commented:
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
 
MakriniCommented:
TradeHist-2.3h.xlsm

This should be there depending on whether our "Pos" theory is correct
0
 
MakriniCommented:
Didn't read your last comment till this.  We can have a look and find out where is wrong
0
 
rtod2Author Commented:
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
 
MakriniCommented:
Try this with the sort working

 TradeHist-2.3j.xlsm
0
 
rtod2Author Commented:
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
 
rtod2Author Commented:
That's not the right way to say it.
0
 
rtod2Author Commented:
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
 
rtod2Author Commented:
Starting over here.   Position number bad definition on my part.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 8
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now