| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 10/29/2004
Posts: 13
|
I am trying to construct a PCF to find issues where the tsv is coming into a low price reversal area. I think i need to first find the low area and then with a second PCF find where the TSV swings positive up through the moving avg. This is my first attempt at the first formula:
TSV18.1 <= 0 AND TSV18 < 0 ,where .1 is the look back period
I am assuming the above formula will yield issue where the TSV is low and heading lower. I would use additional filtering to weed out unwanted issues.
After running this PCF I would save the results in a watch list and then run the second PCF.
I am not certain how to construct the second PCF to reveal the move from below the moving avg to above the moving avg. Can you help me there also.
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Your PCF above will find stocks where the last two days TSV18 was below 0.
I read your description... try this for me:
MIN(TSV18,10)=MIN(TSV18,100) AND TSV18<0
Look at the charts found with this and tell me if it fits what you want better.
To find TSV18 crossing its own moving averages try the PCF below. I use a 20-bar simple MA. You can change the 20 in the formula below to match the period of the MA you are using on your charts:
TSV18>AVG(TSV18,20) AND TSV18.1<AVG(TSV18.1,20)
- Craig
Here to Help!
|
|
Registered User
Joined: 10/29/2004
Posts: 13
|
I ran the suggested formula against the entire stock list and it resulted in ~700 true. As you commented it seems to fit better. I see stocks heading lower. But the TSV is still above zero for some, one can often stay in a stock if the TSV is at zero. So if I find issues below TSV zero I can look for the turn. By additional filter for good fundamentals I can see which have the best chance to change direction. When i view the stochastic i can see it is also in a potential reversal area.
What i have found is that a stock with good fundamentals can pull back into a buy zone and the weekly TSV and Stochastic clearly show that , see KOMG on 10/14, 10/21 and 11/18/05.
Would you please state the syntax so i am clear.
|
|
Registered User
Joined: 10/29/2004
Posts: 13
|
added the second formula and sorted on that criteria. The list was reduced to 46. Agian so i am not confused please state the synatx. Then i'll go about some fime tuning. Thank for your help as i always struggle with syntax.
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
My first formula does not allow the TSV today to be above 0:
MIN(TSV18,10)=MIN(TSV18,100) AND TSV18<0
My second formula looks for crossovers and, if you don't use it in cunjuction with the first, will allow the cross to occur above 0.
TSV18>AVG(TSV18,20) AND TSV18.1<AVG(TSV18.1,20)
This version will make sure the crossover is below 0 (so you don't have to use it along with the first one)
TSV18>AVG(TSV18,20) AND TSV18.1<AVG(TSV18.1,20) AND TSV18<0
- Craig
Here to Help!
|
|
|
Guest-1 |