Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com
Learn how to create Excel dashboards.

Analyzer Excel Tutorial Page 2 of 2. Backtest Strategy

Try out: Analyzer XL | Downloader XL | Smart VBA | Trader XL Pro (best value) | ConsoXL | MergeXL | O2OLAP for Excel | MORE>>

Analyzer Excel Package Start

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

DOWNLOAD DEMO | 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

Developers Site

Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $64.00. ALL purchases totaling over $150.00 gets you BOTH!
Purchase(s) MUST be made via this site
. Send payment proof to special@ozgrid.com

BEFORE INSTALLATION FOR 97-2007
Excel 97-2003 Excel 2007
  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


Instant Download and Money Back Guarantee on Most Software

Try out: Analyzer XL | Downloader XL | Smart VBA | Trader XL Pro (best value) | ConsoXL | MergeXL | O2OLAP for Excel | MORE>>

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

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

GIVE YOURSELF OR YOUR COMPANY 24/7 MICROSOFT EXCEL SUPPORT & QUESTIONS