I have the history for some stocks and shares. The history is in a worksheet sheet and there will be a column of dates in column A and columns of prices ( starting at row 8) .
I want this project to let me select a price column and create the study below in a new worksheet:
[url removed, login to view]
Yiou can store the source sheet & column in cells in the new sheet.
We need the data & chart in a new worksheet with a refresh button to recalculate the data & forecast.
The forecase data must be present in the sheet under the chart.
Clicking on the chart plot area should calculate a forward curve on the date along the X axis so we can see what the forecast was on that date and compare it with the actual data. We need to be able to draw the 3 forecasts on the clicked date if they are displayed in tte forecast.
I'd like to add some analysis to the chart like
Confidence interval, [url removed, login to view]
Regression : [url removed, login to view]
Excel Forcast : [url removed, login to view]
and STD Deviation plus 2 user defined moving averages
These can be toggled & adjusted by checkboxes on a user form where necessary.
Add 2 buttons on the sheet to let us select a different source series...
VBA only - if formulas used they must be added by VBA
Prices can have #N/A values so they must be allowed for in the calculations
Obviously changing the data source (column) can change the range of data used.
It has to look smart and be designed to add more analytics or perhaps plot a second column in the chart.
Knowlewdge of the subject is important..... Impress me :)
Let me know what you can do to improve the concept...
More work available to the successful bidder if all goes well.