Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

need a formula Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
amcbride
Posted : Friday, May 8, 2009 8:09:17 PM
Registered User
Joined: 12/18/2005
Posts: 4
I'm looking for stocks that are oversold and turning up.  What formulas would I use to indicate the following:
1) 14 day rsi yesterday is less that 30

2)14 day rsi today is greater than 30

3)close today is greater than close yesterday and close today is greater than the 9 day EMA of closes

4) The EMA of the 50 day volume  is greater than 100,000
StockGuy
Posted : Tuesday, May 12, 2009 11:48:15 PM

Administration

Joined: 9/30/2004
Posts: 9,187
1. RSI14.1.1 < 30
2. RSI14.1 > 30
3. C > C1 and C > XAVGC9
4. XAVGV50 > 1000
amcbride
Posted : Thursday, May 14, 2009 9:22:36 PM
Registered User
Joined: 12/18/2005
Posts: 4
I'm trying to find stocks with a price between $5 and $20 that have an average volume of approx 200,000 shares per day.  I'd also like to have these stocks exibit stochastics that have been low (around 20) and are now starting to turn up as would be shown by a big percentage change to the upside.

     For  price and volume, I can use C > 5 and C < 25 and V1 > 200000         
However, what formula can I use to find those stocks which have the above changes in stochastics?

  Thanks for this and  also the answer to my  last question
Bruce_L
Posted : Friday, May 15, 2009 7:24:46 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
amcbride,
That would depend by what you mean by both "have been low (around 20)" and "big percentage change to the upside."

What are the Stochastic settings?

Understanding Stochastics

- Period: ?
- SK Period: ?
- SD Period: ?
- Average Type: Simple or Exponential?

Are you interested in the SK or SD line?

How long does the Stochastic need to have been low? Is one bar enough?

How close to 20 is "around 20"? Is 25 around 20?

Is the big percentage change to the upside a change in the Stochastic or in Price?

If it is a change in the Stochastic, how high must the Stochastic be or how large must the change be or are you just looking for it to have changed directions and started moving up?

If it is a change in Price, what's a big percentage change? 1%, 5%?

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
amcbride
Posted : Saturday, May 16, 2009 10:52:49 PM
Registered User
Joined: 12/18/2005
Posts: 4
Hi Bruce...In answer to your questions, I'd like to modify my original  statement  in regard to Stochastics.
Basically, I'm looking for the same type of Stochastic that Steve Bigalow uses to find stocks that have been trending down and are now just beginning  to head back up.  He uses a Stochastic of 20, but as the market is probably going to be headed higher in the future, I'd like to find stocks whose Stochastic has fallen below 30 and has now risen 40% from the low.  The length of time spent at the low is not important, and at that point, the SK will be above the SD.
     In-so-far as specifics are concerned, I'd like a 13 day period with an SK of 3 and an SD of 4.  A simple moving average is fine.
     I have one further question and that concerns volume.  I'd like a stock with an average volume of 200,000.  In order to find this do I write 200000 or 2000?  

                                    Thanks      Amcbride
Bruce_L
Posted : Monday, May 18, 2009 11:40:52 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
amcbride,
TeleChart's Volume is reported in blocks of 100 shares, so 200000 shares would be written as 2000.

Let's say you were interested in the SK of a Simple Stochastic 13,3,4 being below 30 sometime in the previous 5-Periods but being at least 40 points above the minimum of the previous 5-Periods currently. A formula for this could be written as follows:

MIN(STOC13.3.1,5) < 30 AND STOC13.3 >= MIN(STOC13.3.1,5) + 40

The 5-Period lookback was chosen arbitrarily, but you would need to have some sort of lookback as it would be nearly impossible for a stock to not to have been below 30 at some point in the past. 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
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
burlap
Posted : Thursday, February 20, 2014 5:33:32 PM
Registered User
Joined: 12/9/2005
Posts: 27

I'm trying to determinethe value of RSI2 for today and yesterday.    My results are:

                            Test              Scale Reading

Today  RSI2.1    25                 31.3

Yesterday

        RSI2.1.1      8.49                 0

 

What have I done wrong or what is wrong. Please advise,   lloyd

 

Bruce_L
Posted : Friday, February 21, 2014 12:26:27 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

You didn't give a symbol, but I'm guessing you have the Use Wilder's Smoothing checked for the RSI being plotted on the chart in TC2000 version 12.4.

The RSI2.1 and RSI2.1.1 syntax is for a Wilder's RSI indicator with the following settings in TC2000 version 7:

- RSI Period: 2
- Use Wilder's Smoothing: Unchecked.
- Avg Period: 1
- Average Type: Doesn't matter (because the Avg Period is 1).

If your Wilder's RSI indicator in TC2000 version 7 has the following settings instead (the only difference being Use Wilder's Smoothing being checked):

- RSI Period: 2
- Use Wilder's Smoothing: Checked.
- Avg Period: 1
- Average Type: Doesn't matter (because the Avg Period is 1).

The Indicator Formula for the current bar would be:

50 * (C - XAVGC3.1) / 2 / (.5000305 * (ABS(C - C1) + .5 * (ABS(C1 - C2) + .5 * (ABS(C2 - C3) + .5 * (ABS(C3 - C4) + .5 * (ABS(C4 - C5) + .5 * (ABS(C5 - C6) + .5 * (ABS(C6 - C7) + .5 * (ABS(C7 - C8) + .5 * (ABS(C8 - C9) + .5 * (ABS(C9 - C10) + .5 * (ABS(C10 - C11) + .5 * (ABS(C11 - C12) + .5 * (ABS(C12 - C13) + .5 * (ABS(C13 - C14)))))))))))))))) + 50

While the Indicator Formula for the previous bar would be:

50 * (C1 - XAVGC3.2) / 2 / (.5000305 * (ABS(C1 - C2) + .5 * (ABS(C2 - C3) + .5 * (ABS(C3 - C4) + .5 * (ABS(C4 - C5) + .5 * (ABS(C5 - C6) + .5 * (ABS(C6 - C7) + .5 * (ABS(C7 - C8) + .5 * (ABS(C8 - C9) + .5 * (ABS(C9 - C10) + .5 * (ABS(C10 - C11) + .5 * (ABS(C11 - C12) + .5 * (ABS(C12 - C13) + .5 * (ABS(C13 - C14) + .5 * (ABS(C14 - C15)))))))))))))))) + 50



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
burlap
Posted : Friday, February 21, 2014 1:29:04 PM
Registered User
Joined: 12/9/2005
Posts: 27

Thanks Bruce. I'm in the middle of something but I will see if thats the problem. lloyd

burlap
Posted : Friday, February 21, 2014 4:28:21 PM
Registered User
Joined: 12/9/2005
Posts: 27

Bruce,

I'm having the same problem.  I'm also unable to find the check to smooth....so that could be the problem.  Using the same formulae as above with AVY on TC2000 v12.4, I get the following:

                   TEST                            Chart

Today          12.5                            10.58

Yesterday    17.65                           44.34

Thanks again, lloyd

Bruce_L
Posted : Friday, February 21, 2014 4:53:03 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

Please edit the RSI indicator in both TC2000 version 7 and TC2000 version 12.4 and list all of the settings in for the charted RSI indicator in both programs.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
burlap
Posted : Friday, February 21, 2014 7:58:36 PM
Registered User
Joined: 12/9/2005
Posts: 27

When I try to  import TC2000v7 I get "Failed to connect".  The edit window I get for RSI in TC2000v4 has the following:

 

Plot style

Plot Color

 

Period

Line Style

Line Width

Plot Opacity

Data Source

Label

There was no place to check "Smooth".

lloyd


 

 

Bruce_L
Posted : Friday, February 21, 2014 8:28:35 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

TC2000 version 12.4 doesn't have a Use Wilder's Smoothing setting like TC2000 version 7. It has two completely different indicators. The response to your similar question in the forum for TC2000 version 12.4 address this.

RSI Problem

The RSI Wilder's indicator with Wilder's smoothing would be labeled Wilder's RSI on the chart.

The plain RSI indicator without Wilder's smoothing would be labeled RSI on the chart.

Your "test" values for are for a plain RSI without Wilder's smoothing and your "chart" values are for a Wilder's smoothed RSI.

I gave the formulas for the 2-period Wilder's smoothed RSI for the current bar and the previous bar above in my Friday, February 21, 2014 12:26:27 PM ET post.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
burlap
Posted : Saturday, February 22, 2014 9:18:08 AM
Registered User
Joined: 12/9/2005
Posts: 27

Thanks Bruce,

Problem solved. lloyd

Bruce_L
Posted : Monday, February 24, 2014 10:29:00 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

You're welcome.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.