Support Board
Date/Time: Sat, 19 Apr 2025 09:51:15 +0000
Extend Horizontal lines from a Study to Multiple Days?
View Count: 118
| [2025-03-14 10:40:06] |
| User117222 - Posts: 15 |
|
Can someone please guide me on how I could extend a particular study (which draws Horizontal lines) to Multiple Days of the week, starting on one Wednesday (at a specific time) & extending to the Next Wednesday. Background to this question below: 1. I've created a custom study (using spreadsheet formulas), which creates multiple Horizontal lines, that are based on various Std Deviations of Wednesday's Initial Balance. 2. Now I'd like to extend these Horizontal lines from Wed 10:30am till Next Wed 9:30am, i.e. for the entire week 3. The lines created from the Initial Balances of other days of the week can be ignored. Would really appreciate any help, I'm unable to find a function within SC to do this. Thanks |
Attachment Deleted.  SC Wed Screenshot.png / V - Attached On 2025-03-14 10:37:58 UTC - Size: 117.16 KB - 27 views |
| [2025-03-14 14:00:30] |
| Sierra_Chart Engineering - Posts: 19276 |
|
Do they already extend to the end of the chart? Normally the result of the formula displays until the very last bar in 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, use the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2025-03-14 14:00:45
|
| [2025-03-17 05:34:21] |
| User117222 - Posts: 15 |
|
I've created these lines using the Horizontal Line at Time Function (which itself refers to a Spreadsheet formula that performs the calculation). Unfortunately, this is allowing me to extend the line for a maximum of 24 hours only: i.e. if the Line Start Time is 10:30am, I can extend it only till 10:29am the next day. What I'm looking for is the ability to start Drawing the line from a specific Day at a specific time (e.g. Tuesday 1030am), and extend THAT SAME LINE for 7 days, till Next Tuesday 9:30am. The calculations from all the other days can be ignored. Please help, thank you. |
| [2025-03-17 16:19:14] |
| John - SC Support - Posts: 39362 |
|
You would need to use the Spreadsheet Study to do this, not the Spreadsheet Formula. And you would need to make sure that you have the number of Rows set to go back as far as the line itself starts. In general, you would use an equation similar to the following: =AND(WEEKDAY(A3) >= 3, FRACTIME(A3) >= TIME(10, 30, 00)) You would then need to work out the special circumstances covering Sunday and Monday (since they have WEEKDAY values of 1 and 2) and the Tuesday morning. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-03-19 07:41:12] |
| User117222 - Posts: 15 |
|
Thank you, I appreciate this feedback. I haven't used a Spreadsheet Study before, so I'm not really able to follow the instructions you've given above. Will need to spend more time with this to evaluate how this would work. If there's anything further you/anyone else could add to this, that would really help. Else, will attempt this anyway after reading about how to use Spreadsheet Studies. Question: Do you know of a Sierra Expert who could help me set this up, for a fee perhaps? Date Time Of Last Edit: 2025-03-19 08:16:06
|
| [2025-03-19 13:55:40] |
| John - SC Support - Posts: 39362 |
|
Sawtooth Trade is an expert in Sierra Chart spreadsheets. You can find him here: https://www.sawtoothtrade.com/ But you could also get what you need through a custom study, in which case you could find a person at the following link: https://www.sierrachart.com/index.php?page=doc/SierraChartStudyAndSystemProgrammers.php For the most reliable, advanced, and zero cost futures order routing, use 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: