 |
|
|
|
|
|
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:
Of Analyzer Excel Package Which Includes
DownloaderXL
$99.95 
Secure Payment Options Save by buying as part of:
Trader Excel PackageSpecial! 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 |
|
|
Instant Download and Money Back Guarantee on Most Software
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