Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Platinum Customer
Joined: 3/31/2006 Posts: 3,207
|
Bruce,
Few months ago you wrote the PCF below that plots the volume based on where the stock closed in its Daily Range and I have monitored this with PP signals
V * IIF(H > L OR H <> C1, (C - LEAST(L, C1)) / (GREATEST(H, C1) - LEAST(L, C1)), 1 / 2)
this is pcf for the PP i use
(C > C1 AND V > MAX(ABS(C1 < C2) * V1, 10))
I like to change the PP PCF and Adj the Volume based on where the stock closed within its DR.
For ex
Please take a look at MSFT and as you can see it did not meet the PP requirement yesterday as yesterday's volume was lower than the 11/20 volume when the stock closed down
But on 11/20 the stock closed almost at the 45% of its DR so since the stock closed significantly off of its lows I like to adjust the Down day volume based on where the stock closed within its DR.
Total of 64M shares traded on 11/20 - Adj that based on the Close vs DR 35.4M (55% of the Volume) as Down Vol and 28.7M (45% of the Volume) as Up Vol
Yesterday 11/28 the stock traded total of 46.8M shares and closed at the 95% of its DR - Meaning 95% of the total Vol as Up Vol (44.4M) and 5% of the total volume as Down Vol (2.3M)
I want the new PP PCF to compare today's Up Vol vs. the Down Volume in the last 10 days
As such yesterday MSFT would have had a PP signal since yesterday's Up Vol of 44.4M was higher than any of the Down Day Volumes in the last 10 days
AMZN is another ex - It did not qualify as PP yesterday since yesterday's vol was lower than the 11/20 vol when the stock closed down. But on 11/20 AMZN closed at the 65.76% of its DR.
If we Adj the Down Day Vol based on Close vs. DR it would only count about 35% of the total vol on 11/20 as Down Vol.
yesterday it traded 8.4M shares and closed at 96.3% of DR so the Up Vol yesterday was 8.1M shares which is higher than any of the Down Day Vol's in the last 10 days
Can this be done?
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
My interpretation of what you are describing would be the following.
(C > C1 AND V * IIF(H > L OR H <> C1, (C - LEAST(L, C1)) / (GREATEST(H, C1) - LEAST(L, C1)), 1 / 2) > MAX(V1 * IIF(H1 > L1 OR H1 <> C2, (C1 - LEAST(L1, C2)) / (GREATEST(H1, C2) - LEAST(L1, C2)), 1 / 2), 10))
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Platinum Customer
Joined: 3/31/2006 Posts: 3,207
|
Bruce, I played with the above PCF and something is off
I plotted your PCF as a IIF function so I can compare
IIF((C > C1 AND V * IIF(H > L OR H <> C1, (C - LEAST(L, C1)) / (GREATEST(H, C1) - LEAST(L, C1)), 1 / 2) > MAX(V1 * IIF(H1 > L1 OR H1 <> C2, (C1 - LEAST(L1, C2)) / (GREATEST(H1, C2) - LEAST(L1, C2)), 1 / 2), 10)), 10, 1/0)
This will plot 10 if true and nothing if false
if you plot the above it shows that 10/25 was a PP on MSFT which is not true
On 10/25 MSFT Total Vol was 61.6M and the stock closed at 86% of DR therefore 86% of the Total Vol will be the UP Day Vol at 53M Shares
One day before on 10/24 MSFT traded 63.8M Shares and closed at 10.58% of its DR making 89.42% of the Total Vol as Down Day Vol 57.1
10/25 - 61.6M Total Volume - Closed at 86% of DR - Up Day Vol (53M - 86% of 61.6M) with remaining 14% as Down Day Vol
10/24 - 63.8M Total Volume - Closed at 10.58% of DR - Up Day Vol (6.8M - 10.58% of 63.8M) and Down Day Vol (57.1M - 89.42% of 63.8M)
So the Up Vol on 10/25 of 53M shares was less than the Down Vol of 57.1M on 10/24 therefore the condition should be false on 10/25 and not true
|
|
Platinum Customer
Joined: 3/31/2006 Posts: 3,207
|
MA on 10/11 vs 10/12 is another ex
The PCF plots 10/12 as True and that's incorrect
10/11 Total Vol was 9.2M (2.2M Up Vol, 7.0M Down Vol based on closing at 23.46% of DR)
10/12 Total Vol was 6.2M (5.8M Up Vol, 370K Down Vol based on closing at 94% of DR)
The 5.8M Up Vol on 10/12 is less than the 7.0M Down Vol on 10/11
Even the Total Vol of 6.2M on 10/12 is less than the 7.0M Down Vol on 10/12
It should be False on 10/12 and not True
The Up Vol should be higher then Down Vol in the last 10 days
Thanks
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Up volume was being compared to up volume, to compare it to down volume, please try the following instead.
2 * C > GREATEST(H, C1) + LEAST(L, C1) AND V * IIF(H > L OR H <> C1, (C - LEAST(L, C1)) / (GREATEST(H, C1) - LEAST(L, C1)), 1 / 2) > MAX(V1 * IIF(H1 > L1 OR H1 <> C2, (GREATEST(H1, C2) - C1) / (GREATEST(H1, C2) - LEAST(L1, C2)), 1 / 2), 10)
It also switches from checking for price being above the previous close to price being above the middle of DR for the current bar. You can replace everything before the first AND with C > C1 instead to switch that back if desired.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Platinum Customer
Joined: 3/31/2006 Posts: 3,207
|
This seems to be correct. Let me play with it
For the last few months I decided not to ask this bc I thought it would be too complicated to do this in TC
Thank you! You are amazing
|
|
Platinum Customer
Joined: 3/31/2006 Posts: 3,207
|
Bruce I played with both PCF's one checking for price being above the mid of today's DR and C > C1
I am just curious why we need to check for price to be above the mid of today's DR bc if price is below the middle of its DR that means today's down volume is higher than today's up volume and that alone should eliminate the stock.
when I changed to C > C1 instead of mid-range I got stocks like FBR and TRCO checking true on 11/30
Both stocks closed below the mid of their DR on 11/30.
for ex, FBR closed at the 41.46% of its DR so almost 59% of the volume of that day is counted as Down Vol and 41% as Up Vol
That alone should eliminate the stock unless the PCF is starting to check from yesterday?
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Having down volume greater than up volume would not automatically eliminate the stock unless specifically checked (as in checking for price being above the center of its DR).
Just checking for price being above its previous close will not check for more up volume than down volume for the current bar as that is determined by where price is relative to the total range from the close of the previous bar to the current price (including the high and low of the current bar).
Comparing the up volume to down volume of preivous bars will not check for more up volume than down volume for the current bar either. A high volume day with more down volume than up volume might still have more up volume than the up volume of the current bar. It is even possible that all of the previous bars in the comparison have more down volume than up volume.
It really is entirely up to you on how you want to calculate the formula since the new version isn't a pocket pivot formula. It is your invention and can follow whatever rules you want.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |