Login Page - Create Account

Support Board


Date/Time: Thu, 23 Jan 2025 05:16:13 +0000



Using Spreasheets to draw extended rectangles

View Count: 1590

[2018-11-14 11:55:07]
phlapjack - Posts: 7
Support, I have looked through posts that reference the Spreadsheet study and found some older information, but without creating ACSIL custom studies is there a easy way to create a spreadsheet with multiple high and low levels that will populate a chart with an extended rectangle zones, IE 2700.00 - 2698.50
[2018-11-14 14:14:05]
Sawtooth - Posts: 4162
Here is a link to an old support board thread with examples:
https://www.sierrachart.com/supportboard/showthread.php?t=40825&highlight=rectangle

You'll need to let the program auto-convert the spreadsheet to the new version.

Note: there are significant limitations when using a spreadsheet study to do this.
[2018-11-14 20:37:17]
Sierra Chart Engineering - Posts: 104368
You can certainly do this by using two different formula columns for the high and low range and then use the Top and Bottom fill draw styles:
Chart Studies: Subgraphs Tab >> Draw Style

Or you can use ACSIL for this:
Table of Contents | (Advanced Custom Study/System Interface and Language (ACSIL))
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