Excel is what we do best
ALL YOUR EXCEL NEEDS
FREE Excel STUFF
Excel Newsletter
Advanced Search Search Excel Content
PRODUCTS
Development
Contact Us

Analyzer Excel Tutorial Page 2 of 2. Backtest Strategy

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

Complete Excel Excel Training Course. Instant Buy/Download, 30 Day Money Back Guarantee

BUY > Analyzer Excel Package Start

of DownloaderXL and AnalyzerXl which is 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

of DownloaderXL and AnalyzerXl which is part of the Trader Excel Package Special.

Analyzer Excel $99.95 Payment Problems/Options 30 Day Money Back Guarantee Save by buying as part of: Trader Excel Package

Special ! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to special@ozgrid.com 31 days after purchase date.

See Also Neuro Excel Package and Trading Decision Software and Neuro Fusion For More Great Saving! Or, see all Neural Network Trading Software



Instant Download and Money Back Guarantee on Most Software

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

Add to Google Search Tips FREE Excel Help

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

Watch the latest videos on YouTube.com