Hello,

I have been trying to transform a daily scan of a Spinning Top into a sort without any luck so I could use a little help.

The conditions of the scan are: 1) Body as Center Percent of Shadow between 38 and 62.

2) Body of Percent of Shadow < 35.

Many thanks in advance for your help.

Bogeys

I greatly prefer the technique used in the Boolean PCFs for Candlestick Patterns topic to that given in the PCFs and EasyScans for Candlestick Patterns topic for identifying candlestick patterns. Assuming you are using the following Condition Formulas:

Body as % of Candle (between 38 and 62)
ABS(C-O)/(H-L)*100

Body Center as % of Candle (less than 35)
((ABS(C+O)/2)-L)/(H-L)*100

You could create a Condition Formula for this to use as a Sort as:

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

Bruce,

Not having any experience in writing a successful Condition Formula, I was not suprised that this attempt did not work. I received a Formula Error, so I effectively never got to first base. What I have done is write the code just as you wote them, without Body as % of Candle etc. Was that where I went wrong? I notice the tormulas for Body as % have no spaces between the letters and numbers and the Sort Condition Formula does. That was the way I entered the code. Could that be a problem?

Bogeys

None of the three formulas in my Tuesday, October 30, 2012 12:49:33 PM ET post return any error messages whatsoever on my computer. They work both with and without the spaces.

If you are entering only the formulas and not the titles, I do not know what would be causing the error messages. Please contact technical support.

All e-mail communication sent to support@worden.com during business hours (Monday through Friday 9AM-11PM and Saturday and Sunday 9AM-3PM ET) should be answered within 20 minutes of arrival.

For an even quicker response to tech support questions, we recommend calling our voice line at (919) 408-0542 (there is no phone support on Sundays, some Market Holidays or after 9PM ET on weekdays).

You can also contact us using Live Chat Support during business hours.

Bruce,

I got the formula to be acceppted (no errors) but when I put it to work, it did not return any Spinning Tops whereas the scan returned 24 out of 90 from my list. Any suggestions?

Bogeys

The results should be very close when using the same Active WatchList as the List to Scan in your EasyScan unless the formulas being used are not in fact:

Body as % of Candle (between 38 and 62)
ABS(C-O)/(H-L)*100

Body Center as % of Candle (less than 35)
((ABS(C+O)/2)-L)/(H-L)*100

Or the settings in the EasyScan are different than what is specified. What are the exact formulas used, the exact settings for these formulas in the EasyScan and the List to Scan in your EasyScan?

Below is a copy of the formula I have in the sort. I don't know how to find the exact settings and formula used in Easyscan.

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

Bogeys

Bruce:

One problem seems to be that the 100 at the end of the 2nd condition is added the the 38.

How do I seperate them?

I could be misunderstanding, but you appear to have combined two Indicator Formulas and a Condition Formula into the same Personal Criteria Formula. If so, it is meaningless as constructed and should not be used. There should be three different formulas:

ABS(C - O) / (H - L) * 100

Is one of the Indicator Formulas I assumed you were using in your existing Spinning Top EasyScan (with the Rangefinder set to Value: 38 to 62).

((ABS(C + O) / 2) - L) / (H - L) * 100

Is the other Indicator Formula I assumed you were using in your existing Spinning Top EasyScan (with the Rangefinder set to Value: Min to 35).

My understanding of your original question was that you wanted to create a WatchList Column to use as a Sort which returned true for the same list of symbols as were returned by your existing EasyScan. To do so, I suggested created the following Condition Formula to use as a WatchList Column:

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

Note that this is an entirely different formula from the first two. It is already incorporates the first two formulas within it along with checks for the ranges specified for the EasyScan so that it returns true or false instead of returning a numeric value.

This last formula is the only one you need to use as a WatchList Column. My assumption was that you already had the other two formulas created for use in your EasyScan. I gave the formulas I assumed you were using so you could check them against your existing EasyScan to verify that they were in fact the same formulas you were using. If they are not the same formulas, the Condition Formula I provide will not provide the same or similar results as your existing EasyScan.

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?

For most symbols, the extra ABS in my formula versus your formula should not make a difference, but I think the ranges you are using might be reversed from the ranges I originally suggested. Please try creating the following Condition Formula instead and save it:

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

Personal Criteria Formula Conditions

Then add it as a WatchList Column so you can use it as a sort:

Sort with Criteria from the Library

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

I think I may have reversed the ranges in the formula since you last tried it. Please take a look at the most recent version and give it a try. The newest version should have the center of the body within 12% of the center of the range for the entire candle and the body should at most be 35% of the range of the entire candle.

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

You're welcome.