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
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?
Nice video content! Sorry for chiming in, I would love your opinion. Have you heard about - Sanames Stockify Scripophily (just google it)? It is an awesome one of a kind product for discovering the best options trading technique without the normal expense. Ive heard some super things about it and my buddy at last got excellent results with it.
Kudos for the Video clip! Excuse me for the intrusion, I would love your opinion. Have you researched - Sanames Stockify Scripophily (Sure I saw it on Google)? It is a great one off guide for discovering the best options trading technique minus the normal expense. Ive heard some incredible things about it and my coo-worker got amazing results with it.
My expertise is more in sales and operations forecasting and NOT capital markets. There are a ton of books on that subject. I will venture to guess that none of them are the magic formula everyone is seeking. My view of any forecasting is that they all attempt to predict the future and the future is not always or easily predictable.
Use the regression formula to predict. Watch from the 3:48 point. We use historical data of six months. We use the first five months to predict the sixth. Since we know the reality, we can immediately see how well our forecast is.
This was great, I've been looking for "predicting stocks" for a while now, and I think this has helped. Have you heard people talk about - Sanames Stockify Scripophily - (Have a quick look on google cant remember the place now ) ? Ive heard some great things about it and my buddy got excellent results with it.
Thanks for your comment. Of course you can use any method to TRY to project stock prices, but a method as in this would probably result in you losing a lot of money unless the stock was steadily increasing or decreasing. This is, however, an exercise for elementary forecasting techniques using real data... and closing stock prices are real data.
Constant is the "Intercept" under your coefficients table when you run your regression analysis (Data> data analysis> Regression). If you don't have the data analysis tab, you have to go to Options> Add-ins> Analysis TookPak.
Appreciate video content! Sorry for the intrusion, I am interested in your opinion. Have you heard the talk about - Sanames Stockify Scripophily (should be on google have a look)? It is a great one off product for discovering the best options trading technique without the headache. Ive heard some great things about it and my mate at very last got amazing success with it.
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.
Format the date value as a number. Behind the scene uses the Julian date so that the dates can be used in calculations. Sometimes the calculation is formatted as a date e.g. mm/dd/yyyy.
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.
yu zhang: it is indeed so dumb... if I were actually advocating this as a good method to predict stock prices. Rather, this is just part of a forecasting section of a course. I use stock data because they provide good time series data that, because of variation for a variety of reasons, can provide all the frustrations one will encounter in forecasting. Thanks for your comment
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.
LOL... this is a classroom exercise on using regression, exponential smoothing, and moving average. it uses real stock data but it is not intended to be used as a stock price predictor. But thanks for weighing in.
Of course it is lame. We simply us this to practice using regression in a Quantitative Analysis class. Linear models generally do not work for stock data. That is part of the learning.
someone teach him ctrl + shift + arrow (down) to select to entire set at once.
LOL tesakuler
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
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
How to change the date format to Julian date, it's not working for me
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?
Nice video content! Sorry for chiming in, I would love your opinion. Have you heard about - Sanames Stockify Scripophily (just google it)? It is an awesome one of a kind product for discovering the best options trading technique without the normal expense. Ive heard some super things about it and my buddy at last got excellent results with it.
Kudos for the Video clip! Excuse me for the intrusion, I would love your opinion. Have you researched - Sanames Stockify Scripophily (Sure I saw it on Google)? It is a great one off guide for discovering the best options trading technique minus the normal expense. Ive heard some incredible things about it and my coo-worker got amazing results with it.
My expertise is more in sales and operations forecasting and NOT capital markets. There are a ton of books on that subject. I will venture to guess that none of them are the magic formula everyone is seeking. My view of any forecasting is that they all attempt to predict the future and the future is not always or easily predictable.
panedole , why is it when everyone’s advertising this” Sanames Stocktify Scripophily” ,you all almost say the same thing Word for Word ????
Pretty good lesson if you are on the go
I run some data using regression in excel, the result only 48% accuracy from actual data.
It only shows the date does not predict the price!!!
Change The format to number it is prob on custom
Use the regression formula to predict. Watch from the 3:48 point. We use historical data of six months. We use the first five months to predict the sixth. Since we know the reality, we can immediately see how well our forecast is.
This was great, I've been looking for "predicting stocks" for a while now, and I think this has helped. Have you heard people talk about - Sanames Stockify Scripophily - (Have a quick look on google cant remember the place now ) ? Ive heard some great things about it and my buddy got excellent results with it.
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
Excuse me, but your time analysis show the stock price increasing in time.
You are looking at it backwards
You can't predict stock prices this way
Thanks for your comment. Of course you can use any method to TRY to project stock prices, but a method as in this would probably result in you losing a lot of money unless the stock was steadily increasing or decreasing.
This is, however, an exercise for elementary forecasting techniques using real data... and closing stock prices are real data.
I want to know where the constants come from?
Constant is the "Intercept" under your coefficients table when you run your regression analysis (Data> data analysis> Regression). If you don't have the data analysis tab, you have to go to Options> Add-ins> Analysis TookPak.
Appreciate video content! Sorry for the intrusion, I am interested in your opinion. Have you heard the talk about - Sanames Stockify Scripophily (should be on google have a look)? It is a great one off product for discovering the best options trading technique without the headache. Ive heard some great things about it and my mate at very last got amazing success with it.
It just does not work.
Can you use this format to simulate a baseball game
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.
Format the date value as a number. Behind the scene uses the Julian date so that the dates can be used in calculations. Sometimes the calculation is formatted as a date e.g. mm/dd/yyyy.
@@markgavoor2497 what's the reason to use Julian Date? I need the explanation to put in my report. thanks in advance
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.
yu zhang: it is indeed so dumb... if I were actually advocating this as a good method to predict stock prices. Rather, this is just part of a forecasting section of a course. I use stock data because they provide good time series data that, because of variation for a variety of reasons, can provide all the frustrations one will encounter in forecasting. Thanks for your comment
Please learn how to use excel or fast forward the bits where you’re figuring it out.
What did you do? You didn't predict at all the price. Change the name of your video. It is fake
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.
what is iqd strategy is...?
A bunch of bs calculation that says nothing about where stock price is going..many other factors manipulates price
LOL... this is a classroom exercise on using regression, exponential smoothing, and moving average. it uses real stock data but it is not intended to be used as a stock price predictor. But thanks for weighing in.
omg lame
Of course it is lame. We simply us this to practice using regression in a Quantitative Analysis class.
Linear models generally do not work for stock data. That is part of the learning.