Login Page - Create Account

Support Board


Date/Time: Fri, 14 Jun 2024 14:52:25 +0000



spreadsheet help needed...true/false to 1/0

View Count: 1976

[2013-07-01 17:07:48]
User22396 - Posts: 191
sorry but i am totally spacing on this and have been wasting to much time tryin to get this sorted...any help aprreciated...i guess summertime brain melt

i am tryin to count occurences using spreadsheet study and then run some real basic stats...like number of times somthing occurs in a day/30d period etc etc...using the basic true/false but am havin a hard to getting it to flip to 1/0 so i can sum etc...for example say a 5min bar closes on it high- how many times a day, avg times over 30days, percent times it occurs, any follow thru in points/in bars etc etc

i have seen it done in IRT tho not this example but similar jsut counting true/false... http://www.linnsoft.com/homework/ and wasnt sure how to most easily recreate in SC

anyone ever create a spreadsheet or work it this way for SC?

thanks
b
[2013-07-01 23:12:52]
Sierra Chart Engineering - Posts: 104368
What you want to do in this case is use the IF function and have it return 1 when the Condition expression in the function is TRUE and 0 if FALSE. Here is the documentation:
https://www.sierrachart.com/index.php?l=doc/doc_WorksheetFunctions.html
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: 2013-07-01 23:13:12

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account