TC2000.com• Download software • Tutorial videos • Subscription & data-feed pricing • Class schedule
TC2000Brokerage.com• New account application • Trading resources • Margin rates • Stock & option commissions
Worden Discussion Forum
So simple. Thanks!
I forgot to say what I am looking for using ATR1 is a high ranked ATR1 which can be the beginning of a consolidation/correction pattern -- or occur before one of these patterns.
I am using ATR1-period as a chart plot overlaid on the Inside Day Condition in order to help me quickly find Pennants and other consolidation/correction patterns.
I am able to click on ATR1-period (on the plot) and "Copy to Watchlist" (thus adding a column to my Column Set and named "ATR1 Now"). However, I am unable to add Average True Range Period-1s for previous days without additional ATR1 indicators.
What I need are a series of PCF Indicators for the numerical values of ATR1 1-Ago, ATR1 2-Ago, etc. to ATR1 10-Ago.
Once each of these numerical values are placed on my Column Set, I use Inside Bars in order to draw trend lines -- and then to more quickly see possible breakouts from various consolidation/corrections patterns.
Tested CountTrue above and it works just fine. Thanks, again.
...occurred within the ten day period of time.
Neither. I thought this PCF was a CountTrue in which the formula counted how many times a single Daily Inside Bar occurred. That's what I'd like.
Please change the PCF Indicator below to only reflect Inside Bars for Today and the Previous Nine Days, ten days in all.
IIF(L20 < MINL20 AND MAXH20 < H20, 20, IIF(L19 < MINL19 AND MAXH19 < H19, 19, IIF(L18 < MINL18 AND MAXH18 < H18, 18, IIF(L17 < MINL17 AND MAXH17 < H17, 17, IIF(L16 < MINL16 AND MAXH16 < H16, 16, IIF(L15 < MINL15 AND MAXH15 < H15, 15, IIF(L14 < MINL14 AND MAXH14 < H14, 14, IIF(L13 < MINL13 AND MAXH13 < H13, 13, IIF(L12 < MINL12 AND MAXH12 < H12, 12, IIF(L11 < MINL11 AND MAXH11 < H11, 11, IIF(L10 < MINL10 AND MAXH10 < H10, 10, IIF(L9 < MINL9 AND MAXH9 < H9, 9, IIF(L8 < MINL8 AND MAXH8 < H8, 8, IIF(L7 < MINL7 AND MAXH7 < H7, 7, IIF(L6 < MINL6 AND MAXH6 < H6, 6, IIF(L5 < MINL5 AND MAXH5 < H5, 5, IIF(L4 < MINL4 AND MAXH4 < H4, 4, IIF(L3 < MINL3 AND MAXH3 < H3, 3, IIF(L2 < MINL2 AND MAXH2 < H2, 2, IIF(L1 < L AND H < H1, 1, 0))))))))))))))))))))
The two formulas you offered above do work in all instances tested against stocks, ADRs, and ETFs. Thanks, Bruce.
I am setting the TimeFrame to Quarterly in each of these PCF Indicators:
% Return in Recent Quarter
100 * (C1 / C2 - 1)
% Return in Previous Quarter
100 * (C2 / C3 - 1)
If I want to compare the return of the current quarter to the return of the previous quarter, I've tried this fomula. For the most part it works. But not entirely.
(100 * (C1 / C2 - 1))>(100 * (C2 / C3 - 1))
I am confident you can improve this.
Thanks, I'll try this and then check it against the "Custom Date Sort" tool.