Registered User Joined: 11/3/2005 Posts: 1
|
I am trying to implement the buy and sell signal PCF submitted by Sir Geologist, printed in The Worden Report of February 1 and I am getting syntax errors. The formulas as they appear are the followingl;
Buy Signal
(STOC3.2 > AVG(STOC3.2,3)) AND (STOC8.3 > AVG(STOC8.3,3)) AND (STOC12.3 > AVG(STOC12.3,3)) AND (STOC12.3 < 65) AND (STOC30.4 > AVG(STOC30.4,5)) AND (TSV17 > AVG(TSV17,10)) AND (AVGC20.2 < AVGC20.1 AND (AVGC20.1 < AVGC20)
Sell Signal
(STOC3.2 < AVG(STOC3.2,3)) AND (STOC8.3 < AVG(STOC8.3,3)) AND (STOC12.3 < AVG(STOC12.3,3)) AND (STOC12.3 < 68) AND (STOC30.4 < AVG(STOC30.4,5)) AND (STOC30.4 < 69) AND (TSV17 < AVG(TSV17,10))
I tried replacing the comma with period for those function that used data other than todays data, but that didn't work.
Please let me know since I am very interested in using them.
Thanks,
Bill
Orlando, FL
|
|
Administration
Joined: 9/30/2004 Posts: 9,187
|
Remove the ( before AVGC20.2 in the first formula. The second formula is fine.
|
|
Registered User Joined: 1/28/2005 Posts: 6,049
|
These "worked" in my machine:
(copied directly from the report)
(STOC3.2 > AVG(STOC3.2,3)) AND (STOC8.3 > AVG(STOC8.3,3)) AND (STOC12.3 > AVG(STOC12.3,3)) AND (STOC12.3 < 65) AND (STOC30.4 > AVG(STOC30.4,5)) AND (TSV17 > AVG(TSV17,10)) AND (AVGC20.2 < AVGC20.1) AND (AVGC20.1 < AVGC20)
(STOC3.2 < AVG(STOC3.2,3)) AND (STOC8.3 < AVG(STOC8.3,3)) AND (STOC12.3 < AVG(STOC12.3,3)) AND (STOC12.3 < 68) AND (STOC30.4 < AVG(STOC30.4,5)) AND (STOC30.4 < 69) AND (TSV17 < AVG(TSV17,10))
Realize that you must create a percent true indicator.
Thanks
diceman
|
|
Registered User Joined: 12/27/2006 Posts: 36
|
I have a question reguarding the PCF submitted by Sir Geologist in The Worden Report of February 1
Has anyone set this PCF as a % true indicator?
B) Basic SELL formula is:
(STOC3.2 < AVG(STOC3.2,3)) AND (STOC8.3 < AVG(STOC8.3,3)) AND (STOC12.3 < AVG(STOC12.3,3)) AND (STOC12.3 < 68) AND (STOC30.4 < AVG(STOC30.4,5)) AND (STOC30.4 < 69) AND (TSV17 < AVG(TSV17,10))
The % True indicator is giving buy signals, rather than a sell signals.
Thank You,
ward1
|
|
Registered User Joined: 1/28/2005 Posts: 6,049
|
ward1
I could be wrong as I have not spent a lot of time
looking at these or reading the report.
To my eye this looks like it is indicating weakness.
(so my guess would be the other indicates strength)
Weakness tends to look smart (a good sell) when a
down trend starts. Weakness tends to look better
as a buy when a strong up-trend is in place.
(trend/counter trend trading)
Notice on a symbol like DRYS.
The second June 07 and August 07 triggers look like
good buys. (weakness in a up-trend)
The triggers in November and December 07 look better
as sells. (a real down trend develops)
Thanks
diceman
|
|
Registered User Joined: 12/27/2006 Posts: 36
|
Diceman,
Thank you for your response.
I am still in my learning phase and have a long way to go.
I understand what you are saying.
Although the above % True indicator does spike at many
bottoms with reversals and I think could be useful for a
bottom confirmation.
Thank You,
Ward1
|
|
Registered User Joined: 12/23/2007 Posts: 1
|
please check the following pcf as i have repeatedly gotten syntax error:
(XAVGC34<XAVGC55) AND (XAVGC21<XAVGC34) AND (XAVGC13<XAVGC21) AND (XAVGC2>=XAVGC8)
THANKS, GBURRIS
|
|
Registered User Joined: 1/28/2005 Posts: 6,049
|
" please check the following pcf as i have repeatedly gotten syntax error:
(XAVGC34<XAVGC55) AND (XAVGC21<XAVGC34) AND (XAVGC13<XAVGC21) AND (XAVGC2>=XAVGC8)
THANKS, GBURRIS"
----------------------------------------------------------------------
It worked on my machine.
Realize that if you are creating a custom indicator.
It must be a percent true type.
Realize also if it says false on the test symbol. It
is not an error.
(it just means it is false for that symbol)
Thanks
diceman
|
|
Registered User Joined: 6/17/2008 Posts: 33
|
hi guys, before i type this formula from sir geologist into the tcnet, did anyone of you added the complimentary conditions like: a positive(long-up) of 2-6 weeks or more(stoc 30.4>avg(stoc30.4,5))and(tsv17>avg(tsv17,10)) then, a positive( long-up)of 1-3 weeks :(stoc8.3>avg(stoc8.3,3))and(stoc12.3>avg(stoc12.3,3))and(stoc12.3<65), then, a positve (long-up)of1-6 days:(stoc3.2>avg(stoc3.2,3)) altogether with the buy signal formula? thx 4 response!
|
|
Registered User Joined: 6/17/2008 Posts: 33
|
and please, tell me wich indicators are to suit this formula?thx
|
|
Registered User Joined: 6/17/2008 Posts: 33
|
felows,sometimes when you click on the "test" button to verify if the formula is right, it says "results:false"; does it means the formula is wrong even know its matching the formula clipboard?
|
|
Registered User Joined: 10/7/2004 Posts: 35
|
Nope,
False means that it does not ring TRUE... Meaning False.... as if 1+1=3...........FALSE....
or 1+1=2.........TRUE...
|
|
Registered User Joined: 6/8/2007 Posts: 31
|
How to Post graph I see important for viewers and my observations on it
|
|
Registered User Joined: 1/28/2005 Posts: 6,049
|
"How to Post graph I see important for viewers and my observations on it"
See this:
Thanks
diceman
|
|
Guest-1 |