Solved

Notes needed

Posted on 2011-03-14
6
335 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Math Incorrect 2 21
Excel 2010 - Column Heading Formating 6 13
MS Excel Vllokup or formula to see if a record exists... 1 21
VBScript Write Column Headers 3 31
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 view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
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…

815 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

13 Experts available now in Live!

Get 1:1 Help Now