Login Page - Create Account

Support Board


Date/Time: Sun, 12 Jan 2025 04:29:17 +0000



Post From: Any help with spreadsheet logical functions?

[2017-01-26 18:07:08]
Sierra Chart Engineering - Posts: 104368
First, it is not necessary to use the IF function.

You can just use a formula like: = ID0.SG4@3 > ID3.SG1@3

Did you want to know the time this happens?:

What I want to define in another column is when the K column printed the first 1

Sounds like you want to use the GetCorrespondingMatch function:
http://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#GetCorrespondingMatch_Function
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing
Date Time Of Last Edit: 2017-01-26 18:07:41