Link to home
Start Free TrialLog in
Avatar of rtod2
rtod2Flag for United States of America

asked on

Notes needed

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
Avatar of rtod2
rtod2
Flag of United States of America image

ASKER

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.
ASKER CERTIFIED SOLUTION
Avatar of Makrini
Makrini
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rtod2

ASKER

Definitely.  Thank you Makrini !!
Avatar of rtod2

ASKER

Newest sheet v2.4f attached here.  Makrini, I look forward to chatting here at EE tomorrow!
TradeHist-2.4f.xlsm