I have a working scan that identifies stocks where the Derivative Oscillator has just turned a corner and is beginning to move up after a descent.

I would really like to have a dot or check mark in a column of my watchlist when these conditions are met. However the scan requires two conditions be met (both with the DO indicator) and I can't figure a way to translate this into a single column.

The two conditions for Derivative OSC are:

Moving Up Smart, Period 1, Slowly (slider all the way to left)

Moving Down Smart, Period 4, Slowly

Any ideas on how to implement this into a single % True style indicator?  Would there be custom code that could do the same thing?

Thanks,

Josh P.

Another reason for having a custom % True indicator would be to place a dot on the price chart as well. This would be very useful I think.

It is not possible to create formulas for the derivative oscillator which are short enough and fast enough to be practical or post in the forums.

A great feature would be the ability to have an EasyScan exist as a column in a watchlist. This would solve the issue of being able to combine multiple criteria into a visual %True indicator in a column.

Another solution would be to have a symbol for Derivative Oscillator in the custom PCF language.

Eg. DO

Thank you for your suggestions.

So basically my workaround is to have 2 columns. One for DO UP and one for DO Down with the parameters as described above. I can sort first by DO Down by clicking on the column header and then by DO Up.  I can then view those that meet the criteria fairly well.

I hope this might help others interested in catching DO signals.

BTW... out on Scribd.com I was able to find Contance Brown's original document for the Technical Marketing Association that describes her use of this indicator and the backtesting that she did.

One final tip is that you can combine this with RSI 5 moving up through the 28 level to get a very powerful buy signal on pullbacks.

This is the formula I'm using for RSI 5 Up Thru 28:

50 * (C - XAVGC9.1) / 5 / (.20001701556587 * (ABS(C - C1) + .8 * (ABS(C1 - C2) + .8 * (ABS(C2 - C3) + .8 * (ABS(C3 - C4) + .8 * (ABS(C4 - C5) + .8 * (ABS(C5 - C6) + .8 * (ABS(C6 - C7) + .8 * (ABS(C7 - C8) + .8 * (ABS(C8 - C9) + .8 * (ABS(C9 - C10) + .8 * (ABS(C10 - C11) + .8 * (ABS(C11 - C12) + .8 * (ABS(C12 - C13) + .8 * (ABS(C13 - C14) + .8 * (ABS(C14 - C15) + .8 * (ABS(C15 - C16) + .8 * (ABS(C16 - C17) + .8 * (ABS(C17 - C18) + .8 * (ABS(C18 - C19) + .8 * (ABS(C19 - C20) + .8 * (ABS(C20 - C21) + .8 * (ABS(C21 - C22) + .8 * (ABS(C22 - C23) + .8 * (ABS(C23 - C24) + .8 * (ABS(C24 - C25) + .8 * (ABS(C25 - C26) + .8 * (ABS(C26 - C27) + .8 * (ABS(C27 - C28) + .8 * (ABS(C28 - C29) + .8 * (ABS(C29 - C30) + .8 * (ABS(C30 - C31) + .8 * (ABS(C31 - C32) + .8 * (ABS(C32 - C33) + .8 * (ABS(C33 - C34) + .8 * (ABS(C34 - C35) + .8 * (ABS(C35 - C36) + .8 * (ABS(C36 - C37) + .8 * (ABS(C37 - C38) + .8 * (ABS(C38 - C39) + .8 * (ABS(C39 - C40) + .8 * (ABS(C40 - C41) + .8 * (ABS(C41 - C42)))))))))))))))))))))))))))))))))))))))))))) + 50 > 28 AND 50 * (C1 - XAVGC9.2) / 5 / (.20001701556587 * (ABS(C1 - C2) + .8 * (ABS(C2 - C3) + .8 * (ABS(C3 - C4) + .8 * (ABS(C4 - C5) + .8 * (ABS(C5 - C6) + .8 * (ABS(C6 - C7) + .8 * (ABS(C7 - C8) + .8 * (ABS(C8 - C9) + .8 * (ABS(C9 - C10) + .8 * (ABS(C10 - C11) + .8 * (ABS(C11 - C12) + .8 * (ABS(C12 - C13) + .8 * (ABS(C13 - C14) + .8 * (ABS(C14 - C15) + .8 * (ABS(C15 - C16) + .8 * (ABS(C16 - C17) + .8 * (ABS(C17 - C18) + .8 * (ABS(C18 - C19) + .8 * (ABS(C19 - C20) + .8 * (ABS(C20 - C21) + .8 * (ABS(C21 - C22) + .8 * (ABS(C22 - C23) + .8 * (ABS(C23 - C24) + .8 * (ABS(C24 - C25) + .8 * (ABS(C25 - C26) + .8 * (ABS(C26 - C27) + .8 * (ABS(C27 - C28) + .8 * (ABS(C28 - C29) + .8 * (ABS(C29 - C30) + .8 * (ABS(C30 - C31) + .8 * (ABS(C31 - C32) + .8 * (ABS(C32 - C33) + .8 * (ABS(C33 - C34) + .8 * (ABS(C34 - C35) + .8 * (ABS(C35 - C36) + .8 * (ABS(C36 - C37) + .8 * (ABS(C37 - C38) + .8 * (ABS(C38 - C39) + .8 * (ABS(C39 - C40) + .8 * (ABS(C40 - C41) + .8 * (ABS(C41 - C42) + .8 * (ABS(C42 - C43)))))))))))))))))))))))))))))))))))))))))))) + 50 <= 28

I would certainly like two see two additional conditions added to the list of factors affecting scans.

1. The indicator is at a maximum.

2. The indicator is at a minimum.

This would be very usefull for a number of indicators.

There is already a way to do this. If you click on an indicator in TC2000 version 12.4 and select Create Scan Condition, the New High and New Low options will check for the value being at the high or low over the period instead of being above the previous high or below the previous low over the period.

Create Conditions from Your Chart

Thank you.

I never cease to amaze myself with the number of things I overlook.

Telework

You should be able to create an up scan with the DO.

Then with an offset moving average of 1 create the down  condition.

If the watchlist you are using cant be marked but has other indicators

you need.

You can save a column template then attach those columns to your DO scan.

Basically creating a floating window copy of your watchlist with the DO criteria true.

Thanks

diceman.... I appreciate the input. However, I don't really understand any of the numerous statements you have made.

Can you please clarify with a set of specific instructions?

The first question would be is a floating window scan ok for what youre doing?

Click the DO indicator name.

Click Create Scan Condition.

Click Scan in new window(settings dont matter its just to show you)

A watchlist should pop open that meets the conditions of the scan.

End of day this may be ok but something live on 1 minute charts it may get in your way.

It depends what youre doing.

If thats ok you can create a scan for the DO turning up.

Condition one will be the DO itself with your smart up conditions.

For condition two you will apply a 1 period simple moving average to the DO

and set the offset to -1.

This will basically be the DO 1 bar ago.

You can now apply the smart down conditions to the moving average.

Together they will say the DO was going down a bar ago but now has turned up.

Now the scan will not have the same columns as your watchlist.

If you need it to look the same you can save the columns by name and

attach them to the DO scan.

After the scan is created you will be able to delete the moving average you applied to the DO.

Let me know if its making sense.

Thanks

As a result of the last post I was able to figure out how to have a single watchlist column with a check mark showing when DO is turning up. You actually have to create a simple moving average of DO with a positive offset and then create a scan condition where the moving average is crossing down through DO.

In this case an offset of +3 was the magic number that worked (2 and 4 both missed a lot of results).

Create a simple moving average of DO with an offset of +3. Create a scan condition with "Crossing down Derivative Oscillator".  Then select to add to an existing Watchlist or Scan. Select the Wathlist to add it to and adjust the column settings as needed.

Brilliant!  Thank you diceman!

Whoops.

Yes the average should be moved forward.

I have many in the past scans and all are moved forward but for some reason I said -1.

Ive even used the technique you described of crossing itself shifted in time.

Glad to hear you got it working.

Thanks