Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
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
|
|
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
|
|
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
|
|
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
|
|
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
|
|
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
|
|
Registered User Joined: 4/14/2016 Posts: 11
|
It works perfectly now, many thanks Bruce!
|
|
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.
|
|
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
|
|
Registered User Joined: 4/30/2015 Posts: 197
|
thanks
|
|
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
|
|
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
|
|
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)
|
|
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
|
|
Registered User Joined: 4/30/2015 Posts: 197
|
you truly are the best
|
|
Registered User Joined: 4/30/2015 Posts: 197
|
The result of your work. Thanks Again http://www.screencast.com/t/sxCpx5g5iZa7
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |