Hi everyone,

I’m exploring an idea and would appreciate insights from those more knowledgeable in this field. I’m considering using regression analysis to predict stock market returns. My approach involves selecting a few non-traditional variables to see if they significantly impact stock returns. For instance, one variable I’m considering is Research and Development expenses as a percentage of revenue.

Using Excel, I’ve managed to set up a basic model. The formula for predicting future stock prices is derived from the regression: it’s the intercept plus the coeffecent times each variables (variable1+ variable2, etc.).

However, I’m not well-versed in advanced mathematics or coding, and my knowledge is limited to basic concepts. Here are my questions:

  1. Could this model potentially work for predicting stock market returns?
  2. If there are limitations or reasons why it might not work, what are they?
  3. What should I consider to improve the model’s accuracy and reliability?
  4. Are there any additional inputs or variables that I should look into?

Any guidance, critiques, or suggestions would be greatly appreciated. I’m here to learn and understand more about this concept.

Thanks in advance!