+ Reply to Thread
Results 1 to 3 of 3

Thread: Regression Analysis

  1. #1
    Points: 43, Level: 1
    Level completed: 86%, Points required for next Level: 7

    Thanked 0 Times in 0 Posts

    Regression Analysis

    Hey everyone,

    I have a regression model where I have as a dependent variable daily stock prices over 365 days for multiple stocks.

    I am wondering in which format I would arrange the data if I am interested in say predicting each stocks value in the future periods.

    My initial thought was to stack all the individual time series for each stock on top of each other, i.e. something like this:

    stock1price_day1 explVar1_for_Stock1_day1
    stock1price_day2 explVar1_for_Stock1_day2
    stock1price_day3 explVar1_for_Stock1_day3

    stock2price_day1 explVar1_for_Stock2_day1
    stock2price_day2 explVar1_for_Stock2_day2
    stock2price_day3 explVar1_for_Stock2_day3

    stock3price_day1 explVar1_for_Stock3_day1
    stock3price_day2 explVar1_for_Stock3_day2
    stock3price_day3 explVar1_for_Stock3_day3

    Would this be a meaningful approach or would this be problematic, because I would be assuming that each stock has the same sensitivity to the explVar1. Basically, I am wondering if I should be running a different regression for each stock?

    Thanks for any input.


  2. #2
    Omega Contributor
    Points: 38,413, Level: 100
    Level completed: 0%, Points required for next Level: 0
    hlsmith's Avatar
    Not Ames, IA
    Thanked 1,186 Times in 1,147 Posts

    Re: Regression Analysis

    I think many forecasting models use long data, so you list each stock's price as an observation (row) and have another variable called day. Day goes from 1 to your last date. Then you plot day on the X-axis and price on the Y-axis. I am not following your other concerns, so you have an explanatory variable that does not change??
    Stop cowardice, ban guns!

  3. #3
    Points: 43, Level: 1
    Level completed: 86%, Points required for next Level: 7

    Thanked 0 Times in 0 Posts

    Re: Regression Analysis

    Thank you hlsmith for your response.

    What you described is what I would like to do. However, I want to do this for multiple stocks. So I would have each row representing a daily observation for that one stock. Then after say 100 days, I have the same 100 days for stock 2 right underneath in that same column, and so on for the other stocks. So in the time column, I have values going from Day1 to Day100, and then starting again as Day1 to Day100 for each stock. Then I do the same for the explanatory variables, also repeating themselves.

    1) If I run one regression for the entire dataset, I would obtain a beta that would tell me how all of the stocks react on average to that one explanatory variable.

    2) If I run one regression for each stock separately, I would obtain a beta for each stock that reflects how that one stock reacts to that one explanatory variable.

    I am basically wondering if the first approach would make sense.

    My question then is, could I run a regression of the form: StockPrice on Explanatory variable

    for this entire data set or would I have to split the data for each stock and then run a regression for each stock separately.

    I hope this is clear, if not, please let me know.

+ Reply to Thread


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Advertise on Talk Stats