Predicting a Stock Price Using Regression

Using 6 months and 1 month of Historical Data to predict GM Closing Price in October 2015 by linear regression in Excel.

This in not intended to use to really predict stock prices. It is merely an exercise to practice using simple linear regression on some real data. Nothing more :)

[burakatas]

someone teach him ctrl + shift + arrow (down) to select to entire set at once.

[leecurcio]

What did you do? You didn't predict at all the price. Change the name of your video. It is fake

[andycobraaor]

Mr. Mark

Thank you, great job, I was planning to use the Neuro XL but I can't get it install it in Microsoft Office Excel version 2011. I'm working to find out more about what is the closes Stock price prediction formula, yours looks really good, Thanks

Respectfully;
Andy

[nitinrindhe]

How to change the date format to Julian date, it's not working for me

[youngbelieve]

It only shows the date does not predict the price!!!

[ednakazuya]

Pretty good lesson if you are on the go

[tomcruise]

If we manually compute the value of forecast with E2=15274, the value doesn't match with what is calculated on the excel.please explain

[mrignayani]

Thank you, every one has video's to do the forecast of the actual data, but no one did how to forecast for the real future

[reelzerotuned]

I run some data using regression in excel, the result only 48% accuracy from actual data.

[ronschmick]

Thank you Professor Gvoor, thanks for sharing. As you clearly stated in the video these models won't work well in the capital markets. Can you suggest which models might be a better fit?

[mehtasid]

You can't predict stock prices this way

[JuliusTanuwijaya]

I want to know where the constants come from?

[rickswineberg]

Excuse me, but your time analysis show the stock price increasing in time.
You are looking at it backwards

[BillyBellaBiliBala]

May I ask that how to produce the forecast price? I can only produce a date instead of price after I type in the formula as u did. I have tried to transfer the date to julian date then do the forecast, but it is still unsucessful.

[zhangyu]

It is so dumb to use excel to predict price. Actually he used linear regression way to predict the price. calculate the intercept and slope of the line. Use python should be better.

[ezziaryoussra]

I don't know anything much about stock market or trading earlier. I am a veteran from Ireland. i begin to get interest after knowing more about IQD strategy momentum introduce by lukasz wilhelm. Your videos are quite interesting and a lay man like me could follow and understand to a great extent. just as like Iqd strategy. Very interesting Thank you.

[emensonjean]

Can you use this format to simulate a baseball game

[papitom]

A bunch of bs calculation that says nothing about where stock price is going..many other factors manipulates price

[lijojose]

Please learn how to use excel or fast forward the bits where you’re figuring it out.