Support Board
Date/Time: Mon, 24 Feb 2025 16:27:50 +0000
Quote Board or Spreadsheet?
View Count: 910
| [2021-03-10 00:43:28] |
| User486817 - Posts: 83 |
|
hello, i have a chartbook with about 100 symbols, all on their own individual chart. i have two studies on each chart. i need to create a tool which shows the two indicator values and the distance (in ticks) price is from the two indicators. is a quote board or a spreadsheet better suited for this task? how can i get started creating this? i'm basically trying to filter a large set of symbols against two studies via text, instead of cycling through an endless stream of charts. can you please offer your suggestion on how to get started? kindest, Date Time Of Last Edit: 2021-03-10 00:44:54
|
| [2021-03-10 14:16:02] |
| John - SC Support - Posts: 38122 |
|
To start with, use the Study Summary Window to be able to see the study data for all the charts. Refer to the following: Study Summary Window In order to see the Distance in Ticks of Price from Indicators, you would just need to use the Spreadsheet Formula to create that data, where the formula would look like "=C - ID1.SG1", where the ID and SG numbers are the ID and Subgraph of the particular indicators that you want the data for. Refer to the following for the Spreadsheet Formula Study: Spreadsheet Formula For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2021-03-14 11:22:02] |
| User486817 - Posts: 83 |
|
hello, i have everything setup and it is working beautifully. i have one small question, is it possible to set the data refresh rate to a custom interval (ex. 10 seconds) for only the spreadsheet, not the main price data on my charts? the reason i'm asking is because it is currently difficult to click on an item in the list because the data refreshes instantly and is constantly shifting. best regards, |
To post a message in this thread, you need to log in with your Sierra Chart account: