|
Hi Bruce...in the squeeze formula provided above by Telework, could you please amend to base it on a 13 period moving average?
The formula provided was:
(SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 - 20 * AVGC20 ^ 2) / 20) * 4 / 3 / ((AVGH20 - AVGL20) / 2 + (ABS(H - C1) + ABS(L - C1) + ABS(H1 - C2) + ABS(L1 - C2) + ABS(H2 - C3) + ABS(L2 - C3) + ABS(H3 - C4) + ABS(L3 - C4) + ABS(H4 - C5) + ABS(L4 - C5) + ABS(H5 - C6) + ABS(L5 - C6) + ABS(H6 - C7) + ABS(L6 - C7) + ABS(H7 - C8) + ABS(L7 - C8) + ABS(H8 - C9) + ABS(L8 - C9) + ABS(H9 - C10) + ABS(L9 - C10) + ABS(H10 - C11) + ABS(L10 - C11) + ABS(H11 - C12) + ABS(L11 - C12) + ABS(H12 - C13) + ABS(L12 - C13) + ABS(H13 - C14) + ABS(L13 - C14) + ABS(H14 - C15) + ABS(L14 - C15) + ABS(H15 - C16) + ABS(L15 - C16) + ABS(H16 - C17) + ABS(L16 - C17) + ABS(H17 - C18) + ABS(L17 - C18) + ABS(H18 - C19) + ABS(L18 - C19) + ABS(H19 - C20) + ABS(L19 - C20)) / 40 + .000001))-1
Many thanks,
Piers
|
|
Hi...I'm thinking of ways to scan for stocks that have been in a smooth uptrend over the last 12 months. Is it possible to write a PCF whereby:
1. high and low for month 2 > high and low for month 1
2. high and low for month 3 > high and low for month 2
etc. up to month 12?
Also...I'm sure you have been asked similar questions before so if you can point me to previous responses that would also be great.
Many thanks,
Piers
|
|
Hi Bruce....I came accross a link you posted called Custom historical pivots...which I have tried to adapt (without success).
I want to plot a dot above a price bar when the 5 bars following neither close nor exceed the high of that bar.
I also want to do the reverse i.e. plot a dot below a price bar when the 5 bars following neither close nor exceed the low of that bar.
Can you assist with a PCF?
Thanks in advance,
Piers
|
|
Hi...I want to scan for stocks that have been trending up in an orderly fashion over the last 6 months.
I want to avoid stocks that have gapped up massivly and just moved sideways since...or stocks that make large moves up and down.
A good example of what I am looking for is HTLF. If you plot a 150 day linear regression line you can see how closely price has stuck to this line...it's been a fast but orderly ascent.
Is such a scan possible?
Many thanks!
|
|
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?
|
|
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
|
|
Hi there...in my watchlist of stocks I want to include a column that displays a retracement %.
I want to show the retracement % as it relates to the most recent swing point high (SPH) and swing point low (SPL) [for a stock that has made a move up] and SPL and SPH [for a stock that has made a move down].
SPH and SPL would be based on the highest high/lowest low over the previous 5 bars.
So if I am looking at stocks with upward momentum and stock A has a SPH of 110 and a SPL that preceded it of 100, and price is 108...then I would see 20% displayed against stock A in my watchlist. I might then chose to hang off buying the stock as I want to see at least 25% of the recent move up retraced.
Is it possible to do something like this?
Thanks!
|
|
Hi...I know how to import a list of stock symbols but is it possible to import additional data points? For example, if I also wanted to import the implied volatility for each stock is there a way to do this?
Thanks!
|
|
Hi..please ignore...I have seen my error
|
|
Hi...I want to reflect my scan criteria as an indicator on my chart using the PCF % True Indicator.
Here is my scan criteria:
C>AVGC50 AND AVGC7 / AVGC65 >= 100 AND H - C <= .25 * (H -L + ABS(H - C1) + ABS(C1 - L)) / 2 AND H - L >= (AVGH20 - AVGL20) / 2 + (ABS(H - C1) + ABS(C1 - L) + ABS(H1 - C2) + ABS(C2 - L1) + ABS(H2 - C3) + ABS(C3 - L2) + ABS(H3 - C4) + ABS(C4 - L3) + ABS(H4 - C5) + ABS(C5 - L4) + ABS(H5 - C6) + ABS(C6 - L5) + ABS(H6 - C7) + ABS(C7 - L6) + ABS(H7 - C8) + ABS(C8 - L7) + ABS(H8 - C9) + ABS(C9 - L8) + ABS(H9 - C10) + ABS(C10 - L9) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13) + ABS(H14 - C15) + ABS(C15 - L14) + ABS(H15 - C16) + ABS(C16 - L15) + ABS(H16 - C17) + ABS(C17 - L16) + ABS(H17 - C18) + ABS(C18 - L17) + ABS(H18 - C19) + ABS(C19 - L18) + ABS(H19 - C20) + ABS(C20 - L19)) / 40 AND C>O AND C > C1 AND V>AVGV50
It's all fairly self explanatory except perhaps the 4th crtieria which is just asking that the range of today's bar exceed the average true range for the last 20 days.
When I put this into the formula box I don't get any true results.
Could let me know what I am doing wrong?
Thanks,
Piers
|