Solved

Position number needed (take two)

Posted on 2011-03-14
3
221 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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

This article is the result of a quest to better understand Task Scheduler 2.0 and all the newer objects available in vbscript in this version over  the limited options we had scripting in Task Scheduler 1.0.  As I started my journey of knowledge I f…
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
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…

773 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