Spreadsheet System for Trading Test Procedure

• Testing

Testing

1. Download these files:
   • SpreadsheetSystemForTradingTesting.cht
   • SpreadsheetTradeTest.scss
   Save them to your Sierra Chart Data Files Folder. You can find the location of this folder through Global Settings >> General Settings >> Data Files Folder.
2. Select Trade >> Clear Trade Simulation Orders and Data.
3. Enable Trade >> Auto Trading Enabled.
4. Enable Trade >> Trade Simulation Mode On.
5. Select Global Settings >> Data/Trade Service Settings.
6. Set the Service to SC Data - All Services. Press OK.
7. Select File >> Open Chartbook. And open the file SpreadsheetSystemForTradingTesting.cht.
8. Go to the EURUSD chart and scroll the chart back in time.
9. Enable Trade >> Attach Trade Window to Chart.
10. Select Chart >> Replay Chart>> Replay Chart (Control Panel). If you do not see the Replay Control Panel, then select Window >> Reset Windows and open it again.
11. On the Replay Control Panel, set the Speed to 60.
12. Make sure the option Use Start Date-Time is unchecked.
13. Press the Play button on the Replay window.
14. Select CW >> SpreadsheetTradeTest to go to the Spreadsheet.
15. Make sure Sheet1 is selected using the list box at the top left of the Spreadsheet window.
16. Repeat the following steps for each test:
    1. In cell J26 enter the value 10000. You need to left click on the cell 2 times to open the edit box.
    2. Left click 2 times in cell K3. Enter a 1 and press OK.
    3. An order will have been submitted and the Trade Position will be established. You can confirm this by looking at cell J5 for the current Trade Position Quantity. It will contain a nonzero value.
    4. If an order has not been submitted, then check the Trade >> Trade Service Log for the reason. If the order has been submitted, skip this step.
       
       Also make sure you are entering the 1 on the correct Sheet in the Spreadsheet and in the correct cell. Refer to the Formula Source Sheet Number Input with the Spreadsheet System for Trading study. It is this particular Sheet where you need to enter these values.
    5. Left click 2 times in cell L3. Enter a 1 and press OK.
    6. An order will have been submitted and the Trade Position will become flat. You can confirm this by looking at cell J5. It will be 0.
    7. Left click 2 times in cell M3. Enter a 1 and press OK.
    8. An order will have been submitted and the Trade Position will be established. You can confirm this by looking at cell J5. It will contain a nonzero value.
    9. Left click 2 times in cell N3. Enter a 1 and press OK.
    10. An order will have been submitted and the Trade Position will become flat. You can confirm this by looking at cell J5. It will be 0.
    11. Clear the 1 values from cells K3 through N3 by selecting them and pressing the Delete key on the keyboard.
17. If there is any problem with submitting orders, the reason will be given in Trade >> Trade Service Log. For additional information about this, refer to Ignored Signals With Spreadsheet Systems or Alerts.
18. The generated order signals will also be listed in Window >> Show/Hide Alerts Manager >> Alerts Log.