Login Page - Create Account

Support Board


Date/Time: Thu, 18 Apr 2024 06:01:01 +0000



Technical indicators strategy

View Count: 3365

[2013-03-20 17:15:19]
User81908 - Posts: 7
Hello,
I've just downoladed SC and I was wondering does this software has a feature for developing trading strategies based on technical indicators? For example, I want to go long in certain instrument when MACD lines cross above each other (or something similar).
I couldn't find this on your website, so could you please direct me where it is in the table of contents?

Tnx,
Regards.
[2013-03-20 18:34:30]
Sierra Chart Engineering - Posts: 104368
Yes you can do this.

Did you just want a visual indication of where this condition is true? Or did you also want to be able to do back testing and actually submit orders?

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
[2013-03-20 20:02:40]
User81908 - Posts: 7
Tnx
Well I would like both. Sometimes it is more appropriate just to give signal, while sometimes I want automatic execution.


[2013-03-20 21:09:44]
Sierra Chart Engineering - Posts: 104368
In this case the easiest way to do this, is to use the Spreadsheet System for Trading study:

http://www.sierrachart.com/index.php?l=doc/doc_SystemsAlerts.php#GeneralInformation
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
[2013-03-21 18:51:05]
User81908 - Posts: 7
Tnx.
I am trading with interactive brokers and they provided me with the paper account, so can I use SC for trading on this type of account so I can check my strategies safely?
[2013-03-21 20:02:39]
Sierra Chart Engineering - Posts: 104368
It does not matter what type of account you have with a trading service. By default the Spreadsheet System for Trading system uses Sierra Chart's own Trade Simulation Mode for simulation. So this is what you will want to use.
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
[2013-03-25 19:12:27]
User81908 - Posts: 7
Hello, once again I have a question:
I can't log in properly to my IB account. In message log in the last row it is always written:

Message from IB: Error validating request:-'zb' : cause - The account code is required for this operation.. IB Error Code: 321. Request ID: 2147483647. | 2013-03-25 20:07:15

Could you help with this please?
[2013-03-25 19:13:00]
User81908 - Posts: 7
Software version: 955 | 2013-03-25 18:54:49
Current Service Package: 5 | 2013-03-25 18:54:49
Usage end date: 2013-04-04 | 2013-03-25 18:54:49
Sierra Chart Historical Data Service is included. | 2013-03-25 18:54:49
Active service: Interactive Brokers | 2013-03-25 18:54:49
Time Zone: +00:00:00 (UTC+00) | 2013-03-25 18:54:49
2013-03-25 19:54:49 Local computer clock time | 2013-03-25 18:54:49
2013-03-25 18:54:49 GMT time | 2013-03-25 18:54:49
2013-03-25 18:54:49 Time zone adjusted time | 2013-03-25 18:54:49
Time difference to server time: 70 seconds. | 2013-03-25 18:54:49
WARNING: Your computer's clock is off by 70 seconds. For help with this Date-Time issue, press the Send for Analysis button. | 2013-03-25 18:54:49
Program path: C:\SierraChart\ | 2013-03-25 18:54:49
Data Files path: C:\SierraChart\Data\ | 2013-03-25 18:54:49
OS Version Number: 5.1 | 2013-03-25 18:54:49


Connecting to data and trade server: localhost port 7496... | 2013-03-25 18:54:55
Using client version 46. Waiting for acceptance... | 2013-03-25 18:54:55
Error connecting to Data or Trading service. For help with this issue, press the Send For Analysis button on this window. | 2013-03-25 18:54:56
To prevent further connection attempts, select File >> Disconnect. | 2013-03-25 18:54:56
Disconnected from IB. | 2013-03-25 18:54:56
Will reconnect to the server in 5 seconds. Select File >> Disconnect to prevent further connection attempts. | 2013-03-25 18:54:56
Starting TWS auto-login thread. | 2013-03-25 18:54:59
TWS auto-login thread ending. | 2013-03-25 18:55:01

Connecting to data and trade server: localhost port 7496... | 2013-03-25 18:55:01
Using client version 46. Waiting for acceptance... | 2013-03-25 18:55:01
Error connecting to Data or Trading service. For help with this issue, press the Send For Analysis button on this window. | 2013-03-25 18:55:02
To prevent further connection attempts, select File >> Disconnect. | 2013-03-25 18:55:02
Disconnected from IB. | 2013-03-25 18:55:02
Will reconnect to the server in 5 seconds. Select File >> Disconnect to prevent further connection attempts. | 2013-03-25 18:55:02
Starting TWS auto-login thread. | 2013-03-25 18:55:03
TWS auto-login thread ending. | 2013-03-25 18:55:03
Starting TWS auto-login thread. | 2013-03-25 18:55:07
TWS auto-login thread ending. | 2013-03-25 18:55:07

Connecting to data and trade server: localhost port 7496... | 2013-03-25 18:55:07
Using client version 46. Waiting for acceptance... | 2013-03-25 18:55:07
Error connecting to Data or Trading service. For help with this issue, press the Send For Analysis button on this window. | 2013-03-25 18:55:08
To prevent further connection attempts, select File >> Disconnect. | 2013-03-25 18:55:08
Disconnected from IB. | 2013-03-25 18:55:08
Will reconnect to the server in 5 seconds. Select File >> Disconnect to prevent further connection attempts. | 2013-03-25 18:55:08
File >> Disconnect selected. | 2013-03-25 18:55:10
Reconnect canceled. | 2013-03-25 18:55:10
Disconnected from IB. | 2013-03-25 18:55:10

Connecting to data and trade server: localhost port 7496... | 2013-03-25 18:55:14
Using client version 46. Waiting for acceptance... | 2013-03-25 18:55:14
Error connecting to Data or Trading service. For help with this issue, press the Send For Analysis button on this window. | 2013-03-25 18:55:15
To prevent further connection attempts, select File >> Disconnect. | 2013-03-25 18:55:15
Disconnected from IB. | 2013-03-25 18:55:15
Will reconnect to the server in 5 seconds. Select File >> Disconnect to prevent further connection attempts. | 2013-03-25 18:55:15
Starting TWS auto-login thread. | 2013-03-25 18:55:18
TWS auto-login thread ending. | 2013-03-25 18:55:18

Connecting to data and trade server: localhost port 7496... | 2013-03-25 18:55:20
Using client version 46. Waiting for acceptance... | 2013-03-25 18:55:20
Error connecting to Data or Trading service. For help with this issue, press the Send For Analysis button on this window. | 2013-03-25 18:55:21
To prevent further connection attempts, select File >> Disconnect. | 2013-03-25 18:55:21
Disconnected from IB. | 2013-03-25 18:55:21
Will reconnect to the server in 5 seconds. Select File >> Disconnect to prevent further connection attempts. | 2013-03-25 18:55:21
Starting TWS auto-login thread. | 2013-03-25 18:55:22
TWS auto-login thread ending. | 2013-03-25 18:55:22
Starting TWS auto-login thread. | 2013-03-25 18:55:26
TWS auto-login thread ending. | 2013-03-25 18:55:26

Connecting to data and trade server: localhost port 7496... | 2013-03-25 18:55:26
Using client version 46. Waiting for acceptance... | 2013-03-25 18:55:26
Error connecting to Data or Trading service. For help with this issue, press the Send For Analysis button on this window. | 2013-03-25 18:55:29
To prevent further connection attempts, select File >> Disconnect. | 2013-03-25 18:55:29
Disconnected from IB. | 2013-03-25 18:55:29
Will reconnect to the server in 5 seconds. Select File >> Disconnect to prevent further connection attempts. | 2013-03-25 18:55:29
Active service: Global Data Feeds | 2013-03-25 18:55:29
Starting TWS auto-login thread. | 2013-03-25 18:55:30
Requesting symbol settings for gdf. Overwrite = on. | 2013-03-25 18:55:30
Request for symbol settings completed. | 2013-03-25 18:55:30
Processed received symbol settings | 2013-03-25 18:55:30
TWS auto-login thread ending. | 2013-03-25 18:55:30
Disconnected from IB. | 2013-03-25 18:55:34


Active service: Global Data Feeds | 2013-03-25 18:56:03
Active service: Interactive Brokers | 2013-03-25 20:06:53
Requesting symbol settings for ib. Overwrite = on. | 2013-03-25 20:06:53
Request for symbol settings completed. | 2013-03-25 20:06:54
Processed received symbol settings | 2013-03-25 20:06:54

Connecting to data and trade server: localhost port 7496... | 2013-03-25 20:07:08
Using client version 46. Waiting for acceptance... | 2013-03-25 20:07:08
TWS server version: 66 | 2013-03-25 20:07:09
Connected to IB data and trade server. | 2013-03-25 20:07:09
Next valid order ID: 1 | 2013-03-25 20:07:09
Message from IB: Market data farm connection is OK:cusfuture. IB Error Code: 2104. Request ID: -1. | 2013-03-25 20:07:09
Message from IB: Market data farm connection is OK:usfuture. IB Error Code: 2104. Request ID: -1. | 2013-03-25 20:07:09
Message from IB: Market data farm connection is OK:usfuture.us. IB Error Code: 2104. Request ID: -1. | 2013-03-25 20:07:09
Message from IB: Market data farm connection is OK:cashfarm. IB Error Code: 2104. Request ID: -1. | 2013-03-25 20:07:10
Message from IB: Market data farm connection is OK:hkfarm. IB Error Code: 2104. Request ID: -1. | 2013-03-25 20:07:10
Message from IB: Market data farm connection is OK:usopt. IB Error Code: 2104. Request ID: -1. | 2013-03-25 20:07:10
Message from IB: Market data farm connection is OK:usfarm.us. IB Error Code: 2104. Request ID: -1. | 2013-03-25 20:07:10
Message from IB: Market data farm connection is OK:usfarm. IB Error Code: 2104. Request ID: -1. | 2013-03-25 20:07:10
Message from IB: HMDS data farm connection is OK:cashhmds. IB Error Code: 2106. Request ID: -1. | 2013-03-25 20:07:10
Message from IB: HMDS data farm connection is OK:ushmds. IB Error Code: 2106. Request ID: -1. | 2013-03-25 20:07:10
Next valid order ID: 1 | 2013-03-25 20:07:10
IB Trading service: Requesting Trade Positions for account: | 2013-03-25 20:07:14
Message from IB: Error validating request:-'zb' : cause - The account code is required for this operation.. IB Error Code: 321. Request ID: 2147483647. | 2013-03-25 20:07:15

[2013-03-25 19:24:44]
Sierra Chart Engineering - Posts: 104368
1. Correct your computer's clock. This is from the Message Log:
WARNING: Your computer's clock is off by 70 seconds. For help with this Date-Time issue, press the Send for Analysis button. | 2013-03-25 18:54:49

2. Enter your IB account number in Global Settings >> Data/Trade Service Settings >> Positions Account.
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
[2013-03-26 16:12:33]
User81908 - Posts: 7
Ok, tnx, I fixed it, but still I have a problem:
I am trying to create a strategy for automated trading in Spreadsheet System for automated trading (one described in user manual you provided me with - Simple Moving Average), but it keep saying that I am using invalid formula, although i copied same formula from user manual. Some assistance please?

attachmentInvalid formula.bmp - Attached On 2013-03-26 16:11:19 UTC - Size: 3.71 MB - 795 views
[2013-03-26 17:20:06]
FGBL07 - Posts: 19
Please use the .png format to upload screen shots. It creates much smaller files than .bmp.

Your decimal separator is the "," so instead of using

=CROSSFROMBELOW(E3:E4,AA3:AA4)
you have to use

=CROSSFROMBELOW(E3:E4;AA3:AA4)
.
Date Time Of Last Edit: 2013-03-26 17:20:37
[2013-04-01 19:34:56]
User81908 - Posts: 7
Hello again,
now I have a problem about backtesting strategies. For example, I create strategy based on the MACD crossover on 5 min chart and backtest it. However, when I change to some other time frame (I change everything, even create totally new strategy)I always get same results in trading statistics (trade activity log). Could you explain me little more about this?
Regards.
[2013-04-01 21:28:44]
Sierra Chart Engineering - Posts: 104368
Check the settings at the top of the Trade Activity Log to make certain they are correct.

Refer to:
http://www.sierrachart.com/index.php?l=doc/doc_Backtesting.php#ViewingBackTestResults
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

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

Login

Login Page - Create Account