Support Board
Date/Time: Fri, 04 Apr 2025 21:26:37 +0000
Post From: Ticks per minute
| [2024-01-04 15:44:14] |
| John - SC Support - Posts: 39172 |
|
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 |