Spreadsheet System for Trading Test Procedure

Testing

  1. Download these files: 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 Forex Data (FXCM). 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.
  11. Set the Speed to 60.
  12. Press the Play button on the Replay window.
  13. Select CW >> SpreadsheetTradeTest to go to the Spreadsheet.
  14. Make sure Sheet1 is selected using the list box at the top left of the Spreadsheet window.
  15. 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. It will contain a nonzero value.
    4. Left click 2 times in cell L3. Enter a 1 and press OK.
    5. 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.
    6. Left click 2 times in cell M3. Enter a 1 and press OK.
    7. 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.
    8. Left click 2 times in cell N3. Enter a 1 and press OK.
    9. 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.
    10. Clear the 1 values from cells K3 through N3 by selecting them and pressing the Delete key on the keyboard.
  16. 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.
  17. The generated order signals will also be listed in Window >> Show/Hide Alerts Manager >> Alerts Log.

*Last modified Friday, 12th August, 2016.