Below is a brief tutorial on how to use google finance & google forecast functions in Google Docs to create a dynamic forecast model. The free template enables you to:

1. Dynamically download stock information for a publicly traded company (mutual fund, etf, etc…), and

2. Forecast the price for 3 days using a dynamically updated time series model (ARIMA(1,1,0) for the geeks).

All data, including the model itself, is updated daily. You may view the spreadsheet used in the video at the bottom of the page, or make a copy of it (link to spreadsheet) in Google Docs for your personal use.