Login Page - Create Account

Support Board


Date/Time: Tue, 04 Mar 2025 09:28:44 +0000



Post From: Is there a way to access Number Bars Calc Values:SG30 (Bar Duration)

[2021-11-30 21:09:40]
Sawtooth - Posts: 4179
Try this in the Spreadsheet Formula study's Formula field:
=ID1.SG30*1440
where ID1 is the Numbers Bars Calculated Values study.
This will return the bar duration in minutes.

This will return the bar duration in seconds:
=ID1.SG30*86400

SG30 of that study outputs the bar duration in a decimal portion of one day.
There are 1440 minutes in one day.
There are 86400 seconds in one day.

Spreadsheet Example Formulas and Usage: Using Date Time
Date Time Of Last Edit: 2021-12-01 15:53:37