| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 9/16/2006
Posts: 47
|
Good evening.
Can someone please tell me if there is a way to scan for stocks where TSV has recently crossed the zero line and Money Stream has recently crossed the 20 period MA?
Thank you.
Perry
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
We will probably be able to provide a formula if you provide your TSV and Moving Average Settings and a Period of time you would consider "recent":
Select Chart Template | Edit | Time Segmented Volume.
- Period: ?
- Average Type: Simple or Exponential?
Select Chart Template | Edit | Moving Average - 20 Bars (the one on MoneyStream).
- Period: 20
- Average Type: Simple or Exponential?
- Shift Left: Checked or Unchecked?
You may wish to review the following:
How to create a Personal Criteria Forumula (PCF)
Using EasyScan to find stocks that meet your own criteria
Handy PCF example formulas to help you learn the syntax of PCFs!
Personal Criteria Language Function List
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 11/2/2004
Posts: 12
|
I also am interested in this request. May I suggest a period of 18 for the TSV simple type and for the regular MS a mov avg of 20 simple type and no shift. Your assistance is most appreciated.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
lake355,
You did not suggest a Period of time you would consider "recent", but you may wish to try the following formula which checks if both crossed up within the last five days and stayed there:
(TSV18 > 0 AND MIN(TSV18.1,5) < 0) AND (MS > MS20 AND (MS1.1 < MS20.1 OR MS1.2 < MS20.2 OR MS1.3 < MS20.3 OR MS1.4 < MS20.4 OR MS1.5 < MS20.5))
The directions in each portion of the formula can be switched by reversing the > and < symbols.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 9/16/2006
Posts: 47
|
Good morning, Bruce.
The formula you supplied for lake355 works for me; however is there a shorter, more direct formula for changing the time period? That is, if I would like to search for the same information for a 10 day period do I have to add to the formula for each given day (e.g. ...OR TSV18.6 < 0 OR TSV18.7 < 0 etc.)?
Also, your comment "The directions in each portion of the formula can be switched by reversing the > and < symbols" I would assume is for changing the formula when one desires to seek out short candidates -- correct?
Perry
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
parvenir,
I've made an adjustment to the TSV portion of the equation representing both a shorter formula and a method of adjusting its time period that is hopefully both obvious and direct (change the 5). This could be done because 0 is a fixed target. The other portion of the formula could not use this optimization because MoneyStream and its Moving Average both change over time. It is necessary to add or remove terms manually to adjust the time period.
The trainers cannot give settings, interpretation or investment advice, so I can't say if the current formula produces long candidates and switching it around produces short candidates or not. You might even want to reverse the signs only for the TSV or MS portion of the formula to get crosses going in opposite directions, who knows? That said, your question suggests you understand that the reason to make such changes is to change the direction of the crossover.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 9/16/2006
Posts: 47
|
GREAT! Thanks, Bruce, the formula works perfectly.
Perry
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 9/16/2006
Posts: 47
|
Hi again, Bruce.
I have another question: How does one search/isolate stocks that have been flagged. This morning I performed a couple of scans and flagged several stock symbols for further research. I would like to know how to find/isolate the stock symbols that I flagged.
Perry
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
There is a System Watchlist called All Flagged Items.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 9/16/2006
Posts: 47
|
Thanks Bruce. I was just about to post another message to let you know that I was able to answer my own question after some further research. Thanks for all of your assistance. Have a GREAT weekend.
Perry 
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome and thank you. I wish you a wonderful weekend as well.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 9/16/2006
Posts: 47
|
Hi again, Bruce.
Sorry to trouble you but I have yet another question which is as follows: In the SnapSheets program there is a vertical scroll bar that one can drag left to right to pinpoint a given date and time; does such a tool exist in the TeleChart program?
Perry
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Yes, press the period key (full-stop) to activate the pointer mode.
- Craig
Here to Help!
|
|
Registered User
Joined: 9/16/2006
Posts: 47
|
Perfect. Thanks Craig.
Perry
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
You're welcome!
- Craig
Here to Help!
|
|
|
Guest-1 |