Login Page - Create Account

Support Board


Date/Time: Thu, 26 Mar 2026 06:34:18 +0000



Post From: Time Range Formula

[2018-05-05 15:12:40]
Sawtooth - Posts: 4321
The GETTIMEFROMDATETIMEVALUE function does not exist. Use the FRACTIME function instead.
https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#FRACTIME_Function
The formula is meant to go in J28.

Here are two more formula examples to disable autotrading using J28:
Spreadsheet Example Formulas and Usage: Disable Trading From Spreadsheet Study for Trading