Regression wheater on stock return
Posted: Thu Jun 30, 2016 6:33 am
Hi you guys. I think I have a problem. I want to investigate the effect of the wheater on the stock return. So I have 5 cities covered in my dataset (Amsterdam,Brussel,Frankfurt,New York and Dublin). From these cities I have the index returns from the periods 1995-2014. I also have the skycoverage of each of this cities from the period 1995-2014. Skycoverage ranges from 0 to 8 (0 means clear and 8 overclouded). So what I want to do is to investigate the difference return on days with an skycoverage of 0-1(sunnydays) and overclouded days (7-8). My idea was to use a dummy variable and to run two regressions. First I run an regression with the dummy I called clear and than another with the dummy called overclouded. I shave sent an example of one of the regression containing data of NY. I was wondering if I doing the regressions in a good way or that I maybe need to change something. I hope you guys can help me out!!