Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Tue, 30 Apr 2024 02:14:30 +0000
[Programming Help] - Spreadsheet programming question
View Count: 498
| [2020-03-24 20:13:48] |
| User183724 - Posts: 183 |
|
Hows the best way to determine the beginning / ending of a bar in a spreadsheet formula? thanks tim
|
| [2020-03-24 20:35:58] |
| Sawtooth - Posts: 3985 |
|
Hows the best way to determine the beginning / ending of a bar in a spreadsheet formula?
For which bar type?
|
| [2020-03-24 20:38:39] |
| User183724 - Posts: 183 |
|
volume
|
| [2020-03-24 21:19:29] |
| Sawtooth - Posts: 3985 |
|
The beginning of a volume bar is when the previous bar reaches its volume fill, and the end of a volume bar is when the current bar reaches its volume fill. It's not possible to timestamp the end of a volume bar because it is unknown. The beginning Date Time of a bar is in column A. The Bar End Time study outputs the Time of the end of previous bars, which is most cases is the same as the beginning of the subsequent bar. The current bar end time is unknown until it happens, but its latest time is output in row 3, and it matches the time of cell J41. All this to ask: what are you trying to do? Date Time Of Last Edit: 2020-03-24 22:05:34
|
| [2020-03-24 21:52:36] |
| User183724 - Posts: 183 |
|
Just trying to determine the beginning and ending of the bar. thank you
|
To post a message in this thread, you need to log in with your Sierra Chart account: