Hi!
Thanks a lot for all the suggestions for solutions, it is really helpfull. I will try them out and get back to you asap.
My biggest concern - and maybe I was not specific enough - is that it is only some of the data that needs to be mended.
So my data set looks something like this:
Date, BM, Asset_Class, Weight, Return
23-11-2015, BM1, Stocks, 30%, 2,0%
24-11-2015, BM1, Stocks, 30%, 1,5%
25-11-2015, BM1, Stocks, 30%, 1,2%
23-11-2015, BM2, Stocks, 23%, 3,1%
24-11-2015, BM2, Stocks, 26%, 0,2%
25-11-2015, BM2, Stocks, 23%, 4,5%
23-11-2015, BM1, Bonds, 15%, 3,1%
24-11-2015, BM1, Bonds, 15%, 0,2%
25-11-2015, BM1, Bonds, 15%, 4,5%
23-11-2015, BM2, Bonds, 17%, 2,0%
24-11-2015, BM2, Bonds, 18%, 1,5%
25-11-2015, BM2, Bonds, 17%, 1,2%
So if the asset class equals stocks, then I would like to mend the rows so I use everything but the return from BM1, and only the return coloum from BM2. Afterwards, every row with BM2 should be deleted from the data set. For Bonds (and all other asset classes) I would just like to delete the rows containing BM2 (not mending the return column).
Thanks a lot again!
- Joe.
... View more