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
Related Posts with Transforming weekdays data to fit with daily data
Remove double counting based on multiple criteriaHi all, I have a quite extensive dataset. I included a small part (I have a lot more variables) of …
How do we explain intercept parameters for a Weibull survival model?I have been using streg to fit predictive survival models (for time from diagnosis to death) to some…
Generating a random variable with a specific mean and sdHi, I would like to generate a random variable with a specific mean and standard deviation. It does…
Issue with dummy variables in mixlogitHello, I am trying to estimate the mixlogit using the below syntax: mixlogit choice distance fac_t…
xtpmg and mean groupHi all! I am trying to estimate an ARDL Mean Group model but when I enter my code: xtpmg d.EF d.Y d.…
Subscribe to:
Post Comments (Atom)
0 Response to Transforming weekdays data to fit with daily data
Post a Comment