Login Page - Create Account

Support Board


Date/Time: Tue, 07 May 2024 13:39:16 +0000



[User Discussion] - Spreadsheet trading--cant get it to start

View Count: 813

[2016-11-19 20:17:44]
User170575 - Posts: 221
Hi---I am using the spreadsheet system for trading study---the "clear trade simutlation orders and data" is working---via the trade service log---and then when I go to "autotrade system bar based backtest" nothing happens---if i click it again the message log indicates I cannot start another copy.

Checklist:

autotrading is enabled
trade simuation mode is checked/on
show order fills is checked

My buy/sell signal is simply " =AND($J$5=0,AQ3>0)"


Your thoughts appreciated and have a nice weekend.

Cj
[2016-11-19 20:30:34]
Sierra Chart Engineering - Posts: 104368
Refer to:
http://www.sierrachart.com/index.php?page=doc/SpreadsheetTradingTestProcedure.php
http://www.sierrachart.com/index.php?page=doc/SystemsAlerts.php#IgnoredSignals
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing
[2016-11-22 20:06:09]
User170575 - Posts: 221
Hi,

Got it to work and am able to run the "AutoTrade System Bar Backtest." I have a very basic formula to
start and the green arrows show on the chart before the backtest just where they should be. When I run a backtest the indicators on the chart change dramatically as well as the entry points. I am not using the attached orders and the sell signal is just based on the opposite of the buy order.

Appreciate your help and have a nice Holiday!

CJ
http://www.sierrachart.com/image.php?Image=1479845102368.png
http://www.sierrachart.com/image.php?Image=1479845059133.png
[2016-11-23 04:30:59]
Sierra Chart Engineering - Posts: 104368
This would not be surprising. Running a back test is going to simulate real-time updating of the chart and a trading system is going to function differently compared with the buy/sell arrows which are generated based on current formula results and completed bars. The back test results are what you should actually be relying on.

You might also want to use an Intraday chart instead of a Historical Daily bar chart.

We cannot provide more of an explanation than that for the reasons explained here:
Automated Trading Management: Troubleshooting Automated Trading System Behavior

Also refer to:
http://www.sierrachart.com/index.php?page=doc/SystemsAlerts.php#DisappearingArrows
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing
Date Time Of Last Edit: 2016-11-23 04:31:27

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account