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
|
|
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
|
|
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?
|
|
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
|
|
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.
|
|
Registered User Joined: 8/20/2013 Posts: 8
|
I am a platinum sub so I can compare previous day data.
|
|
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?
|
|
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
|
|
Registered User Joined: 8/20/2013 Posts: 8
|
thank you
|
|
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.
|
|
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
|
|
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.
|
|
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
|
|
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.
|
|
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
|
|
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
|
|
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
|
|
Guest-1 |