I have collected data for the period of 2002 to 2018 for following indices Nifty (India), NASDAQ (US), ADX (UAE) and TASI (Saudi Arabia). After collection, I have arranged data in a single sheet with the date and closing price for all the four indices. As we know the working days differ for stock markets there are missing dates between each countries. For example, It is a holiday for Saudi Arabia and UAE stock exchanges on Fridays, whereas it is working day for the other two exchanges. Kindly, let me know how to deal with this missing values.
What I felt is to copy and paste the closing price of previous days closing for missing periods. Is it the right approach? or is there any other alternatives.