Forecast function

[phyrebrand]

I have data for dates and the closing price of a stock for each date. I need to forecast the next one.

I'm not sure what to do because the dates are a different data value than the prices and I get N/A. Do you know what other calculation(s) I need to do to complete the problem?

Thanks.

 

[Jon von der Heyden]

Hello and welcome to MrExcel.com

If you are happy that linear regression will yield an accurate enough forecast then perhaps this;

Excel Workbook
	A	B	C	D	E	F	G	H	I
1	01/01/2008	02/01/2008	03/01/2008	04/01/2008	05/01/2008	06/01/2008	07/01/2008	08/01/2008	09/01/2008
2	0.68	5.43	8.23	2.32	0.54	7.05	5.45	5.34	5.8478571
Index

 

[phyrebrand]

It does work!

Thank you so much for helping me.