Hi every body,
I have an historical data in the same worksheet, of stocks prices . Each stock with two columns: dates and prices. For the reason that stocks are from different contries, hence holidays days are different and then some dates are not availibale.
To avoid the biasis of correlation, i want to extract only stock prices that have the same dates in another worksheet, how to do so?
Thank you very much
Ps: sorry if my english seems bizad, cause it's not my first language :-\"
I have an historical data in the same worksheet, of stocks prices . Each stock with two columns: dates and prices. For the reason that stocks are from different contries, hence holidays days are different and then some dates are not availibale.
To avoid the biasis of correlation, i want to extract only stock prices that have the same dates in another worksheet, how to do so?
Thank you very much
Ps: sorry if my english seems bizad, cause it's not my first language :-\"