Solved

Notes needed

Posted on 2011-03-14
6
347 Views
Last Modified: 2012-06-27
I need the macro expanded to take notes from the Order History moved to the first empty column at the end of the same item in the output tab.  Below is my best attempt at describing how that might work.

The Account Order History, filled and expired items only, precedes the same item in the Account Trade History.   I need to have the macro place the notes from each of the filled and expired items of the Account Order history next to the correct row in the Output tab title Account Trade History.  To find where to place a noted item from the original Account Order History, you would look for a date/time that is the same or newer, and has the same Symbol and Spread.  You could also use date from what is a combined column in the Output tab called Instrument.

TradeHist-2-4e.xlsm
0
Comment
Question by:rtod2
  • 4
6 Comments
 

Author Comment

by:rtod2
ID: 35135274
It would also be nice if the Leg#'s could be correctly reflected for butterflies which are three (3) legs, and condors which are four (4) legged trades.  That does not mean that the entire Pos consists of only three (3) or four (4) legs.
0
 
LVL 10

Accepted Solution

by:
Makrini earned 500 total points
ID: 35135293
Will have a closer look again on this later.  Should be able to take it to the next step reasonably easily.  We are through the hardest parts
0
 

Author Comment

by:rtod2
ID: 35135295
Definitely.  Thank you Makrini !!
0
 

Author Comment

by:rtod2
ID: 35135396
Newest sheet v2.4f attached here.  Makrini, I look forward to chatting here at EE tomorrow!
TradeHist-2.4f.xlsm
0
 

Author Comment

by:rtod2
ID: 35153347
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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

Title # Comments Views Activity
Need Help with Mapping ONLY 9 26
MS Excel Formula Help 3 35
vba to flip column 14 21
collaboration tool but not sharpoint 2 11
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…
With User Account Control (UAC) enabled in Windows 7, one needs to open an elevated Command Prompt in order to run scripts under administrative privileges. Although the elevated Command Prompt accomplishes the task, the question How to run as script…
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…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

830 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