Registered User
Joined: 10/7/2004
Posts: 35
|
Please let me know how to write a formula show stocks that have the tcc 31 days crossing over the ma 10 days.
You r team is very helpful to new people. THX
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
This should work:
(TSV31 > AVG(TSV31,10)) and (TSV31.1 < AVG(TSV31.1,10))
It assumes you are using a simple TSV and moving average. Let me know how it looks!
- Craig
Here to Help!
|
|
Registered User
Joined: 10/7/2004
Posts: 35
|
Last Post on TVS does show the TVS31 Crossing MA 10. Seems formula only takes care of TVS 31
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Correct, for a different period TSV, change the "31"s to whatever other period you like.
- Craig
Here to Help!
|
|
Registered User
Joined: 10/7/2004
Posts: 35
|
The symbol ESTX does not seem to work with formul of TSV 31>
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
I am showing no ticker of "ESTX". Could you check the ticker again for me? Also, what do you mean it "does not seem to work". If you could expand on this for me, please.
- Craig
Here to Help!
|
|
Registered User
Joined: 10/7/2004
Posts: 35
|
QUOTE (Craig_S) Correct, for a different period TSV, change the "31"s to whatever other period you like.
What about the Moving Avg in the formula???
|
|
Registered User
Joined: 10/7/2004
Posts: 35
|
Symbol is ECTX. SORRY
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Here is the original formula....
(TSV31 > AVG(TSV31,10)) and (TSV31.1 < AVG(TSV31.1,10))
It was for a TSV of 31 with an average of 10. For a TSV different than the 31 change the 31s in formula, for a different moving average than the 10, change the 10s.
ECTX shows up in my system returning a TRUE. Double check the WatchList you are calculating your Personal Criteria Formulas on. Is it set to ALL STOCKS?
- Craig
Here to Help!
|
|
Registered User
Joined: 10/7/2004
Posts: 35
|
ECTX even though says tru chart show MA moving through TSV. Should be TSV crossing MA 10
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 4,308
|
On my chart for ECTX, TSV31 and the 10 day MA of TSV have been right on top of each other for the past several days. As of Friday's close, however, TSV31 is slightly higher than its MA, and it was just slightly below the MA at Thursday's close, which is why it returns a true for the formula. Please be sure you're looking at a daily chart, not a two day or weekly chart...must be daily.
- Doug
Teaching Online!
|
|
Administration
Joined: 9/30/2004
Posts: 9,187
|
TSV31 is crossing up through the 10 period moving average of TSV. That's exactly what I see on a Daily chart of ECTX. A little hard to see because TSV and it's average have been almost touching for the past 4 days.
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
...also keep in mind that TSV will always be the one to "cross". The moving average is a smoothed version of the TSV (less volatile) and will always move slower than the TSV. When a crossing occurs, the TSV will move first because the moving average is slowed by the average of the previous plots of TSV. It is impossible, in my opinion, for the moving average to "cross" the TSV.
- Craig
Here to Help!
|
|
Registered User
Joined: 10/7/2004
Posts: 35
|
Think my problem is in my understanding of what is TSV31.. Does it mean an avg odf 31 days data to determine cross. What I was looking for was being able to see when the TSV crossed the MA for three consecutive days. Also adding the cross above the zero line.
Sorry for confusion, learning curve.
Learning from my mistakes
|
|
Registered User
Joined: 10/7/2004
Posts: 35
|
Please expand formula to include that only show cross when above 0 line
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
When you plot TSV it has a period setting. The period is an average of the raw TSV value. If you put a "31" in for the period then, in PCF language, this is TSV31.
Are you asking for the TSV to cross each of the three days for a total of three crossings (up through, down through, up through again?)
What period are you setting for your TSV? Is it 31? You asked for the TSV being above 0 in a new topic. I will answer it here and delete your other one.
TSVX > 0
(replace the "X" with whatever period your TSV is). You can add this to the formula above with an "AND".
Make sense?
- Craig
Here to Help!
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 4,308
|
(TSV31.3 < AVG(TSV31.3,10)) AND (TSV31.3 > 0) AND (TSV31.2 > AVG(TSV31.2,10)) AND (TSV31.2 > 0) AND (TSV31.1 > AVG(TSV31.1,10)) AND (TSV31.1 > 0) AND (TSV31 > AVG(TSV31,10)) AND (TSV31 > 0)
This formula will pick up any stock where TSV31 has crossed up through its 10 Day moving average three days ago and has remained above. It also ensures that TSV31 has remained above 0 for all of the past four days.
Is that what you're looking for?
- Doug
Teaching Online!
|
|
Registered User
Joined: 10/7/2004
Posts: 35
|
What I mean is having the TSV above the 0 line for three straight days.
Does 31 in TSV mean 31 days of data used???
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
I answer this for you in the post above Doug's:
QUOTEWhen you plot TSV it has a period setting. The period is an average of the raw TSV value. If you put a "31" in for the period then, in PCF language, this is TSV31.
TSV uses many days of data for its calculation. We do not know how many days becuase the formula for TSV is not public. The period is the number of days of TSV that is averaged to plot the line.
- Craig
Here to Help!
|
|
Registered User
Joined: 10/17/2007
Posts: 15
|
My setup is TSV(38 Exp) and MovAvg(22 Exp). could you provide a PCF to scan the TSV crossing the MovAvg either from above or below?
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
ats33,
Welcome to the forums. A very good foundation for learning how to use TeleChart can be gained by reviewing the following:
If you are new to TeleChart READ THIS FIRST!
Please try one or more of the following:
Exponential TSV38 xUp its own EMA22:
XAVG(TSV,38) < XAVG(TSV,22) AND XAVG(TSV1.1,38) > XAVG(TSV1.1,22)
Exponential TSV38 xDn its own EMA22:
XAVG(TSV,38) > XAVG(TSV,22) AND XAVG(TSV1.1,38) < XAVG(TSV1.1,22)
Exponential TSV38 crossing its own EMA22 (either direction):
SGN(XAVG(TSV,38) - XAVG(TSV,22)) <> SGN(XAVG(TSV1.1,38) - XAVG(TSV1.1,22))
You may wish to review the following:
How to create a Personal Criteria Forumula (PCF)
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
Cascades of Moving Averages
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/17/2007
Posts: 15
|
How to write a PCF to sort TSV in weekly chart for the last 3 months in relative to zero line?
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
ats33,
I do not know of a way to write Weekly TSV Personal Criteria Formulas in TeleChart without using the formula for TSV itself (and that's proprietary).
It might be possible to use Indicator Sorting, but I'm not sure from your question on what aspect of TSV you wish to sort.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/17/2007
Posts: 15
|
Hi Bruce,
I want to find stocks with its weekly TSV stays below zero line in the last three months.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
ats33,
I cannot think of a practical automated method of doing so using TeleChart.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |