Gold Customer
Joined: 3/22/2005 Posts: 40

Hello:
I need help writing a PCF formula for 1 month volume ranked according to the percentage the 1 month volume bar is above its volume EMA to the lowest percentage below its volume EMA.
So, to understand my question please open a one day stock chart showing volume bars with a 21 day volume EMA in a window. Now switch the chart to a 1 month view.
So, looking at the 1 monh view of a chart think of the volme EMA as the "zero" line. How do I scan & rank stocks that their 1 month volume is 200 or 300% above the volume EMA al the way down to stocks that the 1 month volume bars are at 20 or 30% below the EMA line.
The scan would sort stocks with the highest 1 month volume bar above the EMA line to the stocks with the 1 month volume most below its EMA.
The formula I currently use shows these stocks but won't rank them from highest to lowest.
Your help would be greatly appreciated !


Worden Trainer
Joined: 10/7/2004 Posts: 63,025

You could use the following Personal Criteria Formula as a sort in TC2000 v7, but it requires about 6 years of data to calculate.
100 * (AVGV21 / (.090995658 * (AVGV21 + 10 / 11 * (AVGV21.21 + 10 / 11 * (AVGV21.42 + 10 / 11 * (AVGV21.63 + 10 / 11 * (AVGV21.84 + 10 / 11 * (AVGV21.105 + 10 / 11 * (AVGV21.126 + 10 / 11 * (AVGV21.147 + 10 / 11 * (AVGV21.168 + 10 / 11 * (AVGV21.189 + 10 / 11 * (AVGV21.210 + 10 / 11 * (AVGV21.231 + 10 / 11 * (AVGV21.252 + 10 / 11 * (AVGV21.273 + 10 / 11 * (AVGV21.294 + 10 / 11 * (AVGV21.315 + 10 / 11 * (AVGV21.336 + 10 / 11 * (AVGV21.357 + 10 / 11 * (AVGV21.378 + 10 / 11 * (AVGV21.399 + 10 / 11 * (AVGV21.420 + 10 / 11 * (AVGV21.441 + 10 / 11 * (AVGV21.462 + 10 / 11 * (AVGV21.483 + 10 / 11 * (AVGV21.504 + 10 / 11 * (AVGV21.525 + 10 / 11 * (AVGV21.546 + 10 / 11 * (AVGV21.567 + 10 / 11 * (AVGV21.588 + 10 / 11 * (AVGV21.609 + 10 / 11 * (AVGV21.630 + 10 / 11 * (AVGV21.651 + 10 / 11 * (AVGV21.672 + 10 / 11 * (AVGV21.693 + 10 / 11 * (AVGV21.714 + 10 / 11 * (AVGV21.735 + 10 / 11 * (AVGV21.756 + 10 / 11 * (AVGV21.777 + 10 / 11 * (AVGV21.798 + 10 / 11 * (AVGV21.819 + 10 / 11 * (AVGV21.840 + 10 / 11 * (AVGV21.861 + 10 / 11 * (AVGV21.882 + 10 / 11 * (AVGV21.903 + 10 / 11 * (AVGV21.924 + 10 / 11 * (AVGV21.945 + 10 / 11 * (AVGV21.966 + 10 / 11 * (AVGV21.987 + 10 / 11 * (AVGV21.1008 + 10 / 11 * (AVGV21.1029 + 10 / 11 * (AVGV21.1050 + 10 / 11 * (AVGV21.1071 + 10 / 11 * (AVGV21.1092 + 10 / 11 * (AVGV21.1113 + 10 / 11 * (AVGV21.1134 + 10 / 11 * (AVGV21.1155 + 10 / 11 * (AVGV21.1176 + 10 / 11 * (AVGV21.1197 + 10 / 11 * (AVGV21.1218 + 10 / 11 * (AVGV21.1239 + 10 / 11 * (AVGV21.1260 + 10 / 11 * (AVGV21.1281 + 10 / 11 * (AVGV21.1302 + 10 / 11 * (AVGV21.1323 + 10 / 11 * (AVGV21.1344 + 10 / 11 * (AVGV21.1365 + 10 / 11 * (AVGV21.1386 + 10 / 11 * (AVGV21.1407 + 10 / 11 * (AVGV21.1428 + 10 / 11 * (AVGV21.1449 + 10 / 11 * (AVGV21.1470 + 10 / 11 * (AVGV21.1491 + 10 / 11 * (AVGV21.1512))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))  1)
Bruce Personal Criteria Formulas TC2000 Support Articles


Gold Customer
Joined: 3/22/2005 Posts: 40

Hi Buce, many thanks, your the best. Is there a way to copy your formula from your post and create a PCF in TC2000 V7?
Thanks
Cris


Worden Trainer
Joined: 10/7/2004 Posts: 63,025

You should be able to just highlight the formula, rightclick on it and select copy. If copy doesn't appear as an option try ctrlc instead.
As far as pasting, you should be able to just rightclick and paste on the TC2000 v7 side as well. If paste doesn't as an option, try ctrlv instead.
How to create a Personal Criteria Forumula (PCF)
Bruce Personal Criteria Formulas TC2000 Support Articles


Gold Customer
Joined: 3/22/2005 Posts: 40

Hi Bruce, It copied over well per your instructions. I created a new PCF and tested and saved it. then I let the system recalculate but it does not update. The collumn which says "updated Through" indicates "Not Calculated" even though I performed the procedure to update several times.
Any thoughs or coments?
Thanks in avance
Chris


Worden Trainer
Joined: 10/7/2004 Posts: 63,025

Do you have Include criteria which require more tha 250 days of history (slower) selected?
Because as noted in the original response, this formula requires about 6 years of data to calculate. That estimate is probably a bit low actually, because you have to add 21 months on top of that... so about 8 years. In any case, both are more than 250 trading days (which is about 1 year).
Bruce Personal Criteria Formulas TC2000 Support Articles


Gold Customer
Joined: 3/22/2005 Posts: 40

Hi Bruce, you're spot on! It works like a charm! Thanks for reminding to update by selecting stocks with more than 250 days of history.
Many thanks
Chris


Gold Customer
Joined: 3/22/2005 Posts: 40

Hi Bruce, hope you are well.
I'm working with your formula posted 12/4 and it's saving me a lot of time.
Could your formula be adapted to only select 1 month volume bars which have a poitive 1 month price peformance (1 month green bars as opposed to 1 month red bars)?
As you recall, the goal is to rank stocks which the 1 month volume is far above its 1 month EMA to the lowest 1 month volume below its EMA. This 1 monh volume searh produces stocks with positive and negative 1 month price performance.
By eliminating stocks with negative1 month price perfomance would produce a perfect list of stocks that have positie 1 month price and volume performane and it would save even more time.
Any guidance is indeed appreciated.
Chris


Worden Trainer
Joined: 10/7/2004 Posts: 63,025

You could create an EasyScan using the following Personal Criteria Formula as an EasyScan and then just sort it using the other formula.
C > C21 AND AVGV21.1512 = AVGV21.1512
Using EasyScan to find stocks that meet your own criteria
The C > C21 portion checks for the most recent volume bar being green and the AVGV21.1512 = AVGV21.1512 portion verifies that there is enough data available to calculate the other formula.
Bruce Personal Criteria Formulas TC2000 Support Articles


Gold Customer
Joined: 3/22/2005 Posts: 40

Thanks Bruce, I think your solution is a good one. I'll try it.
Have a good weekend.
Chrs


Gold Customer
Joined: 3/22/2005 Posts: 40

Hi Bruce, hope you had a good start in 2018. I've organied the 2 formulas you provided above into a sorting method and am truly thankful to you for helping me obtain good results.
I'm now woking to develop a smilar method for large cap stocks and am wondering if you had the time to help. I need to adjust the 2 formulas you provided on Dec. 4 & 8 for searches based on 9 days rather than one month (21 days).
Do you have in your files the above fomulas base on 9 days and would you send them to me? I don't beieve it's as simple as replacing the number 9 everywhere the numer 21 appears in the formulas or is it?
Your guidane is alwayswelcome.
Chris


Worden Trainer
Joined: 10/7/2004 Posts: 63,025

Is it still a 21 period exponential moving average or do you want to change that to 9 as well?
Bruce Personal Criteria Formulas TC2000 Support Articles


Guest1 