Support Board
Date/Time: Sat, 23 Nov 2024 12:14:22 +0000
Post From: spreadsheet help needed...true/false to 1/0
| [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 |