Hi,

I'm still relatively new to Stata. I am going to run a regression on Bitcoin price, MSCI World Index and Gold price, whereas Bitcoin price as the dependent variable and MSCI World Index and gold price as independent variables.

I have gathered data from July 24th until September 21st for all three variables.

I have strings for the dates in the kolonne all to the left, ranging from September 21st 2020 to July 24th 2017, followed by Bitcoin price, MSCI World price and gold price numerical.

The problem: Bitcoin prices has daily observations, the other two variables only have observations for weekdays. Meaning that Bitcoin prices has 1156 observations, while MSCI World historical price has 826 observations and historical gold price has 823 observations (I do not know why the last two differs, probably some missing values while collecting the data).

Are there some way I can put in empty observations (observations with value zero?) for the weekend dates throughout the data? Or will I have to go to my excel-sheet and do this manually?

Thank you in advance
Tor Magne