Solved

Notes needed

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

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

If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
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 …

862 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

24 Experts available now in Live!

Get 1:1 Help Now