Support Board
Date/Time: Sun, 24 Nov 2024 07:46:21 +0000
Display multiple selected study values at specific points in time
View Count: 201
| [2024-06-20 18:17:00] |
| CoCoHimself - Posts: 9 |
|
I am trying to find a way to display the RSI at 2 selected points on my chart. And if possible create and alert to go off when it goes above/below. I'm currently just using the tool values box and hovering over to get that info but its not static or displayed anywhere. Any other possible options? In the attached image I used the 2 vertical green lines as a example of the points id like to know the RSI. https://www.sierrachart.com/image.php?Image=1718907302832.png |
| [2024-06-20 18:28:41] |
| CoCoHimself - Posts: 9 |
|
Sorry, to clear things up because I realize point 2 is unknown till it is established. So the request is to identify the RSI at a specific point identified whichever way and possibly an alert for when the current RSI goes above or below.
|
| [2024-06-20 19:57:02] |
| John - SC Support - Posts: 36238 |
|
It would be easiest to do this with a custom study, this way you could capture the pointer at a specific location to give you the value you want. Refer to the following: Advanced Custom Study Interaction With Menus, Control Bar Buttons, Pointer Events List of Third Party Sierra Chart Study and System Programmers But in terms of a way to do this without programming, one way would be to use the "Date-Time Line" to establish the point you want, and then use the Spreadsheet Study to get the value from that point to the current bar so you can easily reference it for an alert. Here are the specifics: - Add the RSI study to the chart. - Add the "Date-Time Line" study and place the "Date-Time Line" where you want. - Add the "Spreadsheet Study" to the chart and enter the following: -- Cell K3: =IF(ID2.SG1@3 <> 0, ID1.SG1@3, 0) -- Cell L3: =MOSTRECENTNONZEROVALUE($K$3:$K$2000) Where ID2 is the ID of the "Date-Time Line" study. ID1 is the ID of the RSI study. You may need to change the range of the values in the MOSTRECENTNONZEROVALUE() function depending on how far back you are locating the point. You can then use the subgraph for the L column to create your alert. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-06-20 20:18:09] |
| CoCoHimself - Posts: 9 |
|
Thanks John! I was close messing with the spreedsheet but was missing a few key points you provided. That will work in the meantime while I decode the matrix and work on a custom study.
Date Time Of Last Edit: 2024-06-20 20:18:38
|
To post a message in this thread, you need to log in with your Sierra Chart account: