Dear users,
My database consists of 26 countries with their daily stock returns from 1973, football matches of those countries on World Cups/European Cups for the last 40 years, the day of the week, and two dummies: "Win" and "Loss" for each football match. For all the wins and losses I have to get the first available trading day's stock return of that specific country and gather all those returns in a Win and a Loss group. Note that the majority of the matches is played on Saturday, so the stock return on Monday should be taken. I can't manage to tell Stata to take the country's first available stock return after a match. Many thanks for your help.
Best,
Lucas Lemmens
My database consists of 26 countries with their daily stock returns from 1973, football matches of those countries on World Cups/European Cups for the last 40 years, the day of the week, and two dummies: "Win" and "Loss" for each football match. For all the wins and losses I have to get the first available trading day's stock return of that specific country and gather all those returns in a Win and a Loss group. Note that the majority of the matches is played on Saturday, so the stock return on Monday should be taken. I can't manage to tell Stata to take the country's first available stock return after a match. Many thanks for your help.
Best,
Lucas Lemmens
Comment