I'm new to this site.
Let's see if anyone can help with this:
I have to work with data (dates and prices) related with two financial products from two different Stock Exchange, located in different countries so that the trading days don't always coincide (due to different public holidays).
So what happend is that the dates at the beginning are the same, but at the end, after 10 years of daily records, they differ of dozens of days.
I tried to manually line dates up (leaving a blank cell but this is not a problem I'll just copy the previous day's price) but this is taking just too long.
I guess if there is a smarter way to deal with this problem, but I have no clue by now.
If you have any advice it would be great!
thank you very much
ps. I hope that the title reflects the sense of the topic...