Common Dates. Is this possible?
Hello,
I have 3 time series on a excel worksheed (EurUsd, Euribor and Dow).
Each time series has two columns: Values and Date. This is daily data.
The problem is that for one I have 800 values, for other 820 and for
the other 810.
This is normal. In some days a market can be closed while the other is
open.
Is it possible to select only the values where all the markets are
open?
Basically I need to create 4 columns:
Date, EurUsd Value, Euribor Value and Dow Value
Only for the dates where all markets are open, so an intersection by
date.
I need to do this only once.
Thanks,
Miguel
|