| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
 Gold Customer
Joined: 6/29/2005
Posts: 885
|
I would like to make a formula to give me a cumulative plot for the following conditon
The number of days a stock gaps up ( O>C1) when the day before is green candle ( C1>O1)
divided by the total number of green candles.
Thanks!
|
|
Administration
Joined: 9/30/2004
Posts: 9,187
|
Not sure if this is possible but at a minimum we'll need to define a period. "Total number of green candles" over the last 50 bars? 100 bars?
|
|
Gold Customer
Joined: 6/29/2005
Posts: 885
|
lets try 50 days
|
|
Administration
Joined: 9/30/2004
Posts: 9,187
|
You'll need to run version 17 or higher but the following will plot the ratio of gap us after a green candle vs green candles over the last 50 bars.
CountTrue(O>C1 AND C1>O1,50) / CountTrue(C1>O1,50)
|
|
Gold Customer
Joined: 6/29/2005
Posts: 885
|
Im on gold as you can see.. cant I make something on there?
If not, can I separat them into2 different conditon to plot
( though I rather hve the ratio)
BTW do you kno there is somtng wron with thishat.. Itisimpossilbe type inhere.. misseskeystrokses, wont space etc..
|
|
Administration
Joined: 9/30/2004
Posts: 9,187
|
You can put that formula into a Custom PCF Indicator with Gold service, but you will have to run TC2000 version 17 or higher. The CountTrue syntax is not available in older versions.
http://www.tc2000.com/download
|
|
|
Guest-1 |