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 |

Price History crossing up thru moving average of price history Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
tomferd
Posted : Wednesday, February 18, 2009 4:39:53 PM
Registered User
Joined: 10/22/2007
Posts: 47

I created a rule in the "add rule" button to have an indication on the chart on the day that the pricd history crosses up thru the moving average...in this case 25 days on the daily chart. I get an indication on probably 80 to 90% of the crossovers, but not all. For example, if the price history opens below the 25 day moving average, but crosses up thru it on that day, and closes above the 25 day moving average, I get an indication most of the time but not all the time. Hence, in using the back scanner to find possible trades, it misses those opportunities. I see candles looking identical, which DO have positive indication, but why not all?

Thanks in advance from Tom Ferderbar

Bruce_L
Posted : Wednesday, February 18, 2009 4:56:05 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
I cannot find any examples of this when the xUp Rule is set to True 1 of 1 Bars and the Rangefinder is dragged all the way to the top (set to crossing). Please provide the exact Moving Average settings (Average Type and Offset in addition to the already provided MovAvg Period) and some example symbols where this occurs so we can attempt to troubleshoot the issue.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
tomferd
Posted : Thursday, February 19, 2009 11:28:15 AM
Registered User
Joined: 10/22/2007
Posts: 47
On a daily chart for WPI (Watson Pharmaceuticals) I have the Simple Moving Average set to 25, slider all the way up, "Crossing Up through MovAvg (CROSSING), True 1 of 1 Bars". The chart shows positive for January 22, 2009 but not for Jan 23, which also crossed up thru the 25 day moving average. It also misses December 12, 2008. 

Thanks again for your help. 

Tom Ferderbar
Bruce_L
Posted : Thursday, February 19, 2009 11:59:06 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
I think I understand what you see as a cross-up now (Open to Close during a single Bar). StockFinder (and most technical chartist) look at the Close of the previous Bar and the Close of the current Bar when determining if a cross-up occurred however. If you change the Plot Style of the Price History to Line, you will see the data that is being used for this determination.

You could create a RealCode Rule to search for the type of cross-up you are describing however.

Static AvgC25 As Single
If isFirstBar Then AvgC25 = 0
AvgC25 += Price.Last / 25
If CurrentIndex >= 25 Then AvgC25 -= Price.Last(25) / 25
If CurrentIndex >= 24 Then
    If Price.Last > AvgC25 AndAlso AvgC25 > Price.Open Then Pass
Else
    SetIndexInvalid
End If

The above RealCode Rule creates the 25-Period Simple Moving Average manually, but you could also Drag and Drop the Moving Average into the RealCode Editor to use the Plot instead.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
tomferd
Posted : Thursday, February 19, 2009 1:34:07 PM
Registered User
Joined: 10/22/2007
Posts: 47
Hi Bruce,

Thank you very much for yur help. I now understand the parameters of  the crossing up. I'll try using Real Code, just for laughs (or practice!)

Tom
Bruce_L
Posted : Thursday, February 19, 2009 1:36:11 PM


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.