Support Board
Date/Time: Tue, 22 Apr 2025 18:08:45 +0000
Horizonal Range Used for Automated Trading
View Count: 210
| [2024-12-19 00:43:53] |
| Le Dharma - Posts: 82 |
|
In Sierra, there is a tool called the, 'extending rectangle tool'. I was wondering if this tool could be used together with an automated trading spreadsheet. I know yall have a horizontal lines tool, which can accomplish this. Unfortunately, Setting the price levels by typing in numbers, is extremely difficult. I feel like, drawing an extending rectangle by eye, would be so much faster and easier. Have yall ever added anything like this before? |
| [2024-12-19 15:35:06] |
| John - SC Support - Posts: 39416 |
|
You can reference drawing tool anchors and (for some) the value at a certain point through Alerts. Refer to the following: Study/Chart Alerts And Scanning: Referencing Chart Drawings As such, you can use the "Spreadsheet Formula" study to get that value into a subgraph to then use it in the Spreadsheet Study. To do this, you would enter the following for the formula in the Spreadsheet Formula: =UDID[1].A1 Where 1 is the actual ID of the drawing and A1 is the first anchor. The Spreadsheet Formula will then be in the Spreadsheet Study along with other studies. You can reference the cells in the study, but it is best to reference the subgraph using the following method: Working with Spreadsheets: References to Study Subgraph Columns when using the Spreadsheet Study For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-01-01 02:52:37] |
| Le Dharma - Posts: 82 |
|
When did yall add the drawing tool functionality for the spreadsheet formula study? This tool is pretty awesome. Thanks John |
| [2025-01-02 16:22:35] |
| John - SC Support - Posts: 39416 |
|
The ability to reference drawings through an Alert has been in the system for several years, perhaps has long as 5 years now.
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: