Solved

Position number needed (take two)

Posted on 2011-03-14
3
224 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
[X]
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
  • 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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

: Microsoft Office Collaborate for free and online versions of Microsoft  Word, Excel, Powerpoint, OneNote, Onedrive , Email, Calendar etc. In short we can say that Microsoft office is a suite of servers, applications and services developed by  Micr…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

696 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