Support Board
Date/Time: Mon, 15 Dec 2025 18:09:48 +0000
Post From: retrieve bar period value in tick chart and spreadsheet formula
| [2025-03-25 01:04:52] |
| Sawtooth - Posts: 4299 |
|
is there a way to add this value dynamically
It can't be done with the Spreadsheet Formula study.(Despite its name, it's not a spreadsheet study.) Use the Spreadsheet Study study: Cell J39 returns the range of range bars, in ticks. To get it to a subgraph where it can be used in calculations, or to display it, use a formula like this in a Formula Column, e.g., K3 (Column K is SG1): =$J$39 If you want to convert it to points: =$J$39*$J$21 Date Time Of Last Edit: 2025-03-25 01:06:56
|