Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Volume Indicator Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
PiersP
Posted : Tuesday, July 23, 2013 1:21:00 AM
Registered User
Joined: 5/28/2009
Posts: 39

Hi...I'm looking for an indicator that will plot 'up' $ volume minus 'down' $ volume.

This will be best described using a real example. I will use today's trading (7/22) in BIIB.

First, calculate the day's $ volume by taking the avergage of today's High ($234.74) and Low ($222.09) and multiplying it aginst today's volume (2.5M) = $571M.

I then want to split this between up and down $ volume.

Up $ volume would be the Close ($231.67) less the lower of Today's Low ($222.09) or Yesterday's Close ($230.27) = $9.58, which then has to be divided into Today's true range ($12.65) = 75.7%, which would then be multiplied into Today's $ Volume of $571M = $432.5M.

Down $ volume would be the Close ($231.67) less the higher Today's High ($234.74) or Yesterday's Close ($230.27) = -$3.07, which then has to be divided into Today's true range ($12.65) = -24.3%, which would then be multiplied into Today's $ Volume of $571M = -$138.6M.

Adding the Up $ volume to the Down $ volume = $293.9M of Up $ volume

Many thanks!

 

Up $ volume is:

1. Today's close (C) less the lower of today's low (L) or yesterday's close (C1)

2. Divide the above into the day's true range

 

Up volume is c

 

, where up volume is assign daily $ volume that plots a volume accumulation line to create an indicator that attributes daily $ volume to either accumulation or distribution.

I want to consider the each day's true range in the calculation.

Using BIIB as an example...on the 28th of June it gapped higher but closed on its lows. The day's true range is $15.82 ($224.63 High less $208.81 previous close). Of this, I would assign 40% of the day's volume to Distribution

 

Bruce_L
Posted : Tuesday, July 23, 2013 9:05:37 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

Please try using the following Indicator Formula as the Formula in a Custom PCF Indicator:

V * (H + L) * ((2 * C - L - C1 + ABS(L - C1)) / (H - L + ABS(H - C1) + ABS(L - C1)) - .5)

PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
PiersP
Posted : Monday, August 5, 2013 8:21:22 AM
Registered User
Joined: 5/28/2009
Posts: 39

Thanks Bruce! If I add a 10 period exponential moving average to this indicator can I then create a scan condition based on the EMA? Or do we have to add to the formula you provided below?

Bruce_L
Posted : Monday, August 5, 2013 8:26:31 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

You should be able to add a 10-period exponential moving average to the Custom PCF Indicator and then click on the moving average and select Create Scan Condition to create a Condition.

Create Conditions from Your Chart



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
kkelliher
Posted : Monday, September 2, 2013 5:36:13 PM
Registered User
Joined: 8/20/2013
Posts: 8

Hi Bruce,  Another question related to volume.  How Can I say yesterdays volume is below the Exp Moving Average 50.  I was thinking something like V1 < Exp Moving Average 50 - but when I test the forumla it says argument missing near Exp  Thanks.

kkelliher
Posted : Monday, September 2, 2013 5:37:32 PM
Registered User
Joined: 8/20/2013
Posts: 8

I am a platinum sub so I can compare previous day data.

kkelliher
Posted : Monday, September 2, 2013 5:43:53 PM
Registered User
Joined: 8/20/2013
Posts: 8

Also if I say the following V >= 3.25 * AVGV13.0 would this mean that I would find stocks that are doing 1/4 of yesterday's volume within the first 30 minutes?

Bruce_L
Posted : Tuesday, September 3, 2013 8:51:19 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

QUOTE (kkelliher)
How Can I say yesterdays volume is below the Exp Moving Average 50.

If you mean the current 50-period exponential moving average of volume:

V1 < XAVGV50

If you mean the 50-period exponential moving average of volume at the time:

V1 < XAVGV50.1

If you mean the 50-period exponential moving average of volume prior to yesterday's bar:

V1 < XAVGV50.2

QUOTE (kkelliher)
Also if I say the following V >= 3.25 * AVGV13.0 would this mean that I would find stocks that are doing 1/4 of yesterday's volume within the first 30 minutes?

Your formula is for the volume of the current bar being greater than or equal to 3.25 times the 13-period simple moving average of volume (including the current bar).

You can check for the volume of the day so far being at least 1/4 of yesterday's total volume using the following daily Condition Formula:

V >= .25 * V1

You could use a 30-minute time frame to check that the current bar has at least 1/4 of the volume of the previous thirteen 30-minute bars:

V >= 3.25 * AVGV13.1

But there is no way to specify the time of day of the 30-minute bar of interest. So once you are out of the first 30-minute bar of the day, the formula would no longer be checking for the first 30-minutes versus the total volume of the previous day.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
kkelliher
Posted : Tuesday, September 3, 2013 12:09:12 PM
Registered User
Joined: 8/20/2013
Posts: 8

thank you

kkelliher
Posted : Tuesday, September 3, 2013 4:31:59 PM
Registered User
Joined: 8/20/2013
Posts: 8

Is there a way to tell the program to scan for just green volume bars?  Also is there a way to backtest the scanner that I have created.  By backtest I really mean scan historical data to see what stocks the scanner would have pulled up from 9:30am to 10am. Thank you.

Bruce_L
Posted : Tuesday, September 3, 2013 5:11:00 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

Volume bars are green when C > C1, so you can add that to your existing Condition Formula using an AND statement. So for example, if you are currently checking for:

V >= .25 * V1

And you also wanted the bar to be green, it would be:

V >= .25 * V1 AND C > C1

TC2000 does not have any built in backtesting features, but if the requirements can be expressed using the Personal Criteria Formula Language, it is possible to use that PCF as the Boolean Formula in a Custom PCF % True Indicator to get a spike on the chart to visualize when the PCF was true for a formula in the past.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
kkelliher
Posted : Wednesday, September 4, 2013 1:43:16 AM
Registered User
Joined: 8/20/2013
Posts: 8

One more if you don't mind.  Find stocks today that on the first 15 min bar that are doing volume greater than the volume done on the last five days average first 15 min bars. If I wanted to go one step further and say find stocks today that on the first 15 min bar that are doing volume greater than 120% the volume done on the last five days average first 15 min bars.  Thanks.

Bruce_L
Posted : Wednesday, September 4, 2013 8:06:31 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

As stated previously, there is no way to specify the time of day of intraday bars. So once you are out of the first bar of the day, the following formulas will no longer be checking based on the desired bars.

So if you just wanted to check for the volume to be greater than average:

5 * V > V26 + V52 + V78 + V104 + V130

Checking for the volume to be greater than 120% of average:

V > 1.2 * (V26 + V52 + V78 + V104 + V130)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
kkelliher
Posted : Tuesday, September 10, 2013 1:13:20 AM
Registered User
Joined: 8/20/2013
Posts: 8

Hello.  I understand  there is no way to specify the time of day of intraday bars, but on the easy scan is there a way to add a time column.  So say a scan triggers AAPL at 9:38am and the scan triggers FFIV at 9:45am, is there a time column that can be added to indicate when the scan triggered (9:38 am, 9:45 am).  Thanks. 

Bruce_L
Posted : Tuesday, September 10, 2013 7:50:38 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

No, there is no way to add a WatchList Column for when a scan triggered (either first triggered or most recently triggered).



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
kkelliher
Posted : Tuesday, September 17, 2013 12:33:59 AM
Registered User
Joined: 8/20/2013
Posts: 8

I'm looking to create a scan that will look for stocks on a weekly chart, where last week price closed within 2.2% of the week before and that week closed within 2.2% of the week before.  So for example last week price closes at 87.69, the week before that price close at 87.29, and the week before that price closes at 87.18.  I want to be able to find stocks that have these tight weekly closes within 2.2% of each other.    I know its C5, C10, etc but not sure how to incorporate the 2.2%.                                                                                                                                                                                                          Also, how can I find stocks on a weekly timeframe that is up say 10% within say  3 months.  Thanks

Bruce_L
Posted : Tuesday, September 17, 2013 7:30:32 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

If you are using a daily time frame, the 2.2% formula for weeks would be:

ABS(C5 / C10 - 1) <= .022 AND ABS(C10 / C15 - 1) <= .022

But you might want to consider a weekly time frame for the Condition Formula instead (you can set the time frame when creating or editing the formula):

ABS(C1 / C2 - 1) <= .022 AND ABS(C2 / C3 - 1) <= .022

If you are using a daily time frame, the 10% formula for months would be:

ABS(C21 / C42 - 1) <= .1 AND ABS(C42 / C63 - 1) <= .022

But again, you might want to considure a monthly time frame instead:

ABS(C1 / C2 - 1) <= .1 AND ABS(C2 / C3 - 1) <= .022



-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.