Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
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: 65,138
|
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: 65,138
|
You should be able to just highlight the formula, right-click on it and select copy. If copy doesn't appear as an option try ctrl-c instead.
As far as pasting, you should be able to just right-click and paste on the TC2000 v7 side as well. If paste doesn't as an option, try ctrl-v 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: 65,138
|
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: 65,138
|
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: 65,138
|
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
|
|
Guest-1 |