Home >> Support Board

Support Board

Date/Time: Fri, 03 May 2024 17:06:21 +0000

How to Post a Message for Support

No backtesting results

View Count: 1997

[2015-11-08 11:05:34] #1 [Go To First Post]
User59228 - Posts: 47
Hi, i tested an auto-trading System with both backtesting methods. With both methods the arrows were drawn, but there are nothing to see in the trade activity log. A Symbol with SIM in Front is also not visible. I checked all Settings and don´t know where is the Problem.

[2015-11-08 20:15:12] #2 [Go To First Post]
User59228 - Posts: 47
I think I have found a solution, I open a new thread when there are further questions, thank you.

[2015-11-08 20:18:16] #3 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
The question we have is are you using ACSIL or the Spreadsheet System for Trading study for auto trading? We need to know so we can give you the relevant documentation. 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

[2015-11-09 18:07:25] #4 [Go To First Post]
User59228 - Posts: 47
I use the Spreadsheet System for Trading. Can you please explain me how I get Prices in the row 3 when I use the swing high and low as a Trigger. When the last swing high or low is a few candles away then there not Prices in the newest row. For example, the Daily OHLC wrote the same Price in each row and i can use it as a Trigger. Date Time Of Last Edit: 2015-11-09 18:09:16

[2015-11-09 18:22:06] #5 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
You could try to do this by using the Study/Price Overlay study and overlay the study again on the same chart: https://www.sierrachart.com/index.php?page=doc/doc_TechnicalStudiesReference.html#s118 Set the Fill Blanks with Last Value input to Yes. 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

[2015-11-09 19:03:56] #6 [Go To First Post]
User59228 - Posts: 47
ok, i try this and set the Fill Blanks with Last Value input to Yes, but the fields stay empty.

[2015-11-09 22:50:18] #7 [Go To First Post]
User59228 - Posts: 47
Is there maybe another possibility to use the data from swing high and low Analysis in Spreadsheet System for Trading. Can I use for example a formula like =ID9.SG1[Last] for the last Swing High Price ?

[2015-11-10 03:38:38] #8 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
Really the formula used in the Spreadsheet study, needs to reference the study cells that have values. For the method to reference studies, refer to: https://www.sierrachart.com/index.php?page=doc/doc_Spreadsheets.html#ReferencesStudySubgraphColumnsSpreadsheetStudy 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

[2015-11-10 07:19:58] #9 [Go To First Post]
User59228 - Posts: 47
ok, but what formula is to used by referencing the cells with values. How can i reference, for example, the last value in a column ? Thank you.

[2015-11-10 17:39:23] #10 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
We would have to think about this. However, review the available Spreadsheet functions here: https://www.sierrachart.com/index.php?page=doc/doc_SpreadsheetFunctions.html Maybe we could create a function for this. Something like : MOSTRECENTNONZEROVALUE(Range) Also, you may want to use the Study Settings >> Subgraphs >> [select Subgraph] >> Displacement setting to cause the study values to always be at the last bar when the type of study being referenced does not have values which always end at the last bar already: https://www.sierrachart.com/index.php?page=doc/doc_ChartStudies.html#Displacement Although this assumes that there is always a consistent amount of zero values from a study at the end of the chart. 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: 2015-11-10 17:48:51

[2015-11-10 20:55:40] #11 [Go To First Post]
Sawtooth - Posts: 3992
I use the Spreadsheet System for Trading. Can you please explain me how I get Prices in the row 3 when I use the swing high and low as a Trigger. When the last swing high or low is a few candles away then there not Prices in the newest row. For example, the Daily OHLC wrote the same Price in each row and i can use it as a Trigger. This will bring the most recent non-zero to row 3 of column K: =IF(AA3>0,AA3,K4) where AA is the Swing High and Low study. See attached for an example


Swing HL extended.cht - Attached On 2015-11-10 20:54:50 UTC - Size: 38.33 KB - 308 views Swing HL extended.scss - Attached On 2015-11-10 20:55:05 UTC - Size: 104.77 KB - 308 views

[2015-11-10 21:35:41] #12 [Go To First Post]
User59228 - Posts: 47
"Although this assumes that there is always a consistent amount of zero values from a study at the end of the chart." That is the Problem. It would be very nice when you can create a function or when you have another idea. Thank you.

[2015-11-10 23:08:39] #13 [Go To First Post]
Sawtooth - Posts: 3992
Here's another method: http://www.sawtoothtrade.com/free-stuff-5.html

[2015-11-10 23:18:54] #14 [Go To First Post]
User59228 - Posts: 47
Thank you tomgilb, a very good solution.

[2015-11-12 13:57:24] #15 [Go To First Post]
User59228 - Posts: 47
Hi tomgilb, thank you for Zigzag previous legs Sheet, but where are the buy entry and buy exit cells ? the k and l columns are ZZ leg and the EMA.

[2015-11-12 14:23:46] #16 [Go To First Post]
Sawtooth - Posts: 3992
This example used the Spreadsheet Study study, not the Spreadsheet System for Trading study. You'll need to use two other Formula Columns, e.g. O,P.

[2015-11-12 15:01:26] #17 [Go To First Post]
User59228 - Posts: 47
ok, that means I can use the Spreadsheet Study also for Trading when I add two other formula columns or probably it is better to use Spreadsheet Study for Trading and add this columns ? but how to add them, sorry i´am not so good with this formulas. Date Time Of Last Edit: 2015-11-12 15:09:13

[2015-11-12 15:17:34] #18 [Go To First Post]
Sawtooth - Posts: 3992
In general: The Spreadsheet Study study is intended for creation of custom studies. The Spreadsheet System/Alert study is intended for creation of custom alerts. The Spreadsheet System for Trading study is intended for creation of autotrading systems. Only the latter is capable of placing orders, and it uses columns K,L,M,N for this. See this for some basic tips: http://www.sawtoothtrade.com/tip-1.html

[2015-11-12 15:30:43] #19 [Go To First Post]
User59228 - Posts: 47
ok, thank you.

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