Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Help w/ Volume Formula & 21 Day volume EMA Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
chrischapman
Posted : Sunday, December 3, 2017 6:53:54 PM
Gold Customer 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 !

  

 

Bruce_L
Posted : Monday, December 4, 2017 10:54:48 AM


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
chrischapman
Posted : Tuesday, December 5, 2017 11:23:17 AM
Gold Customer 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 

Bruce_L
Posted : Tuesday, December 5, 2017 11:26:33 AM


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
chrischapman
Posted : Tuesday, December 5, 2017 2:32:54 PM
Gold Customer 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

  

 
Bruce_L
Posted : Tuesday, December 5, 2017 2:41:49 PM


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
chrischapman
Posted : Tuesday, December 5, 2017 4:33:14 PM
Gold Customer 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

chrischapman
Posted : Friday, December 8, 2017 12:01:07 PM
Gold Customer 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

   

Bruce_L
Posted : Friday, December 8, 2017 12:12:08 PM


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
chrischapman
Posted : Saturday, December 9, 2017 9:49:45 AM
Gold Customer 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

 

chrischapman
Posted : Thursday, January 25, 2018 2:41:06 PM
Gold Customer 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 

 
Bruce_L
Posted : Thursday, January 25, 2018 2:51:22 PM


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
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.