Support Board
Date/Time: Fri, 27 Dec 2024 09:11:03 +0000
No backtesting results
View Count: 2106
| [2015-11-08 11:05:34] |
| 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] |
| 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] |
| |
|
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] |
| 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] |
| |
|
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] |
| 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] |
| 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] |
| |
|
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] |
| 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] |
| |
|
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] |
| Sawtooth - Posts: 4143 |
|
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 - 413 views Swing HL extended.scss - Attached On 2015-11-10 20:55:05 UTC - Size: 104.77 KB - 359 views |
| [2015-11-10 21:35:41] |
| 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] |
| Sawtooth - Posts: 4143 |
|
Here's another method: http://www.sawtoothtrade.com/free-stuff-5.html |
| [2015-11-10 23:18:54] |
| User59228 - Posts: 47 |
|
Thank you tomgilb, a very good solution.
|
| [2015-11-12 13:57:24] |
| 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] |
| Sawtooth - Posts: 4143 |
|
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] |
| 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] |
| Sawtooth - Posts: 4143 |
|
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] |
| User59228 - Posts: 47 |
|
ok, thank you.
|
To post a message in this thread, you need to log in with your Sierra Chart account: