cpatriaw
8 posts
msg #109938
- Ignore cpatriaw |
1/7/2013 6:21:31 PM
Hello,
I'm trying to make a statistic for particular stock, eg: AAPL. How many times it closes green in the last 100 minute when the open price at each occurence is lesser than 3 day Moving average.
Any idea ?
|
four
5,087 posts
msg #109940
- Ignore four
modified |
1/7/2013 7:07:34 PM
Hello,
I'm trying to make a statistic for particular stock, eg: AAPL. How many times it closes green in the last 100 minute when the open price at each occurence is lesser than 3 day Moving average.
Any idea ?
------------------------------------------
I don't believe you can COUNT occurrences in minutes. However...
Days may be counted with the COUNT indicator.
closes green in the last 100 minute days.
To handle your request in days:
+ FIRST (green) - determine if a single day is green
+ SECOND (opma) - determine if a single day open is less than MA(3)
+ THIRD (both) - determine when both of the above variables meet true requirement at the same time
+ FOURTH (d100) - count how many times in 100 days (both) equals 1
]
|
cpatriaw
8 posts
msg #109941
- Ignore cpatriaw |
1/7/2013 7:16:55 PM
I do understand. But i want the statistic only counts when the opening price is less than 3 DMA.
|
four
5,087 posts
msg #109943
- Ignore four |
1/7/2013 8:03:49 PM
try the above
|
cpatriaw
8 posts
msg #109945
- Ignore cpatriaw |
1/7/2013 8:27:32 PM
Thanks but looks like the d100 only counts how many days the open is lower than MA(3),but i want to know how many days out of those date, that it closes greens. For example currently in the last 10 days, SPY open price below ma(3) is 7, but closes green 3 times.
|
four
5,087 posts
msg #109947
- Ignore four
modified |
1/7/2013 9:27:37 PM
|
Kevin_in_GA
4,599 posts
msg #109957
- Ignore Kevin_in_GA |
1/8/2013 10:22:41 AM
Try this:
This gives you the number of times each criterion was met over the last 100 days, and the percentage of times both occurred on the same day.
|
TheRumpledOne
6,411 posts
msg #109973
- Ignore TheRumpledOne |
1/8/2013 4:20:41 PM
It's nice to see fellow traders using statistics :)
|
cpatriaw
8 posts
msg #110026
- Ignore cpatriaw |
1/9/2013 11:39:59 PM
thanks a lot. What's the purpose of "set{opma100, count(opma above 0.5,100)}" ?? why 0.5 ?
|
cpatriaw
8 posts
msg #110061
- Ignore cpatriaw |
1/10/2013 8:41:13 PM
i found amazing statistic with this approach, when i combined with certain RSI. Now the only problem is ........the signal only generated during intraday which the data is delayed for 15 minutes in stockfetcher :( this is important as the given stock's low is also the open....
|