One note of clarification on the first request of my previous positing, the closing price would be above the 8 EMA and below the 20 SMA.

Sorry for the oversite

Hi Bruce,

Please help me write a PCF for these 2 situations:

A close between an 8 day Exponentional moving average and a Simple 20 day moving average, using candlestics.

Secondly, a price penetration of a resistance line such as the Upper Bollinger Band but closing below it.

Many thanks for your help

I have been trying to write a Daily  PCF to find stocks where a Spinning Top (preferrably a Doji) opens within 0.010 of a moving average, such as the 20 SMA - with no luck. My Spinnig Top PCF is:

38<=(((C+O)/2)-L)/(H-L)*100 AND (((C+O)/2)-L)/(H-L)*100<=62 AND ABS(C-O)/(H-L)*100<35 AND ABS(O/AVGC20-1)<=.010

I am stuck, any help would be appreciated.

Thanks for your help, Bruce.

Hi Bruce-

I understand you have used both Windows 7 and 8.1. Do you have preference and how strong is your preference?

Many thanks,

Bogeys

Whoops, I forgot to mention that I was wanting a (+) or (-) of 1/2of 1% from the moving average.

Hi Worden,

I would like to create a PCF to ID those stocks opening (+) or (-) of their 1 hour 20 Simple moving average and another for the exponential MA.  As always, I really appreciate your help.

Bruce,

You were right, I had missed the last formula and when I ran it................

VWALLA - It worked exactly like the Scan.

Bruce, I really appreciate your patience with me - I am such a duence with codes.

Being able to sort this will enable me to create just the set up I need.

Many, Many thanks!!!

Bogeys

Bruce,

I copied and saved the new formula, but when I ran it, I received 4 stocks that were not Spinning Tops and the EasyScan returned 7 that were STs.The 4 that were not STs all had the last at the bottom of the range but the open in the middle. Example: NUE: O 40.49 H 40.99 L 39.97 C 40.03

Hi Bruce,

Thanks for your response, I believe you understand the situation very well. To answer your questions:

Yes, the Easy Scan hasThe Body as Center Percent of Shadow is set to between 38 and 62 and The Body as Percent of Shadow is <35

The only formulas I can find for the Easy Scan is from View Conditions on the Chart which are:

((((C+O)/2)-L)/(H-L)*100)  which is different than what you provided

(ABS(C-O)/(H-L)*100  which is the same as you provided

Now that we are getting somewhere, what on earth do I do now?