Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Position number needed (take two)

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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

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…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
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…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

829 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