HarryC23
04-08-2014, 09:04 AM
Hi all,
I'm a bit stuck trying to use a macro for the first time. I've got a dataset of certain trades across different markets and traders, and on different days. The date of the trade is in column A, the contract ID is column D and the trader ID is column J.
Traders do not trade every day. I would like to insert a new row/rows for each date on which traders do not trade between their first and last trade, for each market in which they participate.
Is this possible using macros?
And, if so, then I would like to insert the high and low prices for the market on those dates from a different worksheet into the newly created blank rows. On this second workbook the contract ID is column A, the date is column C, the high price is column F and the low price is column E. I would like the low price to be inserted into column AJ on the original worksheet and the high price into column AK.
This second bit might be a bit trickier. Even if you could only help with the first part it really would be much appreciated.
Thanks,
Harry.
(n.b. I've also posted this on ExcelForum.com)
I'm a bit stuck trying to use a macro for the first time. I've got a dataset of certain trades across different markets and traders, and on different days. The date of the trade is in column A, the contract ID is column D and the trader ID is column J.
Traders do not trade every day. I would like to insert a new row/rows for each date on which traders do not trade between their first and last trade, for each market in which they participate.
Is this possible using macros?
And, if so, then I would like to insert the high and low prices for the market on those dates from a different worksheet into the newly created blank rows. On this second workbook the contract ID is column A, the date is column C, the high price is column F and the low price is column E. I would like the low price to be inserted into column AJ on the original worksheet and the high price into column AK.
This second bit might be a bit trickier. Even if you could only help with the first part it really would be much appreciated.
Thanks,
Harry.
(n.b. I've also posted this on ExcelForum.com)