Support Board
Date/Time: Tue, 26 Nov 2024 04:16:51 +0000
Ticks per minute
View Count: 214
| [2024-01-04 00:59:14] |
| countryboy92 - Posts: 91 |
|
In another post, it was recommended to use this formula to calculate the ticks per minute: I'm using a 20 tick chart. I tried the formula =(H-L)/20, but I am getting a #Name error. -------------------------------------------------------------------- There is not a direct indicator that does this. But you can calculate it out. You would need to start with a time-based chart that is set to the time for which you want to calculate the number of ticks and is set to a time that also matches the time you are looking for. Then just find the High minus the Low and divide by the Tick Size. The easiest way to do the calculation is to use the Spreadsheet Formula, as it can reference the Tick Size for the chart, so your formula would be: =(H - L) / TICKSIZE You can then use any number of studies to display the information in another chart. |
| [2024-01-04 15:44:14] |
| John - SC Support - Posts: 36286 |
|
As noted in the reference information you quoted - you can not get the ticks per minute from a 20 tick chart. You would need to have a 1 minute chart and then you could find the number of ticks per minute. The formula you are using will always return a value of 1. Next, since you are getting a #NAME error, we assume that you are using a Spreadsheet Study for this rather than the "Spreadsheet Formula". These use different syntaxes for how you enter information. On the Spreadsheet Study you would need to enter the formula as follows into a row 3 cell: =(ID0.SG2@3 - ID0.SG3@3) / $J$21 Where $J$21 is the cell that contains the Tick Size for the chart. But if you have the Input for "Use Columns I and J Values Version 2" set to "Yes", then the Tick Size is stored in cell $J$16. 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: