Solved

Position number needed (take two)

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Over the years I have built up my own little library of code snippets that I refer to when programming or writing a script.  Many of these have come from the web or adaptations from snippets I find on the Web.  Periodically I add to them when I come…
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 viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

911 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

16 Experts available now in Live!

Get 1:1 Help Now