Solved

Position number needed (take two)

Posted on 2011-03-14
3
223 Views
Last Modified: 2012-06-27
Spreads move together in tandem regardless of the number of legs it has.  In this spreadsheet, there are none over two (2) legs but a longer export will have more legs.  A row will have the same Pos# if any of legs of the Spread have matching I/S#'s.  They move up under their counterpart (in tandem) based on whether the position numbers are the same.

The Inst# column also should be renamed to I/S#.
TradeHist-2-4c.xlsm
0
Comment
Question by:rtod2
  • 2
3 Comments
 
LVL 10

Accepted Solution

by:
Makrini earned 500 total points
ID: 35135259
This should have problems discussed whilst EE was down.

 (Note this only has the original data in it as per request) TradeHist-2-4e.xlsm
0
 

Author Closing Comment

by:rtod2
ID: 35135264
Amazing!
0
 

Author Comment

by:rtod2
ID: 35135271
0

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
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…

726 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