Login Page - Create Account

Support Board


Date/Time: Sun, 05 May 2024 22:21:33 +0000



Post From: draw line from excel study

[2015-09-08 01:26:07]
Sierra Chart Engineering - Posts: 104368
Since we do not provide programming help, you can expect what might be considered "shallow thinking" from Sierra Chart support for programming questions. This is indirectly stated in our support policy:
https://www.sierrachart.com/index.php?l=doc/PostingInformation.php#GeneralInformation

putting a constant value in a formula cell would result in a line at moment T would result in a constant line stretching from T minus infinity to T plus infinity ?
A fixed value will draw a line from the last bar in the chart back by the Number of Rows Input setting for the Spreadsheet Study. However, refer to the documentation for this Input for further details about this.

If you want to limit it based on time, that requires a more advanced formula which would look at the time. The details of this are not within the scope of our support. Or you could simply reduce the Number of Rows Input:

https://www.sierrachart.com/index.php?page=doc/doc_SpreadsheetStudyInputs.html#NumberofRows

because of the factor called time what is more obvious/logical to assume is that putting a constant value in a cell would result in a point (in time)

Did you try this first? You will clearly see what it does.
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-09-08 01:30:06