Ozgrid, Experts in Microsoft Excel Spreadsheets Software Search, Categories and Specials Similar Products
AnalyzerXL | Bulk Quotes Excel | DownloaderXL | Real Time Quotes Excel
Predictor Excel | Back-testing Excel | Clusterizer Excel | Portfolio Excel
Options Excel | Neuro Excel Package | Visual Options Analyzer | TraderXl
Forecaster Excel | Neuro Intelligence
Build Automated Trading Models In Excel

Analyzer Excel Tutorial Page 2 of 2

 

 

Back-test Strategy

Buy Today (below) and send us your order ID and claim over $70.00 worth of FREE software

Analyzer Excel Package Start

Visit Developers Site For More Like This
Of Analyzer Excel Package Which Includes DownloaderXL
Both are also part of the Trader Excel Package Special.

Backtest StrategyTask:

Create code and backtest strategy, based on the RSI expert values.

1 Select item under the BacktestingXL menu to open Strategy Editor:

2 Change Strategy Name to "RSI Strategy":

3 It is recommended to use variables to increase strategy code readability. Write the following string:

4 What is RNG("G1")? RNG() function enables you to use values from worksheet in your strategy. As you remember we have Cutler's RSI Expert Values, located in G column with column header in G1 cell:

5 To create action-code, write the following string:

6 Strategy code creation complete. The strategy code should look like this:

8 Select item, to open Detailed Report Wizard:

9 Click AutoFind button, to automatically locate all available historical data series:

10 Select INTC data series from the list and switch to Strategy tab:

11 Select RSI Strategy from the list and click Settings button. Set them as shown on the picture and click Ok:

12 Click Ok on the Detailed Report Wizard window to generate report.Task Results

7-worksheet detailed strategy test performance report will be generated.

Conclusion: purely-RSI-based strategy has bad performance

Recommendations:

Analyzer Excel Start > Analyzer Excel Screen Shots > Tutorial Page 1 > Tutorial Page 2

Visit Developers Site For More Like This
Of Analyzer Excel Package Which Includes DownloaderXL
Both are also part of the Trader Excel Package Special.

Analyzer Excel Package $99.95 Secure Payment Options Save by buying as part of: Trader Excel Package

BEFORE INSTALLATION FOR 97-2007-2010
Excel 97-2003Excel 2007-2010
  1. Open any Excel Workbook. Go to Tools>Macros>Security - Security Level (set to Medium). On the Trusted Publishers tab check Trust access to Visual Basic Project.
  2. Click OK.
  1. Open any Excel Workbook. Click on the top left MS Office icon and then click on Excel Options at the bottom. Then, from the side bar, Trust Center>Trust Center Settings then Macro Setting and check Trust access to Visual Basic Project. Click OK
  2. Click OK

 

 

Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft

SPECIALS!
Convert Excel Spreadsheets To Webpages | Trading In Excel | Construction Estimators | Finance Templates & Add-ins Bundle | Code-VBA | Smart-VBA | Print-VBA | Excel Data Manipulation & Analysis | Convert MS Office Applications To...... | Analyzer Excel | Downloader Excel | MSSQL Migration Toolkit | Monte Carlo Add-in | Excel Costing Templates