Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Average % increase from Open to Close over the last 60 days. Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
brandy05
Posted : Thursday, August 11, 2005 11:56:01 PM
Registered User
Joined: 6/21/2005
Posts: 10
I would like to scan for a list of stocks that do the following:

1. The close is from .15 to .30 higher than the open (todays Close-todays Open)

The scan would provide a list of stocks in descending order that do this the highest percentage of the time over the last 60 days.

For example:

1. XYZ .19 39 %
2. ABCD .29 22 %

XYZ averages an increase of .19 39% of the time over the last 60 days.

I'm below average in my native ability to write scans or do anything with math, so please be very explicit.

Thanks for your help.
Bruce_L
Posted : Friday, August 12, 2005 6:33:44 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
I would create three Personal Criteria Formulas to use as Sorts along with three WatchList Columns to display the results. You will be able to sort any WatchList by the any of the three columns in both ascending and descending order and see the results of all three PCFs. You should be able to Copy and Paste the following formulas into TeleChart when creating the PCFs:

C-O=.15-.30 as %:

5*((C-O>.14)*(C-O<.31) +(C1-O1>.14)*(C1-O1<.31) +(C2-O2>.14)*(C2-O2<.31) +(C3-O3>.14)*(C3-O3<.31) +(C4-O4>.14)*(C4-O4<.31) +(C5-O5>.14)*(C5-O5<.31) +(C6-O6>.14)*(C6-O6<.31) +(C7-O7>.14)*(C7-O7<.31) +(C8-O8>.14)*(C8-O8<.31) +(C9-O9>.14)*(C9-O9<.31) +(C10-O10>.14)*(C10-O10<.31) +(C11-O11>.14)*(C11-O11<.31) +(C12-O12>.14)*(C12-O12<.31) +(C13-O13>.14)*(C13-O13<.31) +(C14-O14>.14)*(C14-O14<.31) +(C15-O15>.14)*(C15-O15<.31) +(C16-O16>.14)*(C16-O16<.31) +(C17-O17>.14)*(C17-O17<.31) +(C18-O18>.14)*(C18-O18<.31) +(C19-O19>.14)*(C19-O19<.31) +(C20-O20>.14)*(C20-O20<.31) +(C21-O21>.14)*(C21-O21<.31) +(C22-O22>.14)*(C22-O22<.31) +(C23-O23>.14)*(C23-O23<.31) +(C24-O24>.14)*(C24-O24<.31) +(C25-O25>.14)*(C25-O25<.31) +(C26-O26>.14)*(C26-O26<.31) +(C27-O27>.14)*(C27-O27<.31) +(C28-O28>.14)*(C28-O28<.31) +(C29-O29>.14)*(C29-O29<.31) +(C30-O30>.14)*(C30-O30<.31) +(C31-O31>.14)*(C31-O31<.31) +(C32-O32>.14)*(C32-O32<.31) +(C33-O33>.14)*(C33-O33<.31) +(C34-O34>.14)*(C34-O34<.31) +(C35-O35>.14)*(C35-O35<.31) +(C36-O36>.14)*(C36-O36<.31) +(C37-O37>.14)*(C37-O37<.31) +(C38-O38>.14)*(C38-O38<.31) +(C39-O39>.14)*(C39-O39<.31) +(C40-O40>.14)*(C40-O40<.31) +(C41-O41>.14)*(C41-O41<.31) +(C42-O42>.14)*(C42-O42<.31) +(C43-O43>.14)*(C43-O43<.31) +(C44-O44>.14)*(C44-O44<.31) +(C45-O45>.14)*(C45-O45<.31) +(C46-O46>.14)*(C46-O46<.31) +(C47-O47>.14)*(C47-O47<.31) +(C48-O48>.14)*(C48-O48<.31) +(C49-O49>.14)*(C49-O49<.31) +(C50-O50>.14)*(C50-O50<.31) +(C51-O51>.14)*(C51-O51<.31) +(C52-O52>.14)*(C52-O52<.31) +(C53-O53>.14)*(C53-O53<.31) +(C54-O54>.14)*(C54-O54<.31) +(C55-O55>.14)*(C55-O55<.31) +(C56-O56>.14)*(C56-O56<.31) +(C57-O57>.14)*(C57-O57<.31) +(C58-O58>.14)*(C58-O58<.31) +(C59-O59>.14)*(C59-O59<.31))/3

AvgC-O when C-O=.15-.30:

((C-O>.14)*(C-O<.31)*(C-O) +(C1-O1>.14)*(C1-O1<.31)*(C1-O1) +(C2-O2>.14)*(C2-O2<.31)*(C2-O2) +(C3-O3>.14)*(C3-O3<.31)*(C3-O3) +(C4-O4>.14)*(C4-O4<.31)*(C4-O4) +(C5-O5>.14)*(C5-O5<.31)*(C5-O5) +(C6-O6>.14)*(C6-O6<.31)*(C6-O6) +(C7-O7>.14)*(C7-O7<.31)*(C7-O7) +(C8-O8>.14)*(C8-O8<.31)*(C8-O8) +(C9-O9>.14)*(C9-O9<.31)*(C9-O9) +(C10-O10>.14)*(C10-O10<.31)*(C10-O10) +(C11-O11>.14)*(C11-O11<.31)*(C11-O11) +(C12-O12>.14)*(C12-O12<.31)*(C12-O12) +(C13-O13>.14)*(C13-O13<.31)*(C13-O13) +(C14-O14>.14)*(C14-O14<.31)*(C14-O14) +(C15-O15>.14)*(C15-O15<.31)*(C15-O15) +(C16-O16>.14)*(C16-O16<.31)*(C16-O16) +(C17-O17>.14)*(C17-O17<.31)*(C17-O17) +(C18-O18>.14)*(C18-O18<.31)*(C18-O18) +(C19-O19>.14)*(C19-O19<.31)*(C19-O19) +(C20-O20>.14)*(C20-O20<.31)*(C20-O20) +(C21-O21>.14)*(C21-O21<.31)*(C21-O21) +(C22-O22>.14)*(C22-O22<.31)*(C22-O22) +(C23-O23>.14)*(C23-O23<.31)*(C23-O23) +(C24-O24>.14)*(C24-O24<.31)*(C24-O24) +(C25-O25>.14)*(C25-O25<.31)*(C25-O25) +(C26-O26>.14)*(C26-O26<.31)*(C26-O26) +(C27-O27>.14)*(C27-O27<.31)*(C27-O27) +(C28-O28>.14)*(C28-O28<.31)*(C28-O28) +(C29-O29>.14)*(C29-O29<.31)*(C29-O29) +(C30-O30>.14)*(C30-O30<.31)*(C30-O30) +(C31-O31>.14)*(C31-O31<.31)*(C31-O31) +(C32-O32>.14)*(C32-O32<.31)*(C32-O32) +(C33-O33>.14)*(C33-O33<.31)*(C33-O33) +(C34-O34>.14)*(C34-O34<.31)*(C34-O34) +(C35-O35>.14)*(C35-O35<.31)*(C35-O35) +(C36-O36>.14)*(C36-O36<.31)*(C36-O36) +(C37-O37>.14)*(C37-O37<.31)*(C37-O37) +(C38-O38>.14)*(C38-O38<.31)*(C38-O38) +(C39-O39>.14)*(C39-O39<.31)*(C39-O39) +(C40-O40>.14)*(C40-O40<.31)*(C40-O40) +(C41-O41>.14)*(C41-O41<.31)*(C41-O41) +(C42-O42>.14)*(C42-O42<.31)*(C42-O42) +(C43-O43>.14)*(C43-O43<.31)*(C43-O43) +(C44-O44>.14)*(C44-O44<.31)*(C44-O44) +(C45-O45>.14)*(C45-O45<.31)*(C45-O45) +(C46-O46>.14)*(C46-O46<.31)*(C46-O46) +(C47-O47>.14)*(C47-O47<.31)*(C47-O47) +(C48-O48>.14)*(C48-O48<.31)*(C48-O48) +(C49-O49>.14)*(C49-O49<.31)*(C49-O49) +(C50-O50>.14)*(C50-O50<.31)*(C50-O50) +(C51-O51>.14)*(C51-O51<.31)*(C51-O51) +(C52-O52>.14)*(C52-O52<.31)*(C52-O52) +(C53-O53>.14)*(C53-O53<.31)*(C53-O53) +(C54-O54>.14)*(C54-O54<.31)*(C54-O54) +(C55-O55>.14)*(C55-O55<.31)*(C55-O55) +(C56-O56>.14)*(C56-O56<.31)*(C56-O56) +(C57-O57>.14)*(C57-O57<.31)*(C57-O57) +(C58-O58>.14)*(C58-O58<.31)*(C58-O58) +(C59-O59>.14)*(C59-O59<.31)*(C59-O59)) /((C-O>.14)*(C-O<.31) +(C1-O1>.14)*(C1-O1<.31) +(C2-O2>.14)*(C2-O2<.31) +(C3-O3>.14)*(C3-O3<.31) +(C4-O4>.14)*(C4-O4<.31) +(C5-O5>.14)*(C5-O5<.31) +(C6-O6>.14)*(C6-O6<.31) +(C7-O7>.14)*(C7-O7<.31) +(C8-O8>.14)*(C8-O8<.31) +(C9-O9>.14)*(C9-O9<.31) +(C10-O10>.14)*(C10-O10<.31) +(C11-O11>.14)*(C11-O11<.31) +(C12-O12>.14)*(C12-O12<.31) +(C13-O13>.14)*(C13-O13<.31) +(C14-O14>.14)*(C14-O14<.31) +(C15-O15>.14)*(C15-O15<.31) +(C16-O16>.14)*(C16-O16<.31) +(C17-O17>.14)*(C17-O17<.31) +(C18-O18>.14)*(C18-O18<.31) +(C19-O19>.14)*(C19-O19<.31) +(C20-O20>.14)*(C20-O20<.31) +(C21-O21>.14)*(C21-O21<.31) +(C22-O22>.14)*(C22-O22<.31) +(C23-O23>.14)*(C23-O23<.31) +(C24-O24>.14)*(C24-O24<.31) +(C25-O25>.14)*(C25-O25<.31) +(C26-O26>.14)*(C26-O26<.31) +(C27-O27>.14)*(C27-O27<.31) +(C28-O28>.14)*(C28-O28<.31) +(C29-O29>.14)*(C29-O29<.31) +(C30-O30>.14)*(C30-O30<.31) +(C31-O31>.14)*(C31-O31<.31) +(C32-O32>.14)*(C32-O32<.31) +(C33-O33>.14)*(C33-O33<.31) +(C34-O34>.14)*(C34-O34<.31) +(C35-O35>.14)*(C35-O35<.31) +(C36-O36>.14)*(C36-O36<.31) +(C37-O37>.14)*(C37-O37<.31) +(C38-O38>.14)*(C38-O38<.31) +(C39-O39>.14)*(C39-O39<.31) +(C40-O40>.14)*(C40-O40<.31) +(C41-O41>.14)*(C41-O41<.31) +(C42-O42>.14)*(C42-O42<.31) +(C43-O43>.14)*(C43-O43<.31) +(C44-O44>.14)*(C44-O44<.31) +(C45-O45>.14)*(C45-O45<.31) +(C46-O46>.14)*(C46-O46<.31) +(C47-O47>.14)*(C47-O47<.31) +(C48-O48>.14)*(C48-O48<.31) +(C49-O49>.14)*(C49-O49<.31) +(C50-O50>.14)*(C50-O50<.31) +(C51-O51>.14)*(C51-O51<.31) +(C52-O52>.14)*(C52-O52<.31) +(C53-O53>.14)*(C53-O53<.31) +(C54-O54>.14)*(C54-O54<.31) +(C55-O55>.14)*(C55-O55<.31) +(C56-O56>.14)*(C56-O56<.31) +(C57-O57>.14)*(C57-O57<.31) +(C58-O58>.14)*(C58-O58<.31) +(C59-O59>.14)*(C59-O59<.31))

You didn't ask for it, but the third formula is the result of multiplying the first two:

((C-O>.14)*(C-O<.31)*(C-O) +(C1-O1>.14)*(C1-O1<.31)*(C1-O1) +(C2-O2>.14)*(C2-O2<.31)*(C2-O2) +(C3-O3>.14)*(C3-O3<.31)*(C3-O3) +(C4-O4>.14)*(C4-O4<.31)*(C4-O4) +(C5-O5>.14)*(C5-O5<.31)*(C5-O5) +(C6-O6>.14)*(C6-O6<.31)*(C6-O6) +(C7-O7>.14)*(C7-O7<.31)*(C7-O7) +(C8-O8>.14)*(C8-O8<.31)*(C8-O8) +(C9-O9>.14)*(C9-O9<.31)*(C9-O9) +(C10-O10>.14)*(C10-O10<.31)*(C10-O10) +(C11-O11>.14)*(C11-O11<.31)*(C11-O11) +(C12-O12>.14)*(C12-O12<.31)*(C12-O12) +(C13-O13>.14)*(C13-O13<.31)*(C13-O13) +(C14-O14>.14)*(C14-O14<.31)*(C14-O14) +(C15-O15>.14)*(C15-O15<.31)*(C15-O15) +(C16-O16>.14)*(C16-O16<.31)*(C16-O16) +(C17-O17>.14)*(C17-O17<.31)*(C17-O17) +(C18-O18>.14)*(C18-O18<.31)*(C18-O18) +(C19-O19>.14)*(C19-O19<.31)*(C19-O19) +(C20-O20>.14)*(C20-O20<.31)*(C20-O20) +(C21-O21>.14)*(C21-O21<.31)*(C21-O21) +(C22-O22>.14)*(C22-O22<.31)*(C22-O22) +(C23-O23>.14)*(C23-O23<.31)*(C23-O23) +(C24-O24>.14)*(C24-O24<.31)*(C24-O24) +(C25-O25>.14)*(C25-O25<.31)*(C25-O25) +(C26-O26>.14)*(C26-O26<.31)*(C26-O26) +(C27-O27>.14)*(C27-O27<.31)*(C27-O27) +(C28-O28>.14)*(C28-O28<.31)*(C28-O28) +(C29-O29>.14)*(C29-O29<.31)*(C29-O29) +(C30-O30>.14)*(C30-O30<.31)*(C30-O30) +(C31-O31>.14)*(C31-O31<.31)*(C31-O31) +(C32-O32>.14)*(C32-O32<.31)*(C32-O32) +(C33-O33>.14)*(C33-O33<.31)*(C33-O33) +(C34-O34>.14)*(C34-O34<.31)*(C34-O34) +(C35-O35>.14)*(C35-O35<.31)*(C35-O35) +(C36-O36>.14)*(C36-O36<.31)*(C36-O36) +(C37-O37>.14)*(C37-O37<.31)*(C37-O37) +(C38-O38>.14)*(C38-O38<.31)*(C38-O38) +(C39-O39>.14)*(C39-O39<.31)*(C39-O39) +(C40-O40>.14)*(C40-O40<.31)*(C40-O40) +(C41-O41>.14)*(C41-O41<.31)*(C41-O41) +(C42-O42>.14)*(C42-O42<.31)*(C42-O42) +(C43-O43>.14)*(C43-O43<.31)*(C43-O43) +(C44-O44>.14)*(C44-O44<.31)*(C44-O44) +(C45-O45>.14)*(C45-O45<.31)*(C45-O45) +(C46-O46>.14)*(C46-O46<.31)*(C46-O46) +(C47-O47>.14)*(C47-O47<.31)*(C47-O47) +(C48-O48>.14)*(C48-O48<.31)*(C48-O48) +(C49-O49>.14)*(C49-O49<.31)*(C49-O49) +(C50-O50>.14)*(C50-O50<.31)*(C50-O50) +(C51-O51>.14)*(C51-O51<.31)*(C51-O51) +(C52-O52>.14)*(C52-O52<.31)*(C52-O52) +(C53-O53>.14)*(C53-O53<.31)*(C53-O53) +(C54-O54>.14)*(C54-O54<.31)*(C54-O54) +(C55-O55>.14)*(C55-O55<.31)*(C55-O55) +(C56-O56>.14)*(C56-O56<.31)*(C56-O56) +(C57-O57>.14)*(C57-O57<.31)*(C57-O57) +(C58-O58>.14)*(C58-O58<.31)*(C58-O58) +(C59-O59>.14)*(C59-O59<.31)*(C59-O59))/60

You will probably want to watch the following videos before setting this up:

How to create a Personal Criteria Forumula (PCF)
Customize the Information Displayed in the WatchList
Create your own stock rankings using WatchLists and Sort conditions

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
brandy05
Posted : Friday, August 12, 2005 3:00:15 PM
Registered User
Joined: 6/21/2005
Posts: 10
Bruce,

Thanks for everything. This is wonderful.

I hope you can make a modification, if so, here it is:

Find only those stocks with a maximum range (close-open) of .60. This will eliminate those stocks have bigger moves than .61.

thanks again
Bruce_L
Posted : Friday, August 12, 2005 3:11:11 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
I'm not sure I understand your request. The above formulas have three parameters: a minimum acceptable value for Close minus Open on each day (.15), a maximum acceptable value for Close minus Open on each day (.30) and a number of days to test (60).

Do you want to test for a daily changes over the same 60 day period?
Do you want to test for a daily change of .01 to .60?
Do you want to test for a daily change of -.60 to +.60?
Do you want something else entirely?

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
brandy05
Posted : Friday, August 12, 2005 4:49:43 PM
Registered User
Joined: 6/21/2005
Posts: 10
Bruce,

Sorry for the confusion--

You said:

The above formulas have three parameters: a minimum acceptable value for Close minus Open on each day (.15), a maximum acceptable value for Close minus Open on each day (.30) and a number of days to test (60).

This is correct, however, I would like to add an additional parameter, that is:

I would like to limit the universe of stocks for the above parameters to those stocks that had a maximum range (close-open) for the day of .60---but they ended up with a profit of .15 to .30 for the day after the market closed.

If this is still not clear enough for you to act on I will provide a more complete explanation.

Thanks for your patience.
Bruce_L
Posted : Friday, August 12, 2005 5:25:14 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
I think the phrase 'maximum range (close-open)' was confusing me (and maybe is still). These formulas should be the same as the first with the added condition that range (High-Low) is .60 or less.

C-O=.15-.30 & H-L<=.60 as %:

5*((C-O>.14)*(C-O<.31)*(H-L<.61) +(C1-O1>.14)*(C1-O1<.31)*(H1-L1<.61) +(C2-O2>.14)*(C2-O2<.31)*(H2-L2<.61) +(C3-O3>.14)*(C3-O3<.31)*(H3-L3<.61) +(C4-O4>.14)*(C4-O4<.31)*(H4-L4<.61) +(C5-O5>.14)*(C5-O5<.31)*(H5-L5<.61) +(C6-O6>.14)*(C6-O6<.31)*(H6-L6<.61) +(C7-O7>.14)*(C7-O7<.31)*(H7-L7<.61) +(C8-O8>.14)*(C8-O8<.31)*(H8-L8<.61) +(C9-O9>.14)*(C9-O9<.31)*(H9-L9<.61) +(C10-O10>.14)*(C10-O10<.31)*(H10-L10<.61) +(C11-O11>.14)*(C11-O11<.31)*(H11-L11<.61) +(C12-O12>.14)*(C12-O12<.31)*(H12-L12<.61) +(C13-O13>.14)*(C13-O13<.31)*(H13-L13<.61) +(C14-O14>.14)*(C14-O14<.31)*(H14-L14<.61) +(C15-O15>.14)*(C15-O15<.31)*(H15-L15<.61) +(C16-O16>.14)*(C16-O16<.31)*(H16-L16<.61) +(C17-O17>.14)*(C17-O17<.31)*(H17-L17<.61) +(C18-O18>.14)*(C18-O18<.31)*(H18-L18<.61) +(C19-O19>.14)*(C19-O19<.31)*(H19-L19<.61) +(C20-O20>.14)*(C20-O20<.31)*(H20-L20<.61) +(C21-O21>.14)*(C21-O21<.31)*(H21-L21<.61) +(C22-O22>.14)*(C22-O22<.31)*(H22-L22<.61) +(C23-O23>.14)*(C23-O23<.31)*(H23-L23<.61) +(C24-O24>.14)*(C24-O24<.31)*(H24-L24<.61) +(C25-O25>.14)*(C25-O25<.31)*(H25-L25<.61) +(C26-O26>.14)*(C26-O26<.31)*(H26-L26<.61) +(C27-O27>.14)*(C27-O27<.31)*(H27-L27<.61) +(C28-O28>.14)*(C28-O28<.31)*(H28-L28<.61) +(C29-O29>.14)*(C29-O29<.31)*(H29-L29<.61) +(C30-O30>.14)*(C30-O30<.31)*(H30-L30<.61) +(C31-O31>.14)*(C31-O31<.31)*(H31-L31<.61) +(C32-O32>.14)*(C32-O32<.31)*(H32-L32<.61) +(C33-O33>.14)*(C33-O33<.31)*(H33-L33<.61) +(C34-O34>.14)*(C34-O34<.31)*(H34-L34<.61) +(C35-O35>.14)*(C35-O35<.31)*(H35-L35<.61) +(C36-O36>.14)*(C36-O36<.31)*(H36-L36<.61) +(C37-O37>.14)*(C37-O37<.31)*(H37-L37<.61) +(C38-O38>.14)*(C38-O38<.31)*(H38-L38<.61) +(C39-O39>.14)*(C39-O39<.31)*(H39-L39<.61) +(C40-O40>.14)*(C40-O40<.31)*(H40-L40<.61) +(C41-O41>.14)*(C41-O41<.31)*(H41-L41<.61) +(C42-O42>.14)*(C42-O42<.31)*(H42-L42<.61) +(C43-O43>.14)*(C43-O43<.31)*(H43-L43<.61) +(C44-O44>.14)*(C44-O44<.31)*(H44-L44<.61) +(C45-O45>.14)*(C45-O45<.31)*(H45-L45<.61) +(C46-O46>.14)*(C46-O46<.31)*(H46-L46<.61) +(C47-O47>.14)*(C47-O47<.31)*(H47-L47<.61) +(C48-O48>.14)*(C48-O48<.31)*(H48-L48<.61) +(C49-O49>.14)*(C49-O49<.31)*(H49-L49<.61) +(C50-O50>.14)*(C50-O50<.31)*(H50-L50<.61) +(C51-O51>.14)*(C51-O51<.31)*(H51-L51<.61) +(C52-O52>.14)*(C52-O52<.31)*(H52-L52<.61) +(C53-O53>.14)*(C53-O53<.31)*(H53-L53<.61) +(C54-O54>.14)*(C54-O54<.31)*(H54-L54<.61) +(C55-O55>.14)*(C55-O55<.31)*(H55-L55<.61) +(C56-O56>.14)*(C56-O56<.31)*(H56-L56<.61) +(C57-O57>.14)*(C57-O57<.31)*(H57-L57<.61) +(C58-O58>.14)*(C58-O58<.31)*(H58-L58<.61) +(C59-O59>.14)*(C59-O59<.31)*(H59-L59<.61))/(-3)

AvgC-O when C-O=.15-.30 & H-L<=.60:

((C-O>.14)*(C-O<.31)*(H-L<.61)*(C-O) +(C1-O1>.14)*(C1-O1<.31)*(H1-L1<.61)*(C1-O1) +(C2-O2>.14)*(C2-O2<.31)*(H2-L2<.61)*(C2-O2) +(C3-O3>.14)*(C3-O3<.31)*(H3-L3<.61)*(C3-O3) +(C4-O4>.14)*(C4-O4<.31)*(H4-L4<.61)*(C4-O4) +(C5-O5>.14)*(C5-O5<.31)*(H5-L5<.61)*(C5-O5) +(C6-O6>.14)*(C6-O6<.31)*(H6-L6<.61)*(C6-O6) +(C7-O7>.14)*(C7-O7<.31)*(H7-L7<.61)*(C7-O7) +(C8-O8>.14)*(C8-O8<.31)*(H8-L8<.61)*(C8-O8) +(C9-O9>.14)*(C9-O9<.31)*(H9-L9<.61)*(C9-O9) +(C10-O10>.14)*(C10-O10<.31)*(H10-L10<.61)*(C10-O10) +(C11-O11>.14)*(C11-O11<.31)*(H11-L11<.61)*(C11-O11) +(C12-O12>.14)*(C12-O12<.31)*(H12-L12<.61)*(C12-O12) +(C13-O13>.14)*(C13-O13<.31)*(H13-L13<.61)*(C13-O13) +(C14-O14>.14)*(C14-O14<.31)*(H14-L14<.61)*(C14-O14) +(C15-O15>.14)*(C15-O15<.31)*(H15-L15<.61)*(C15-O15) +(C16-O16>.14)*(C16-O16<.31)*(H16-L16<.61)*(C16-O16) +(C17-O17>.14)*(C17-O17<.31)*(H17-L17<.61)*(C17-O17) +(C18-O18>.14)*(C18-O18<.31)*(H18-L18<.61)*(C18-O18) +(C19-O19>.14)*(C19-O19<.31)*(H19-L19<.61)*(C19-O19) +(C20-O20>.14)*(C20-O20<.31)*(H20-L20<.61)*(C20-O20) +(C21-O21>.14)*(C21-O21<.31)*(H21-L21<.61)*(C21-O21) +(C22-O22>.14)*(C22-O22<.31)*(H22-L22<.61)*(C22-O22) +(C23-O23>.14)*(C23-O23<.31)*(H23-L23<.61)*(C23-O23) +(C24-O24>.14)*(C24-O24<.31)*(H24-L24<.61)*(C24-O24) +(C25-O25>.14)*(C25-O25<.31)*(H25-L25<.61)*(C25-O25) +(C26-O26>.14)*(C26-O26<.31)*(H26-L26<.61)*(C26-O26) +(C27-O27>.14)*(C27-O27<.31)*(H27-L27<.61)*(C27-O27) +(C28-O28>.14)*(C28-O28<.31)*(H28-L28<.61)*(C28-O28) +(C29-O29>.14)*(C29-O29<.31)*(H29-L29<.61)*(C29-O29) +(C30-O30>.14)*(C30-O30<.31)*(H30-L30<.61)*(C30-O30) +(C31-O31>.14)*(C31-O31<.31)*(H31-L31<.61)*(C31-O31) +(C32-O32>.14)*(C32-O32<.31)*(H32-L32<.61)*(C32-O32) +(C33-O33>.14)*(C33-O33<.31)*(H33-L33<.61)*(C33-O33) +(C34-O34>.14)*(C34-O34<.31)*(H34-L34<.61)*(C34-O34) +(C35-O35>.14)*(C35-O35<.31)*(H35-L35<.61)*(C35-O35) +(C36-O36>.14)*(C36-O36<.31)*(H36-L36<.61)*(C36-O36) +(C37-O37>.14)*(C37-O37<.31)*(H37-L37<.61)*(C37-O37) +(C38-O38>.14)*(C38-O38<.31)*(H38-L38<.61)*(C38-O38) +(C39-O39>.14)*(C39-O39<.31)*(H39-L39<.61)*(C39-O39) +(C40-O40>.14)*(C40-O40<.31)*(H40-L40<.61)*(C40-O40) +(C41-O41>.14)*(C41-O41<.31)*(H41-L41<.61)*(C41-O41) +(C42-O42>.14)*(C42-O42<.31)*(H42-L42<.61)*(C42-O42) +(C43-O43>.14)*(C43-O43<.31)*(H43-L43<.61)*(C43-O43) +(C44-O44>.14)*(C44-O44<.31)*(H44-L44<.61)*(C44-O44) +(C45-O45>.14)*(C45-O45<.31)*(H45-L45<.61)*(C45-O45) +(C46-O46>.14)*(C46-O46<.31)*(H46-L46<.61)*(C46-O46) +(C47-O47>.14)*(C47-O47<.31)*(H47-L47<.61)*(C47-O47) +(C48-O48>.14)*(C48-O48<.31)*(H48-L48<.61)*(C48-O48) +(C49-O49>.14)*(C49-O49<.31)*(H49-L49<.61)*(C49-O49) +(C50-O50>.14)*(C50-O50<.31)*(H50-L50<.61)*(C50-O50) +(C51-O51>.14)*(C51-O51<.31)*(H51-L51<.61)*(C51-O51) +(C52-O52>.14)*(C52-O52<.31)*(H52-L52<.61)*(C52-O52) +(C53-O53>.14)*(C53-O53<.31)*(H53-L53<.61)*(C53-O53) +(C54-O54>.14)*(C54-O54<.31)*(H54-L54<.61)*(C54-O54) +(C55-O55>.14)*(C55-O55<.31)*(H55-L55<.61)*(C55-O55) +(C56-O56>.14)*(C56-O56<.31)*(H56-L56<.61)*(C56-O56) +(C57-O57>.14)*(C57-O57<.31)*(H57-L57<.61)*(C57-O57) +(C58-O58>.14)*(C58-O58<.31)*(H58-L58<.61)*(C58-O58) +(C59-O59>.14)*(C59-O59<.31)*(H59-L59<.61)*(C59-O59)) /((C-O>.14)*(C-O<.31)*(H-L<.61) +(C1-O1>.14)*(C1-O1<.31)*(H1-L1<.61) +(C2-O2>.14)*(C2-O2<.31)*(H2-L2<.61) +(C3-O3>.14)*(C3-O3<.31)*(H3-L3<.61) +(C4-O4>.14)*(C4-O4<.31)*(H4-L4<.61) +(C5-O5>.14)*(C5-O5<.31)*(H5-L5<.61) +(C6-O6>.14)*(C6-O6<.31)*(H6-L6<.61) +(C7-O7>.14)*(C7-O7<.31)*(H7-L7<.61) +(C8-O8>.14)*(C8-O8<.31)*(H8-L8<.61) +(C9-O9>.14)*(C9-O9<.31)*(H9-L9<.61) +(C10-O10>.14)*(C10-O10<.31)*(H10-L10<.61) +(C11-O11>.14)*(C11-O11<.31)*(H11-L11<.61) +(C12-O12>.14)*(C12-O12<.31)*(H12-L12<.61) +(C13-O13>.14)*(C13-O13<.31)*(H13-L13<.61) +(C14-O14>.14)*(C14-O14<.31)*(H14-L14<.61) +(C15-O15>.14)*(C15-O15<.31)*(H15-L15<.61) +(C16-O16>.14)*(C16-O16<.31)*(H16-L16<.61) +(C17-O17>.14)*(C17-O17<.31)*(H17-L17<.61) +(C18-O18>.14)*(C18-O18<.31)*(H18-L18<.61) +(C19-O19>.14)*(C19-O19<.31)*(H19-L19<.61) +(C20-O20>.14)*(C20-O20<.31)*(H20-L20<.61) +(C21-O21>.14)*(C21-O21<.31)*(H21-L21<.61) +(C22-O22>.14)*(C22-O22<.31)*(H22-L22<.61) +(C23-O23>.14)*(C23-O23<.31)*(H23-L23<.61) +(C24-O24>.14)*(C24-O24<.31)*(H24-L24<.61) +(C25-O25>.14)*(C25-O25<.31)*(H25-L25<.61) +(C26-O26>.14)*(C26-O26<.31)*(H26-L26<.61) +(C27-O27>.14)*(C27-O27<.31)*(H27-L27<.61) +(C28-O28>.14)*(C28-O28<.31)*(H28-L28<.61) +(C29-O29>.14)*(C29-O29<.31)*(H29-L29<.61) +(C30-O30>.14)*(C30-O30<.31)*(H30-L30<.61) +(C31-O31>.14)*(C31-O31<.31)*(H31-L31<.61) +(C32-O32>.14)*(C32-O32<.31)*(H32-L32<.61) +(C33-O33>.14)*(C33-O33<.31)*(H33-L33<.61) +(C34-O34>.14)*(C34-O34<.31)*(H34-L34<.61) +(C35-O35>.14)*(C35-O35<.31)*(H35-L35<.61) +(C36-O36>.14)*(C36-O36<.31)*(H36-L36<.61) +(C37-O37>.14)*(C37-O37<.31)*(H37-L37<.61) +(C38-O38>.14)*(C38-O38<.31)*(H38-L38<.61) +(C39-O39>.14)*(C39-O39<.31)*(H39-L39<.61) +(C40-O40>.14)*(C40-O40<.31)*(H40-L40<.61) +(C41-O41>.14)*(C41-O41<.31)*(H41-L41<.61) +(C42-O42>.14)*(C42-O42<.31)*(H42-L42<.61) +(C43-O43>.14)*(C43-O43<.31)*(H43-L43<.61) +(C44-O44>.14)*(C44-O44<.31)*(H44-L44<.61) +(C45-O45>.14)*(C45-O45<.31)*(H45-L45<.61) +(C46-O46>.14)*(C46-O46<.31)*(H46-L46<.61) +(C47-O47>.14)*(C47-O47<.31)*(H47-L47<.61) +(C48-O48>.14)*(C48-O48<.31)*(H48-L48<.61) +(C49-O49>.14)*(C49-O49<.31)*(H49-L49<.61) +(C50-O50>.14)*(C50-O50<.31)*(H50-L50<.61) +(C51-O51>.14)*(C51-O51<.31)*(H51-L51<.61) +(C52-O52>.14)*(C52-O52<.31)*(H52-L52<.61) +(C53-O53>.14)*(C53-O53<.31)*(H53-L53<.61) +(C54-O54>.14)*(C54-O54<.31)*(H54-L54<.61) +(C55-O55>.14)*(C55-O55<.31)*(H55-L55<.61) +(C56-O56>.14)*(C56-O56<.31)*(H56-L56<.61) +(C57-O57>.14)*(C57-O57<.31)*(H57-L57<.61) +(C58-O58>.14)*(C58-O58<.31)*(H58-L58<.61) +(C59-O59>.14)*(C59-O59<.31)*(H59-L59<.61))

Multiplied Together:

((C-O>.14)*(C-O<.31)*(H-L<.61)*(C-O) +(C1-O1>.14)*(C1-O1<.31)*(H1-L1<.61)*(C1-O1) +(C2-O2>.14)*(C2-O2<.31)*(H2-L2<.61)*(C2-O2) +(C3-O3>.14)*(C3-O3<.31)*(H3-L3<.61)*(C3-O3) +(C4-O4>.14)*(C4-O4<.31)*(H4-L4<.61)*(C4-O4) +(C5-O5>.14)*(C5-O5<.31)*(H5-L5<.61)*(C5-O5) +(C6-O6>.14)*(C6-O6<.31)*(H6-L6<.61)*(C6-O6) +(C7-O7>.14)*(C7-O7<.31)*(H7-L7<.61)*(C7-O7) +(C8-O8>.14)*(C8-O8<.31)*(H8-L8<.61)*(C8-O8) +(C9-O9>.14)*(C9-O9<.31)*(H9-L9<.61)*(C9-O9) +(C10-O10>.14)*(C10-O10<.31)*(H10-L10<.61)*(C10-O10) +(C11-O11>.14)*(C11-O11<.31)*(H11-L11<.61)*(C11-O11) +(C12-O12>.14)*(C12-O12<.31)*(H12-L12<.61)*(C12-O12) +(C13-O13>.14)*(C13-O13<.31)*(H13-L13<.61)*(C13-O13) +(C14-O14>.14)*(C14-O14<.31)*(H14-L14<.61)*(C14-O14) +(C15-O15>.14)*(C15-O15<.31)*(H15-L15<.61)*(C15-O15) +(C16-O16>.14)*(C16-O16<.31)*(H16-L16<.61)*(C16-O16) +(C17-O17>.14)*(C17-O17<.31)*(H17-L17<.61)*(C17-O17) +(C18-O18>.14)*(C18-O18<.31)*(H18-L18<.61)*(C18-O18) +(C19-O19>.14)*(C19-O19<.31)*(H19-L19<.61)*(C19-O19) +(C20-O20>.14)*(C20-O20<.31)*(H20-L20<.61)*(C20-O20) +(C21-O21>.14)*(C21-O21<.31)*(H21-L21<.61)*(C21-O21) +(C22-O22>.14)*(C22-O22<.31)*(H22-L22<.61)*(C22-O22) +(C23-O23>.14)*(C23-O23<.31)*(H23-L23<.61)*(C23-O23) +(C24-O24>.14)*(C24-O24<.31)*(H24-L24<.61)*(C24-O24) +(C25-O25>.14)*(C25-O25<.31)*(H25-L25<.61)*(C25-O25) +(C26-O26>.14)*(C26-O26<.31)*(H26-L26<.61)*(C26-O26) +(C27-O27>.14)*(C27-O27<.31)*(H27-L27<.61)*(C27-O27) +(C28-O28>.14)*(C28-O28<.31)*(H28-L28<.61)*(C28-O28) +(C29-O29>.14)*(C29-O29<.31)*(H29-L29<.61)*(C29-O29) +(C30-O30>.14)*(C30-O30<.31)*(H30-L30<.61)*(C30-O30) +(C31-O31>.14)*(C31-O31<.31)*(H31-L31<.61)*(C31-O31) +(C32-O32>.14)*(C32-O32<.31)*(H32-L32<.61)*(C32-O32) +(C33-O33>.14)*(C33-O33<.31)*(H33-L33<.61)*(C33-O33) +(C34-O34>.14)*(C34-O34<.31)*(H34-L34<.61)*(C34-O34) +(C35-O35>.14)*(C35-O35<.31)*(H35-L35<.61)*(C35-O35) +(C36-O36>.14)*(C36-O36<.31)*(H36-L36<.61)*(C36-O36) +(C37-O37>.14)*(C37-O37<.31)*(H37-L37<.61)*(C37-O37) +(C38-O38>.14)*(C38-O38<.31)*(H38-L38<.61)*(C38-O38) +(C39-O39>.14)*(C39-O39<.31)*(H39-L39<.61)*(C39-O39) +(C40-O40>.14)*(C40-O40<.31)*(H40-L40<.61)*(C40-O40) +(C41-O41>.14)*(C41-O41<.31)*(H41-L41<.61)*(C41-O41) +(C42-O42>.14)*(C42-O42<.31)*(H42-L42<.61)*(C42-O42) +(C43-O43>.14)*(C43-O43<.31)*(H43-L43<.61)*(C43-O43) +(C44-O44>.14)*(C44-O44<.31)*(H44-L44<.61)*(C44-O44) +(C45-O45>.14)*(C45-O45<.31)*(H45-L45<.61)*(C45-O45) +(C46-O46>.14)*(C46-O46<.31)*(H46-L46<.61)*(C46-O46) +(C47-O47>.14)*(C47-O47<.31)*(H47-L47<.61)*(C47-O47) +(C48-O48>.14)*(C48-O48<.31)*(H48-L48<.61)*(C48-O48) +(C49-O49>.14)*(C49-O49<.31)*(H49-L49<.61)*(C49-O49) +(C50-O50>.14)*(C50-O50<.31)*(H50-L50<.61)*(C50-O50) +(C51-O51>.14)*(C51-O51<.31)*(H51-L51<.61)*(C51-O51) +(C52-O52>.14)*(C52-O52<.31)*(H52-L52<.61)*(C52-O52) +(C53-O53>.14)*(C53-O53<.31)*(H53-L53<.61)*(C53-O53) +(C54-O54>.14)*(C54-O54<.31)*(H54-L54<.61)*(C54-O54) +(C55-O55>.14)*(C55-O55<.31)*(H55-L55<.61)*(C55-O55) +(C56-O56>.14)*(C56-O56<.31)*(H56-L56<.61)*(C56-O56) +(C57-O57>.14)*(C57-O57<.31)*(H57-L57<.61)*(C57-O57) +(C58-O58>.14)*(C58-O58<.31)*(H58-L58<.61)*(C58-O58) +(C59-O59>.14)*(C59-O59<.31)*(H59-L59<.61)*(C59-O59))/(-60)

-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.