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
rtod2Asked:
Who is Participating?
 
MakriniConnect With a Mentor Commented:
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
 
rtod2Author Commented:
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
 
rtod2Author Commented:
Definitely.  Thank you Makrini !!
0
 
rtod2Author Commented:
Newest sheet v2.4f attached here.  Makrini, I look forward to chatting here at EE tomorrow!
TradeHist-2.4f.xlsm
0
 
rtod2Author Commented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.