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

Highlighting price gaps on a chart Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
shirodka2
Posted : Tuesday, May 3, 2016 9:21:11 PM
Registered User
Joined: 4/14/2016
Posts: 11

Hi,

 

Is there a way to highligh price gaps on a chart, similarly to how ThinkorSwim does it?

 

Tks,

Lawrence

Bruce_L
Posted : Wednesday, May 4, 2016 9:55:58 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

I really don't know how ThinkOrSwim does it. I don't have SinkOrSwim and a Google search "ThinkOrSwim Gap Highlight" didn't seem to return anything obvious which showed me what happens on the chart.

The best topic of which I'm aware on how to post images in the forums is Inserting A Chart into A Worden post.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
shirodka2
Posted : Thursday, May 5, 2016 11:11:06 PM
Registered User
Joined: 4/14/2016
Posts: 11

Hi Bruce,

Referring to the chart below, price gaps are automatically highlighted in green. (Earnings with the $ symbol). I am supposing TC2000 doesn't have these features natively? These are very useful featurs to include if they don't already exist. 

 

Tks,

Lawrence

 

Bruce_L
Posted : Friday, May 6, 2016 9:58:37 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

Thank you for your earnings date suggestion.

It is not possible to highlight the gap in the chart using a big wide bar, but it is possible to plot a colored dot on the chart when there is a gap up or gap down.

You would do this by adding a Custom PCF Indicator to the chart with the Plot Style set to Dot.

How to add an indicator to a chart template
How to edit an Indicator

You would then need to set the Formula to something which only plots when when there is a gap. For example, if you wanted to plot the dot half way through the gap with a gap being defined as the low being above the previous high, then you could use the following Formula in the Custom PCF Indicator.

(L + H1) / 2 / ABS(L > H1)

A similar formula to plot a dot at the midpoint of a gap down defined as the high being below the previous low would use the following Formula in the Custom PCF Indicator.

(H + L1) / 2 / ABS(H < L1)

You would use a different Custom PCF Indicator for the gap up and gap down. This would allow you to plot different colors for the different types of gaps.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
shirodka2
Posted : Monday, May 9, 2016 9:35:39 PM
Registered User
Joined: 4/14/2016
Posts: 11

 

Hi Bruce,

Thanks for the workaround! Following your instructions, I've added pair of indicators to mark out the gap downs and gap ups but the dots appear either way above or below the relevant candles rather than half way through the gaps. Any idea what I could be doing wrong?

 

Tks,

Lawrence

Bruce_L
Posted : Tuesday, May 10, 2016 8:52:07 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

Sorry, it is my fault. I left out a / 2 in both formulas. I have corrected the formulas in the original post.

If that doesn't resolve the problem on its own, the most likely issue would just be the Custom PCF Indicators not being scaled with price. Try clicking on the Custom PCF Indicators and selecting Scaling. You will want to scale with price (probably listed as the symbol and company name in the list) instead of By Itself.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
shirodka2
Posted : Tuesday, May 10, 2016 10:31:00 AM
Registered User
Joined: 4/14/2016
Posts: 11

 

It works perfectly now, many thanks Bruce!

Aces4Me
Posted : Sunday, July 17, 2016 11:21:27 PM
Registered User
Joined: 4/30/2015
Posts: 197

Bruce is there a way Every time this formula is True to plot a Flat Line representing the C1 Value (O > C1 * 1.027)  I would like to place this on a 1 Hour chart.  Any time there is a gap of this size i wish to be able to scan back for that value for say 427 bars (60 days) - i know i would have to write a long formula to scan for that.  Would be nice to have the value plotted on the chart it self.

Bruce_L
Posted : Monday, July 18, 2016 3:37:26 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

You could plot a dot at the C1 value fairly easily.

C1 / ABS(O > C1 * 1.027)

And you could theoretically use the techniques in the Days Since Last Peak (or other day-counting needs) topic to make this plot as a flat line until there was another gap. But the maximum lookback would be in the tens of bars, not in the hundreds of bars.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Aces4Me
Posted : Monday, July 18, 2016 4:54:14 PM
Registered User
Joined: 4/30/2015
Posts: 197

thanks

Aces4Me
Posted : Monday, July 18, 2016 8:26:13 PM
Registered User
Joined: 4/30/2015
Posts: 197

i tried the link and tried a few of the short forumlas (inserting my formula) and got a vertical line on the chart is all i came up with.  I am pretty much at a lose as to what to do with the information found at the linked page

Bruce_L
Posted : Tuesday, July 19, 2016 3:03:02 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

The following version of the formula goes out to 100 bars. It will plot zero if there hasn't been a gap up meeting the requirements in those 100 bars.

ABS(O > C1 * 1.027) * C1 + ABS(O <= C1 * 1.027) * (ABS(O1 > C2 * 1.027) * C2 + ABS(O1 <= C2 * 1.027) * (ABS(O2 > C3 * 1.027) * C3 + ABS(O2 <= C3 * 1.027) * (ABS(O3 > C4 * 1.027) * C4 + ABS(O3 <= C4 * 1.027) * (ABS(O4 > C5 * 1.027) * C5 + ABS(O4 <= C5 * 1.027) * (ABS(O5 > C6 * 1.027) * C6 + ABS(O5 <= C6 * 1.027) * (ABS(O6 > C7 * 1.027) * C7 + ABS(O6 <= C7 * 1.027) * (ABS(O7 > C8 * 1.027) * C8 + ABS(O7 <= C8 * 1.027) * (ABS(O8 > C9 * 1.027) * C9 + ABS(O8 <= C9 * 1.027) * (ABS(O9 > C10 * 1.027) * C10 + ABS(O9 <= C10 * 1.027) * (ABS(O10 > C11 * 1.027) * C11 + ABS(O10 <= C11 * 1.027) * (ABS(O11 > C12 * 1.027) * C12 + ABS(O11 <= C12 * 1.027) * (ABS(O12 > C13 * 1.027) * C13 + ABS(O12 <= C13 * 1.027) * (ABS(O13 > C14 * 1.027) * C14 + ABS(O13 <= C14 * 1.027) * (ABS(O14 > C15 * 1.027) * C15 + ABS(O14 <= C15 * 1.027) * (ABS(O15 > C16 * 1.027) * C16 + ABS(O15 <= C16 * 1.027) * (ABS(O16 > C17 * 1.027) * C17 + ABS(O16 <= C17 * 1.027) * (ABS(O17 > C18 * 1.027) * C18 + ABS(O17 <= C18 * 1.027) * (ABS(O18 > C19 * 1.027) * C19 + ABS(O18 <= C19 * 1.027) * (ABS(O19 > C20 * 1.027) * C20 + ABS(O19 <= C20 * 1.027) * (ABS(O20 > C21 * 1.027) * C21 + ABS(O20 <= C21 * 1.027) * (ABS(O21 > C22 * 1.027) * C22 + ABS(O21 <= C22 * 1.027) * (ABS(O22 > C23 * 1.027) * C23 + ABS(O22 <= C23 * 1.027) * (ABS(O23 > C24 * 1.027) * C24 + ABS(O23 <= C24 * 1.027) * (ABS(O24 > C25 * 1.027) * C25 + ABS(O24 <= C25 * 1.027) * (ABS(O25 > C26 * 1.027) * C26 + ABS(O25 <= C26 * 1.027) * (ABS(O26 > C27 * 1.027) * C27 + ABS(O26 <= C27 * 1.027) * (ABS(O27 > C28 * 1.027) * C28 + ABS(O27 <= C28 * 1.027) * (ABS(O28 > C29 * 1.027) * C29 + ABS(O28 <= C29 * 1.027) * (ABS(O29 > C30 * 1.027) * C30 + ABS(O29 <= C30 * 1.027) * (ABS(O30 > C31 * 1.027) * C31 + ABS(O30 <= C31 * 1.027) * (ABS(O31 > C32 * 1.027) * C32 + ABS(O31 <= C32 * 1.027) * (ABS(O32 > C33 * 1.027) * C33 + ABS(O32 <= C33 * 1.027) * (ABS(O33 > C34 * 1.027) * C34 + ABS(O33 <= C34 * 1.027) * (ABS(O34 > C35 * 1.027) * C35 + ABS(O34 <= C35 * 1.027) * (ABS(O35 > C36 * 1.027) * C36 + ABS(O35 <= C36 * 1.027) * (ABS(O36 > C37 * 1.027) * C37 + ABS(O36 <= C37 * 1.027) * (ABS(O37 > C38 * 1.027) * C38 + ABS(O37 <= C38 * 1.027) * (ABS(O38 > C39 * 1.027) * C39 + ABS(O38 <= C39 * 1.027) * (ABS(O39 > C40 * 1.027) * C40 + ABS(O39 <= C40 * 1.027) * (ABS(O40 > C41 * 1.027) * C41 + ABS(O40 <= C41 * 1.027) * (ABS(O41 > C42 * 1.027) * C42 + ABS(O41 <= C42 * 1.027) * (ABS(O42 > C43 * 1.027) * C43 + ABS(O42 <= C43 * 1.027) * (ABS(O43 > C44 * 1.027) * C44 + ABS(O43 <= C44 * 1.027) * (ABS(O44 > C45 * 1.027) * C45 + ABS(O44 <= C45 * 1.027) * (ABS(O45 > C46 * 1.027) * C46 + ABS(O45 <= C46 * 1.027) * (ABS(O46 > C47 * 1.027) * C47 + ABS(O46 <= C47 * 1.027) * (ABS(O47 > C48 * 1.027) * C48 + ABS(O47 <= C48 * 1.027) * (ABS(O48 > C49 * 1.027) * C49 + ABS(O48 <= C49 * 1.027) * (ABS(O49 > C50 * 1.027) * C50 + ABS(O49 <= C50 * 1.027) * (ABS(O50 > C51 * 1.027) * C51 + ABS(O50 <= C51 * 1.027) * (ABS(O51 > C52 * 1.027) * C52 + ABS(O51 <= C52 * 1.027) * (ABS(O52 > C53 * 1.027) * C53 + ABS(O52 <= C53 * 1.027) * (ABS(O53 > C54 * 1.027) * C54 + ABS(O53 <= C54 * 1.027) * (ABS(O54 > C55 * 1.027) * C55 + ABS(O54 <= C55 * 1.027) * (ABS(O55 > C56 * 1.027) * C56 + ABS(O55 <= C56 * 1.027) * (ABS(O56 > C57 * 1.027) * C57 + ABS(O56 <= C57 * 1.027) * (ABS(O57 > C58 * 1.027) * C58 + ABS(O57 <= C58 * 1.027) * (ABS(O58 > C59 * 1.027) * C59 + ABS(O58 <= C59 * 1.027) * (ABS(O59 > C60 * 1.027) * C60 + ABS(O59 <= C60 * 1.027) * (ABS(O60 > C61 * 1.027) * C61 + ABS(O60 <= C61 * 1.027) * (ABS(O61 > C62 * 1.027) * C62 + ABS(O61 <= C62 * 1.027) * (ABS(O62 > C63 * 1.027) * C63 + ABS(O62 <= C63 * 1.027) * (ABS(O63 > C64 * 1.027) * C64 + ABS(O63 <= C64 * 1.027) * (ABS(O64 > C65 * 1.027) * C65 + ABS(O64 <= C65 * 1.027) * (ABS(O65 > C66 * 1.027) * C66 + ABS(O65 <= C66 * 1.027) * (ABS(O66 > C67 * 1.027) * C67 + ABS(O66 <= C67 * 1.027) * (ABS(O67 > C68 * 1.027) * C68 + ABS(O67 <= C68 * 1.027) * (ABS(O68 > C69 * 1.027) * C69 + ABS(O68 <= C69 * 1.027) * (ABS(O69 > C70 * 1.027) * C70 + ABS(O69 <= C70 * 1.027) * (ABS(O70 > C71 * 1.027) * C71 + ABS(O70 <= C71 * 1.027) * (ABS(O71 > C72 * 1.027) * C72 + ABS(O71 <= C72 * 1.027) * (ABS(O72 > C73 * 1.027) * C73 + ABS(O72 <= C73 * 1.027) * (ABS(O73 > C74 * 1.027) * C74 + ABS(O73 <= C74 * 1.027) * (ABS(O74 > C75 * 1.027) * C75 + ABS(O74 <= C75 * 1.027) * (ABS(O75 > C76 * 1.027) * C76 + ABS(O75 <= C76 * 1.027) * (ABS(O76 > C77 * 1.027) * C77 + ABS(O76 <= C77 * 1.027) * (ABS(O77 > C78 * 1.027) * C78 + ABS(O77 <= C78 * 1.027) * (ABS(O78 > C79 * 1.027) * C79 + ABS(O78 <= C79 * 1.027) * (ABS(O79 > C80 * 1.027) * C80 + ABS(O79 <= C80 * 1.027) * (ABS(O80 > C81 * 1.027) * C81 + ABS(O80 <= C81 * 1.027) * (ABS(O81 > C82 * 1.027) * C82 + ABS(O81 <= C82 * 1.027) * (ABS(O82 > C83 * 1.027) * C83 + ABS(O82 <= C83 * 1.027) * (ABS(O83 > C84 * 1.027) * C84 + ABS(O83 <= C84 * 1.027) * (ABS(O84 > C85 * 1.027) * C85 + ABS(O84 <= C85 * 1.027) * (ABS(O85 > C86 * 1.027) * C86 + ABS(O85 <= C86 * 1.027) * (ABS(O86 > C87 * 1.027) * C87 + ABS(O86 <= C87 * 1.027) * (ABS(O87 > C88 * 1.027) * C88 + ABS(O87 <= C88 * 1.027) * (ABS(O88 > C89 * 1.027) * C89 + ABS(O88 <= C89 * 1.027) * (ABS(O89 > C90 * 1.027) * C90 + ABS(O89 <= C90 * 1.027) * (ABS(O90 > C91 * 1.027) * C91 + ABS(O90 <= C91 * 1.027) * (ABS(O91 > C92 * 1.027) * C92 + ABS(O91 <= C92 * 1.027) * (ABS(O92 > C93 * 1.027) * C93 + ABS(O92 <= C93 * 1.027) * (ABS(O93 > C94 * 1.027) * C94 + ABS(O93 <= C94 * 1.027) * (ABS(O94 > C95 * 1.027) * C95 + ABS(O94 <= C95 * 1.027) * (ABS(O95 > C96 * 1.027) * C96 + ABS(O95 <= C96 * 1.027) * (ABS(O96 > C97 * 1.027) * C97 + ABS(O96 <= C97 * 1.027) * (ABS(O97 > C98 * 1.027) * C98 + ABS(O97 <= C98 * 1.027) * (ABS(O98 > C99 * 1.027) * C99 + ABS(O98 <= C99 * 1.027) * (ABS(O99 > C100 * 1.027) * C100)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Aces4Me
Posted : Tuesday, July 19, 2016 4:52:05 PM
Registered User
Joined: 4/30/2015
Posts: 197

Perfect  - Can you do the same for the reverse gap down formula 

C1 / ABS(O < C1 * .973)

Bruce_L
Posted : Tuesday, July 19, 2016 4:56:53 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

Please try the following.

ABS(O < C1 * .973) * C1 + ABS(O >= C1 * .973) * (ABS(O1 < C2 * .973) * C2 + ABS(O1 >= C2 * .973) * (ABS(O2 < C3 * .973) * C3 + ABS(O2 >= C3 * .973) * (ABS(O3 < C4 * .973) * C4 + ABS(O3 >= C4 * .973) * (ABS(O4 < C5 * .973) * C5 + ABS(O4 >= C5 * .973) * (ABS(O5 < C6 * .973) * C6 + ABS(O5 >= C6 * .973) * (ABS(O6 < C7 * .973) * C7 + ABS(O6 >= C7 * .973) * (ABS(O7 < C8 * .973) * C8 + ABS(O7 >= C8 * .973) * (ABS(O8 < C9 * .973) * C9 + ABS(O8 >= C9 * .973) * (ABS(O9 < C10 * .973) * C10 + ABS(O9 >= C10 * .973) * (ABS(O10 < C11 * .973) * C11 + ABS(O10 >= C11 * .973) * (ABS(O11 < C12 * .973) * C12 + ABS(O11 >= C12 * .973) * (ABS(O12 < C13 * .973) * C13 + ABS(O12 >= C13 * .973) * (ABS(O13 < C14 * .973) * C14 + ABS(O13 >= C14 * .973) * (ABS(O14 < C15 * .973) * C15 + ABS(O14 >= C15 * .973) * (ABS(O15 < C16 * .973) * C16 + ABS(O15 >= C16 * .973) * (ABS(O16 < C17 * .973) * C17 + ABS(O16 >= C17 * .973) * (ABS(O17 < C18 * .973) * C18 + ABS(O17 >= C18 * .973) * (ABS(O18 < C19 * .973) * C19 + ABS(O18 >= C19 * .973) * (ABS(O19 < C20 * .973) * C20 + ABS(O19 >= C20 * .973) * (ABS(O20 < C21 * .973) * C21 + ABS(O20 >= C21 * .973) * (ABS(O21 < C22 * .973) * C22 + ABS(O21 >= C22 * .973) * (ABS(O22 < C23 * .973) * C23 + ABS(O22 >= C23 * .973) * (ABS(O23 < C24 * .973) * C24 + ABS(O23 >= C24 * .973) * (ABS(O24 < C25 * .973) * C25 + ABS(O24 >= C25 * .973) * (ABS(O25 < C26 * .973) * C26 + ABS(O25 >= C26 * .973) * (ABS(O26 < C27 * .973) * C27 + ABS(O26 >= C27 * .973) * (ABS(O27 < C28 * .973) * C28 + ABS(O27 >= C28 * .973) * (ABS(O28 < C29 * .973) * C29 + ABS(O28 >= C29 * .973) * (ABS(O29 < C30 * .973) * C30 + ABS(O29 >= C30 * .973) * (ABS(O30 < C31 * .973) * C31 + ABS(O30 >= C31 * .973) * (ABS(O31 < C32 * .973) * C32 + ABS(O31 >= C32 * .973) * (ABS(O32 < C33 * .973) * C33 + ABS(O32 >= C33 * .973) * (ABS(O33 < C34 * .973) * C34 + ABS(O33 >= C34 * .973) * (ABS(O34 < C35 * .973) * C35 + ABS(O34 >= C35 * .973) * (ABS(O35 < C36 * .973) * C36 + ABS(O35 >= C36 * .973) * (ABS(O36 < C37 * .973) * C37 + ABS(O36 >= C37 * .973) * (ABS(O37 < C38 * .973) * C38 + ABS(O37 >= C38 * .973) * (ABS(O38 < C39 * .973) * C39 + ABS(O38 >= C39 * .973) * (ABS(O39 < C40 * .973) * C40 + ABS(O39 >= C40 * .973) * (ABS(O40 < C41 * .973) * C41 + ABS(O40 >= C41 * .973) * (ABS(O41 < C42 * .973) * C42 + ABS(O41 >= C42 * .973) * (ABS(O42 < C43 * .973) * C43 + ABS(O42 >= C43 * .973) * (ABS(O43 < C44 * .973) * C44 + ABS(O43 >= C44 * .973) * (ABS(O44 < C45 * .973) * C45 + ABS(O44 >= C45 * .973) * (ABS(O45 < C46 * .973) * C46 + ABS(O45 >= C46 * .973) * (ABS(O46 < C47 * .973) * C47 + ABS(O46 >= C47 * .973) * (ABS(O47 < C48 * .973) * C48 + ABS(O47 >= C48 * .973) * (ABS(O48 < C49 * .973) * C49 + ABS(O48 >= C49 * .973) * (ABS(O49 < C50 * .973) * C50 + ABS(O49 >= C50 * .973) * (ABS(O50 < C51 * .973) * C51 + ABS(O50 >= C51 * .973) * (ABS(O51 < C52 * .973) * C52 + ABS(O51 >= C52 * .973) * (ABS(O52 < C53 * .973) * C53 + ABS(O52 >= C53 * .973) * (ABS(O53 < C54 * .973) * C54 + ABS(O53 >= C54 * .973) * (ABS(O54 < C55 * .973) * C55 + ABS(O54 >= C55 * .973) * (ABS(O55 < C56 * .973) * C56 + ABS(O55 >= C56 * .973) * (ABS(O56 < C57 * .973) * C57 + ABS(O56 >= C57 * .973) * (ABS(O57 < C58 * .973) * C58 + ABS(O57 >= C58 * .973) * (ABS(O58 < C59 * .973) * C59 + ABS(O58 >= C59 * .973) * (ABS(O59 < C60 * .973) * C60 + ABS(O59 >= C60 * .973) * (ABS(O60 < C61 * .973) * C61 + ABS(O60 >= C61 * .973) * (ABS(O61 < C62 * .973) * C62 + ABS(O61 >= C62 * .973) * (ABS(O62 < C63 * .973) * C63 + ABS(O62 >= C63 * .973) * (ABS(O63 < C64 * .973) * C64 + ABS(O63 >= C64 * .973) * (ABS(O64 < C65 * .973) * C65 + ABS(O64 >= C65 * .973) * (ABS(O65 < C66 * .973) * C66 + ABS(O65 >= C66 * .973) * (ABS(O66 < C67 * .973) * C67 + ABS(O66 >= C67 * .973) * (ABS(O67 < C68 * .973) * C68 + ABS(O67 >= C68 * .973) * (ABS(O68 < C69 * .973) * C69 + ABS(O68 >= C69 * .973) * (ABS(O69 < C70 * .973) * C70 + ABS(O69 >= C70 * .973) * (ABS(O70 < C71 * .973) * C71 + ABS(O70 >= C71 * .973) * (ABS(O71 < C72 * .973) * C72 + ABS(O71 >= C72 * .973) * (ABS(O72 < C73 * .973) * C73 + ABS(O72 >= C73 * .973) * (ABS(O73 < C74 * .973) * C74 + ABS(O73 >= C74 * .973) * (ABS(O74 < C75 * .973) * C75 + ABS(O74 >= C75 * .973) * (ABS(O75 < C76 * .973) * C76 + ABS(O75 >= C76 * .973) * (ABS(O76 < C77 * .973) * C77 + ABS(O76 >= C77 * .973) * (ABS(O77 < C78 * .973) * C78 + ABS(O77 >= C78 * .973) * (ABS(O78 < C79 * .973) * C79 + ABS(O78 >= C79 * .973) * (ABS(O79 < C80 * .973) * C80 + ABS(O79 >= C80 * .973) * (ABS(O80 < C81 * .973) * C81 + ABS(O80 >= C81 * .973) * (ABS(O81 < C82 * .973) * C82 + ABS(O81 >= C82 * .973) * (ABS(O82 < C83 * .973) * C83 + ABS(O82 >= C83 * .973) * (ABS(O83 < C84 * .973) * C84 + ABS(O83 >= C84 * .973) * (ABS(O84 < C85 * .973) * C85 + ABS(O84 >= C85 * .973) * (ABS(O85 < C86 * .973) * C86 + ABS(O85 >= C86 * .973) * (ABS(O86 < C87 * .973) * C87 + ABS(O86 >= C87 * .973) * (ABS(O87 < C88 * .973) * C88 + ABS(O87 >= C88 * .973) * (ABS(O88 < C89 * .973) * C89 + ABS(O88 >= C89 * .973) * (ABS(O89 < C90 * .973) * C90 + ABS(O89 >= C90 * .973) * (ABS(O90 < C91 * .973) * C91 + ABS(O90 >= C91 * .973) * (ABS(O91 < C92 * .973) * C92 + ABS(O91 >= C92 * .973) * (ABS(O92 < C93 * .973) * C93 + ABS(O92 >= C93 * .973) * (ABS(O93 < C94 * .973) * C94 + ABS(O93 >= C94 * .973) * (ABS(O94 < C95 * .973) * C95 + ABS(O94 >= C95 * .973) * (ABS(O95 < C96 * .973) * C96 + ABS(O95 >= C96 * .973) * (ABS(O96 < C97 * .973) * C97 + ABS(O96 >= C97 * .973) * (ABS(O97 < C98 * .973) * C98 + ABS(O97 >= C98 * .973) * (ABS(O98 < C99 * .973) * C99 + ABS(O98 >= C99 * .973) * (ABS(O99 < C100 * .973) * C100)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Aces4Me
Posted : Tuesday, July 19, 2016 5:00:59 PM
Registered User
Joined: 4/30/2015
Posts: 197

you truly are the best

Aces4Me
Posted : Tuesday, July 19, 2016 5:36:37 PM
Registered User
Joined: 4/30/2015
Posts: 197

The result of your work.  Thanks Again  http://www.screencast.com/t/sxCpx5g5iZa7

Bruce_L
Posted : Thursday, July 21, 2016 9:54:44 AM


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.