rtod2
asked on
create column to denote leg#
I need a macro that will make a new output tab with a new column for the trade history section of the original tabs (pm or rm). Each row is considered a leg. I need the new column to denote a number for each leg of any spread type and start over with the next symbol. An example of what this might look like is shown here in the third column >> http://screencast.com/t/WF0hnvqi8pon
Note that the third column is not there by default and is created based on the spread. If it is a multi-legged spread, the column shows the number of legs. If it is a single-legged spread, it only shows one leg.
trade-macro-v2.1c.xlsm
Note that the third column is not there by default and is created based on the spread. If it is a multi-legged spread, the column shows the number of legs. If it is a single-legged spread, it only shows one leg.
trade-macro-v2.1c.xlsm
ASKER
That certainly doesn't create an output tab. Macro still needed.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ah, ok
Yeah I was wanting it to extract the trade history section and add a new row to the trade history.
Yeah I was wanting it to extract the trade history section and add a new row to the trade history.
so you're looking to create a new tab called "rm output" that does the same thing that pm output does?
At this point, I don't see the correlation between pm and pm-output so I wouldn't know how to make the rm output's data.
It seems you may need to break this down into smaller tasks (possibly with separate questions) such as:
1) search through the rm sheet looking for TYPE TRD in column C and place the corresponding value into a new tab called rm output
2) add a new column C in rm output called leg and populate it with "LEG" followed by a number there the number starts at 1 and increases by 1 every time the corresponding value in column B is blank
etc.
At this point, I don't see the correlation between pm and pm-output so I wouldn't know how to make the rm output's data.
It seems you may need to break this down into smaller tasks (possibly with separate questions) such as:
1) search through the rm sheet looking for TYPE TRD in column C and place the corresponding value into a new tab called rm output
2) add a new column C in rm output called leg and populate it with "LEG" followed by a number there the number starts at 1 and increases by 1 every time the corresponding value in column B is blank
etc.
ASKER
Yeah, just looking for it to extrapolate that section from either pm or rm and create the new column.
ASKER
=IF(AND(B2<>"",B2<>0),"Leg