Hi,
At the moment I'm writing on my thesis which is about Return and Reversal. To do this I need to construct a lot of portfolio's. At the moment I have 1100 stocks which I need to evaluate. As you can see from column A to C I have the different companies who where in the S&P 500 and from when till when. Column D are the monthly dates for which every stock (column E till XXX) shows it's closing price. The problem is that columns E till XXX also show stock data from when these stock's werent in the S&P500. Now I'm searching for a macro, formula,... which auto selects only the data I need. For example, If i wanne make a portfolio from 1992-1997. I only want the data of USG CORP from 1992-1997 selected and not the rest of the data (until 2016). If I have to do this by hand it would take me at least 3 days. So any help is very welcoming.
Kind regards,
Lauren
At the moment I'm writing on my thesis which is about Return and Reversal. To do this I need to construct a lot of portfolio's. At the moment I have 1100 stocks which I need to evaluate. As you can see from column A to C I have the different companies who where in the S&P 500 and from when till when. Column D are the monthly dates for which every stock (column E till XXX) shows it's closing price. The problem is that columns E till XXX also show stock data from when these stock's werent in the S&P500. Now I'm searching for a macro, formula,... which auto selects only the data I need. For example, If i wanne make a portfolio from 1992-1997. I only want the data of USG CORP from 1992-1997 selected and not the rest of the data (until 2016). If I have to do this by hand it would take me at least 3 days. So any help is very welcoming.
Kind regards,
Lauren