[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

copy paste & recalculate



PureBytes Links

Trading Reference Links

No problem ...

Make a copy of the workbook.<G>

To use your own data in the Regression Trendlines workbook ... highlight all
the price data B5:F254. Right click ... then select "Clear Contents" from
the menu. This gets rid of all of the existing data and formulas.

Copy and paste in your own data ... then press "F9" to manually re-calculate
the worksheet. Re-calculation is very very fast.

Extend all columns down to run more years of data. Put a slider on your
chart to show only portions of the chart if you want. I deleted the random
generator columns on the far right ... AM etc. I think

To delete the auto run procedure when opening the workbook ... go to the
VBEditor (Alt + F11) and delete the "tools" module and then the chart.show
code when the message box appears.

Code VBA procedures using "macro record" etc. to run different trade system
tests and to change the variables at the top of the columns. You can code a
loop to run any series of variables that you want.

Best regards

Walter