 Gold Customer
Joined: 1/28/2005
Posts: 97
|
I use three stochastics, that do not show the SD period. So they are basically single line stochastic. Their settings are 5,3 8,3 and 12,3. I currently have a pCF that show me when all three have crossed the 50 line. ((STOC5.3 > 50) AND (STOC8.3 > 50) AND ( STOC12.3 > 50)).
Can you show me how to create a PCF that shows all three are greater than 50 AND also, they are very close together or on top of one another.
Also, how do I create a seperate PCF that calculates this for the 2 day chart?
Thanks in advance
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Your PCF:
((STOC5.3 > 50) AND (STOC8.3 > 50) AND ( STOC12.3 > 50))
Has nothing to do with them crossing 50. It only requires all three to be above 50.
When you say "very close together" how close is close? within 1, 2, 3 points of each other?
- Craig
Here to Help!
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Please try the following:
STOC5.3 > 50 AND STOC8.3 > 50 AND STOC12.3 > 50 AND ABS(STOC5.3 - STOC8.3) + ABS(STOC5.3 - STOC12.3) + ABS(STOC8.3 - STOC12.3) < 5
You will need to adjust the 5 at the end of the formula based on your definition of "very close together". A two day version would be:
STOC10 + STOC10.1.2 + STOC10.1.4 > 150 AND STOC16 + STOC16.1.2 + STOC16.1.4 > 150 AND STOC24 + STOC24.1.2 + STOC24.1.4 > 150 AND ABS(STOC10 + STOC10.1.2 + STOC10.1.4 - STOC16 - STOC16.1.2 - STOC16.1.4) + ABS(STOC10 + STOC10.1.2 + STOC10.1.4 - STOC24 - STOC24.1.2 - STOC24.1.4) + ABS(STOC16 + STOC16.1.2 + STOC16.1.4 - STOC24 - STOC24.1.2 - STOC24.1.4) < 15
I multiplied the desired target values by three instead of dividing the sum of the stochastics by three to get a moving average.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Gold Customer
Joined: 1/28/2005
Posts: 97
|
In the first PCF where it end .....)<5. if i want the stochastics all to be greater than 50, should that read >50. the current PCF does not create any values. but when i changed it to >50 it does. can you check this for me please?
|
|
Gold Customer
Joined: 1/28/2005
Posts: 97
|
also Craig,
how do I do the two above PCFs so that they do the same, but they are both below the 50 line?
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
QUOTE (financialbillionairemagician) In the first PCF where it end .....)<5. if i want the stochastics all to be greater than 50, should that read >50.
No. The first three comparisons should be greater than fifty, but the last is looking for small numbers so they are "very close together". The problem was that there was an 8.3 where there should have been a STOC8.3. It has been corrected in the original post.
QUOTE (financialbillionairemagician) how do I do the two above PCFs so that they do the same, but they are both below the 50 line?
Please try the following:
STOC5.3 < 50 AND STOC8.3 < 50 AND STOC12.3 < 50 AND ABS(STOC5.3 - STOC8.3) + ABS(STOC5.3 - STOC12.3) + ABS(STOC8.3 - STOC12.3) < 5
You will need to adjust the 5 at the end of the formula based on your definition of "very close together". A two day version would be:
STOC10 + STOC10.1.2 + STOC10.1.4 < 150 AND STOC16 + STOC16.1.2 + STOC16.1.4 < 150 AND STOC24 + STOC24.1.2 + STOC24.1.4 < 150 AND ABS(STOC10 + STOC10.1.2 + STOC10.1.4 - STOC16 - STOC16.1.2 - STOC16.1.4) + ABS(STOC10 + STOC10.1.2 + STOC10.1.4 - STOC24 - STOC24.1.2 - STOC24.1.4) + ABS(STOC16 + STOC16.1.2 + STOC16.1.4 - STOC24 - STOC24.1.2 - STOC24.1.4) < 15
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Gold Customer
Joined: 1/28/2005
Posts: 97
|
Hi Bruce
The PCF for the two day does not appear to be working. For example if you look at ticker symbol PPDI, the three stochastics are extremly close together on the 2 day chart from 10/24/06 -11/03/06 and below the 50 line, however when i ran a percent true indicator to test the formula, it gave me multiple periods that were not correct. I have tested it on multiple chrts and it repetas this incorrect identification.
When i wrote the following to see what would happen..........
STOC5.3 < 100 AND STOC8.3 < 100 AND STOC12.3 < 100 AND ABS(STOC5.3 - STOC8.3) + ABS(STOC5.3 - STOC12.3) + ABS(STOC8.3 - STOC12.3) < 15
iT IDENTIFIED THE CORRECT PERIOD, HOWEVER IT ALSO FOUND LOTS OF FALSE POSITIVES
Can you have a look for me at both of your 2 days PCF's please.
I appreciate your help and guidance in advance.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
QUOTE (financialbillionairemagician) ...when i ran a percent true indicator to test the formula, it gave me multiple periods that were not correct.
Don't to that.
The two day per bar formulas only work as Personal Criteria Formulas or to identify two day per bar patterns on a one day per bar chart. Use the daily versions in your Custom Percent True Indicators on two day per bar charts.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Gold Customer
Joined: 1/28/2005
Posts: 97
|
Bruce
Thank you so much for your help. If you make me a rich man as a result of your help expect a cheque in the post. ;)
ooooohhhhhh, just had an idea.
How do create the same below 50 and above 50 pcf, but it identifies it on a weekly chart?
Patrick
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Weekly Above 50 and Near:
STOC25 + STOC25.1.5 + STOC25.1.10 > 150 AND STOC40 + STOC40.1.5 + STOC40.1.10 > 150 AND STOC60 + STOC60.1.5 + STOC60.1.10 > 150 AND ABS(STOC25 + STOC25.1.5 + STOC25.1.10 - STOC40 - STOC40.1.5 - STOC40.1.10) + ABS(STOC25 + STOC25.1.5 + STOC25.1.10 - STOC60 - STOC60.1.5 - STOC60.1.10) + ABS(STOC40 + STOC40.1.5 + STOC40.1.10 - STOC60 - STOC60.1.5 - STOC60.1.10) < 15
Weekly Below 50 and Near:
STOC25 + STOC25.1.5 + STOC25.1.10 < 150 AND STOC40 + STOC40.1.5 + STOC40.1.10 < 150 AND STOC60 + STOC60.1.5 + STOC60.1.10 < 150 AND ABS(STOC25 + STOC25.1.5 + STOC25.1.10 - STOC40 - STOC40.1.5 - STOC40.1.10) + ABS(STOC25 + STOC25.1.5 + STOC25.1.10 - STOC60 - STOC60.1.5 - STOC60.1.10) + ABS(STOC40 + STOC40.1.5 + STOC40.1.10 - STOC60 - STOC60.1.5 - STOC60.1.10) < 15
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Gold Customer
Joined: 1/28/2005
Posts: 97
|
How do i write a PCf for positive and negative 2 and weekly Mac D setting of 5, 15, 10?
Patrick
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
I can write a formula for a Weekly MACD 5,15,10, but I have some questions about what you want to know about it before actually doing so.
Is it Simple or Exponential?
What is positive and negative 2 about it?
Is it the raw MACD?
Is it the MACD trigger line?
Is it the MACD Histogram?
Is it the slope of one of these lines?
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Gold Customer
Joined: 1/28/2005
Posts: 97
|
The Mac D is Exponential
2 = 2 day
Based on a histogram
negative = below 0 and positive = above 0
thus 4 mac d pcf's (1) 2 day positive (2) 2 day negative (4) weekly positive (4) weekly negative.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Please try the following:
2-Day per Bar Exponential MACD 5,15,10 Histogram Below Zero:
.600406258581356 * (C + 2 / 3 * (C2 + 2 / 3 * (C4 + 2 / 3 * (C6 + 2 / 3 * (C8 + 2 / 3 * (C10 + 2 / 3 * (C12 + 2 / 3 * (C14 + 2 / 3 * (C16 + 2 / 3 * (C18 + 2 / 3 * (C20 + 2 / 3 * (C22 + 2 / 3 * (C24 + 2 / 3 * (C26 + 2 / 3 * (C28 + 2 / 3 * (C30 + 2 / 3 * (C32 + 2 / 3 * (C34)))))))))))))))))) + .225217280357391 * (C + 7 / 8 * (C2 + 7 / 8 * (C4 + 7 / 8 * (C6 + 7 / 8 * (C8 + 7 / 8 * (C10 + 7 / 8 * (C12 + 7 / 8 * (C14 + 7 / 8 * (C16 + 7 / 8 * (C18 + 7 / 8 * (C20 + 7 / 8 * (C22 + 7 / 8 * (C24 + 7 / 8 * (C26 + 7 / 8 * (C28 + 7 / 8 * (C30 + 7 / 8 * (C32 + 7 / 8 * (C34 + 7 / 8 * (C36 + 7 / 8 * (C38 + 7 / 8 * (C40 + 7 / 8 * (C42 + 7 / 8 * (C44 + 7 / 8 * (C46 + 7 / 8 * (C48 + 7 / 8 * (C50 + 7 / 8 * (C52 + 7 / 8 * (C54 + 7 / 8 * (C56 + 7 / 8 * (C58 + 7 / 8 * (C60 + 7 / 8 * (C62 + 7 / 8 * (C64 + 7 / 8 * (C66 + 7 / 8 * (C68 + 7 / 8 * (C70 + 7 / 8 * (C72 + 7 / 8 * (C74 + 7 / 8 * (C76 + 7 / 8 * (C78 + 7 / 8 * (C80 + 7 / 8 * (C82 + 7 / 8 * (C84 + 7 / 8 * (C86 + 7 / 8 * (C88 + 7 / 8 * (C90 + 7 / 8 * (C92 + 7 / 8 * (C94 + 7 / 8 * (C96 + 7 / 8 * (C98 + 7 / 8 * (C100 + 7 / 8 * (C102)))))))))))))))))))))))))))))))))))))))))))))))))))) - .655128994598645 * (C + 9 / 11 * (C2 + 9 / 11 * (C4 + 9 / 11 * (C6 + 9 / 11 * (C8 + 9 / 11 * (C10 + 9 / 11 * (C12 + 9 / 11 * (C14 + 9 / 11 * (C16 + 9 / 11 * (C18 + 9 / 11 * (C20 + 9 / 11 * (C22 + 9 / 11 * (C24 + 9 / 11 * (C26 + 9 / 11 * (C28 + 9 / 11 * (C30 + 9 / 11 * (C32 + 9 / 11 * (C34 + 9 / 11 * (C36 + 9 / 11 * (C38 + 9 / 11 * (C40 + 9 / 11 * (C42 + 9 / 11 * (C44 + 9 / 11 * (C46 + 9 / 11 * (C48 + 9 / 11 * (C50 + 9 / 11 * (C52 + 9 / 11 * (C54 + 9 / 11 * (C56 + 9 / 11 * (C58 + 9 / 11 * (C60 + 9 / 11 * (C62 + 9 / 11 * (C64 + 9 / 11 * (C66 + 9 / 11 * (C68))))))))))))))))))))))))))))))))))) < 0
2-Day per Bar Exponential MACD 5,15,10 Histogram Above Zero:
.600406258581356 * (C + 2 / 3 * (C2 + 2 / 3 * (C4 + 2 / 3 * (C6 + 2 / 3 * (C8 + 2 / 3 * (C10 + 2 / 3 * (C12 + 2 / 3 * (C14 + 2 / 3 * (C16 + 2 / 3 * (C18 + 2 / 3 * (C20 + 2 / 3 * (C22 + 2 / 3 * (C24 + 2 / 3 * (C26 + 2 / 3 * (C28 + 2 / 3 * (C30 + 2 / 3 * (C32 + 2 / 3 * (C34)))))))))))))))))) + .225217280357391 * (C + 7 / 8 * (C2 + 7 / 8 * (C4 + 7 / 8 * (C6 + 7 / 8 * (C8 + 7 / 8 * (C10 + 7 / 8 * (C12 + 7 / 8 * (C14 + 7 / 8 * (C16 + 7 / 8 * (C18 + 7 / 8 * (C20 + 7 / 8 * (C22 + 7 / 8 * (C24 + 7 / 8 * (C26 + 7 / 8 * (C28 + 7 / 8 * (C30 + 7 / 8 * (C32 + 7 / 8 * (C34 + 7 / 8 * (C36 + 7 / 8 * (C38 + 7 / 8 * (C40 + 7 / 8 * (C42 + 7 / 8 * (C44 + 7 / 8 * (C46 + 7 / 8 * (C48 + 7 / 8 * (C50 + 7 / 8 * (C52 + 7 / 8 * (C54 + 7 / 8 * (C56 + 7 / 8 * (C58 + 7 / 8 * (C60 + 7 / 8 * (C62 + 7 / 8 * (C64 + 7 / 8 * (C66 + 7 / 8 * (C68 + 7 / 8 * (C70 + 7 / 8 * (C72 + 7 / 8 * (C74 + 7 / 8 * (C76 + 7 / 8 * (C78 + 7 / 8 * (C80 + 7 / 8 * (C82 + 7 / 8 * (C84 + 7 / 8 * (C86 + 7 / 8 * (C88 + 7 / 8 * (C90 + 7 / 8 * (C92 + 7 / 8 * (C94 + 7 / 8 * (C96 + 7 / 8 * (C98 + 7 / 8 * (C100 + 7 / 8 * (C102)))))))))))))))))))))))))))))))))))))))))))))))))))) - .655128994598645 * (C + 9 / 11 * (C2 + 9 / 11 * (C4 + 9 / 11 * (C6 + 9 / 11 * (C8 + 9 / 11 * (C10 + 9 / 11 * (C12 + 9 / 11 * (C14 + 9 / 11 * (C16 + 9 / 11 * (C18 + 9 / 11 * (C20 + 9 / 11 * (C22 + 9 / 11 * (C24 + 9 / 11 * (C26 + 9 / 11 * (C28 + 9 / 11 * (C30 + 9 / 11 * (C32 + 9 / 11 * (C34 + 9 / 11 * (C36 + 9 / 11 * (C38 + 9 / 11 * (C40 + 9 / 11 * (C42 + 9 / 11 * (C44 + 9 / 11 * (C46 + 9 / 11 * (C48 + 9 / 11 * (C50 + 9 / 11 * (C52 + 9 / 11 * (C54 + 9 / 11 * (C56 + 9 / 11 * (C58 + 9 / 11 * (C60 + 9 / 11 * (C62 + 9 / 11 * (C64 + 9 / 11 * (C66 + 9 / 11 * (C68))))))))))))))))))))))))))))))))))) > 0
Weekly Exponential MACD 5,15,10 Histogram Below Zero:
.600406258581356 * (C + 2 / 3 * (C5 + 2 / 3 * (C10 + 2 / 3 * (C15 + 2 / 3 * (C20 + 2 / 3 * (C25 + 2 / 3 * (C30 + 2 / 3 * (C35 + 2 / 3 * (C40 + 2 / 3 * (C45 + 2 / 3 * (C50 + 2 / 3 * (C55 + 2 / 3 * (C60 + 2 / 3 * (C65 + 2 / 3 * (C70 + 2 / 3 * (C75 + 2 / 3 * (C80 + 2 / 3 * (C85)))))))))))))))))) + .225217280357391 * (C + 7 / 8 * (C5 + 7 / 8 * (C10 + 7 / 8 * (C15 + 7 / 8 * (C20 + 7 / 8 * (C25 + 7 / 8 * (C30 + 7 / 8 * (C35 + 7 / 8 * (C40 + 7 / 8 * (C45 + 7 / 8 * (C50 + 7 / 8 * (C55 + 7 / 8 * (C60 + 7 / 8 * (C65 + 7 / 8 * (C70 + 7 / 8 * (C75 + 7 / 8 * (C80 + 7 / 8 * (C85 + 7 / 8 * (C90 + 7 / 8 * (C95 + 7 / 8 * (C100 + 7 / 8 * (C105 + 7 / 8 * (C110 + 7 / 8 * (C115 + 7 / 8 * (C120 + 7 / 8 * (C125 + 7 / 8 * (C130 + 7 / 8 * (C135 + 7 / 8 * (C140 + 7 / 8 * (C145 + 7 / 8 * (C150 + 7 / 8 * (C155 + 7 / 8 * (C160 + 7 / 8 * (C165 + 7 / 8 * (C170 + 7 / 8 * (C175 + 7 / 8 * (C180 + 7 / 8 * (C185 + 7 / 8 * (C190 + 7 / 8 * (C195 + 7 / 8 * (C200 + 7 / 8 * (C205 + 7 / 8 * (C210 + 7 / 8 * (C215 + 7 / 8 * (C220 + 7 / 8 * (C225 + 7 / 8 * (C230 + 7 / 8 * (C235 + 7 / 8 * (C240 + 7 / 8 * (C245 + 7 / 8 * (C250 + 7 / 8 * (C255)))))))))))))))))))))))))))))))))))))))))))))))))))) - .655128994598645 * (C + 9 / 11 * (C5 + 9 / 11 * (C10 + 9 / 11 * (C15 + 9 / 11 * (C20 + 9 / 11 * (C25 + 9 / 11 * (C30 + 9 / 11 * (C35 + 9 / 11 * (C40 + 9 / 11 * (C45 + 9 / 11 * (C50 + 9 / 11 * (C55 + 9 / 11 * (C60 + 9 / 11 * (C65 + 9 / 11 * (C70 + 9 / 11 * (C75 + 9 / 11 * (C80 + 9 / 11 * (C85 + 9 / 11 * (C90 + 9 / 11 * (C95 + 9 / 11 * (C100 + 9 / 11 * (C105 + 9 / 11 * (C110 + 9 / 11 * (C115 + 9 / 11 * (C120 + 9 / 11 * (C125 + 9 / 11 * (C130 + 9 / 11 * (C135 + 9 / 11 * (C140 + 9 / 11 * (C145 + 9 / 11 * (C150 + 9 / 11 * (C155 + 9 / 11 * (C160 + 9 / 11 * (C165 + 9 / 11 * (C170))))))))))))))))))))))))))))))))))) < 0
Weekly Exponential MACD 5,15,10 Histogram Above Zero:
.600406258581356 * (C + 2 / 3 * (C5 + 2 / 3 * (C10 + 2 / 3 * (C15 + 2 / 3 * (C20 + 2 / 3 * (C25 + 2 / 3 * (C30 + 2 / 3 * (C35 + 2 / 3 * (C40 + 2 / 3 * (C45 + 2 / 3 * (C50 + 2 / 3 * (C55 + 2 / 3 * (C60 + 2 / 3 * (C65 + 2 / 3 * (C70 + 2 / 3 * (C75 + 2 / 3 * (C80 + 2 / 3 * (C85)))))))))))))))))) + .225217280357391 * (C + 7 / 8 * (C5 + 7 / 8 * (C10 + 7 / 8 * (C15 + 7 / 8 * (C20 + 7 / 8 * (C25 + 7 / 8 * (C30 + 7 / 8 * (C35 + 7 / 8 * (C40 + 7 / 8 * (C45 + 7 / 8 * (C50 + 7 / 8 * (C55 + 7 / 8 * (C60 + 7 / 8 * (C65 + 7 / 8 * (C70 + 7 / 8 * (C75 + 7 / 8 * (C80 + 7 / 8 * (C85 + 7 / 8 * (C90 + 7 / 8 * (C95 + 7 / 8 * (C100 + 7 / 8 * (C105 + 7 / 8 * (C110 + 7 / 8 * (C115 + 7 / 8 * (C120 + 7 / 8 * (C125 + 7 / 8 * (C130 + 7 / 8 * (C135 + 7 / 8 * (C140 + 7 / 8 * (C145 + 7 / 8 * (C150 + 7 / 8 * (C155 + 7 / 8 * (C160 + 7 / 8 * (C165 + 7 / 8 * (C170 + 7 / 8 * (C175 + 7 / 8 * (C180 + 7 / 8 * (C185 + 7 / 8 * (C190 + 7 / 8 * (C195 + 7 / 8 * (C200 + 7 / 8 * (C205 + 7 / 8 * (C210 + 7 / 8 * (C215 + 7 / 8 * (C220 + 7 / 8 * (C225 + 7 / 8 * (C230 + 7 / 8 * (C235 + 7 / 8 * (C240 + 7 / 8 * (C245 + 7 / 8 * (C250 + 7 / 8 * (C255)))))))))))))))))))))))))))))))))))))))))))))))))))) - .655128994598645 * (C + 9 / 11 * (C5 + 9 / 11 * (C10 + 9 / 11 * (C15 + 9 / 11 * (C20 + 9 / 11 * (C25 + 9 / 11 * (C30 + 9 / 11 * (C35 + 9 / 11 * (C40 + 9 / 11 * (C45 + 9 / 11 * (C50 + 9 / 11 * (C55 + 9 / 11 * (C60 + 9 / 11 * (C65 + 9 / 11 * (C70 + 9 / 11 * (C75 + 9 / 11 * (C80 + 9 / 11 * (C85 + 9 / 11 * (C90 + 9 / 11 * (C95 + 9 / 11 * (C100 + 9 / 11 * (C105 + 9 / 11 * (C110 + 9 / 11 * (C115 + 9 / 11 * (C120 + 9 / 11 * (C125 + 9 / 11 * (C130 + 9 / 11 * (C135 + 9 / 11 * (C140 + 9 / 11 * (C145 + 9 / 11 * (C150 + 9 / 11 * (C155 + 9 / 11 * (C160 + 9 / 11 * (C165 + 9 / 11 * (C170))))))))))))))))))))))))))))))))))) > 0
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Gold Customer
Joined: 5/28/2005
Posts: 5
|
CAN YOU CONVERT A PCF FORMULA STOC13.3 < 20 FOR END OF DAY TO A STOC13.3 < 20 IN HOURLY?
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
timithynuon,
Personal Criteria Formulas do not work on intra-day data. You could use a Custom Indicator with Real Time Indicator Sorting however. In this case there is no need to convert the formula. The Custom Indicator will automatically use Hourly Bars when viewing an Hourly chart.
You may wish to review the following:
Visually Backtesting Specific Symbols
Real time indicator sorting (available at the Platinum level)
Plotting Custom Indicators with Examples
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |