Solved

Add position numbers

Posted on 2011-03-13
13
268 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
Comment Utility
TradeHist-2.3g-1-.xlsm

Does this do that?
0
 

Author Comment

by:rtod2
Comment Utility
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
Comment Utility
Can I clarify?

1. Sort by Position number, then by spread number

2. Insert a blank row after every position number

?

0
 

Author Comment

by:rtod2
Comment Utility
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
Comment Utility
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
Comment Utility
TradeHist-2.3h.xlsm

This should be there depending on whether our "Pos" theory is correct
0
Highfive Gives IT Their Time Back

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!

 
LVL 10

Expert Comment

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

Author Comment

by:rtod2
Comment Utility
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
Comment Utility
Try this with the sort working

 TradeHist-2.3j.xlsm
0
 

Author Comment

by:rtod2
Comment Utility
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
Comment Utility
That's not the right way to say it.
0
 

Author Comment

by:rtod2
Comment Utility
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
Comment Utility
Starting over here.   Position number bad definition on my part.
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

771 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

12 Experts available now in Live!

Get 1:1 Help Now