dduhon |
Gold User, Member, Platinum User, TeleChart
|
Registered User |
|
|
|
|
Unsure |
|
Thursday, April 27, 2006 |
Monday, January 3, 2011 6:34:21 PM |
10 [0.00% of all post / 0.00 posts per day] |
|
How would I create a weekly moving average pcf.
Would this be the proper format:
AVGC20 > AVGC20.5
if I wanted the 20 week moving average to be above the previous week's 20 week moving average?
Don Duhon
|
Hello,
How does one get to the club mentioned in this post?
.Savradbottomspringers Jr. club (internal TC Net)
Thanks.
Don
|
Craig,
That - sign was magic. It works!
Many thanks.
Don Duhon
|
Craig,
I was thinking I could put in a variable.
But if I had to choose a fixed time frame, I would choose 3 days.
Thanks.
Don
|
Craig and diceman
Thanks for comments.
Yes, I want to scan for prices above or below the bands on stocks that would tend to be outside for a while instead of bouncing out and into the bands to quickly.
I thought there might be some way to scan for stocks that would tend to work well with the acceleration band method. The diceman comment on volatility was what I may have been thinking.
Also, some of Headley's comments inply that this method works better with some stocks than others. So I'm trying to get a list of stock that I could run this scan on.
Thanks again.
Don
|
Thanks for reply.
I changed the Hx to Lx to show prices below acceleration band but can't figure out why it doesn't work properly.
Can you see any error I made?
C <= 0.05*(L0*(1+4*(H0-L0)/(H0+L0))+ L1*(1+4*(H1-L1)/(H1+L1))+ L2*(1+4*(H2-L2)/(H2+L2))+ L3*(1+4*(H3-L3)/(H3+L3))+ L4*(1+4*(H4-L4)/(H4+L4))+ L5*(1+4*(H5-L5)/(H5+L5))+ L6*(1+4*(H6-L6)/(H6+L6))+ L7*(1+4*(H7-L7)/(H7+L7))+ L8*(1+4*(H8-L8)/(H8+L8))+ L9*(1+4*(H9-L9)/(H9+L9))+ L10*(1+4*(H10-L10)/(H10+L10))+ L11*(1+4*(H11-L11)/(H11+L11))+ L12*(1+4*(H12-L12)/(H12+L12))+ L13*(1+4*(H13-L13)/(H13+L13))+ L14*(1+4*(H14-L14)/(H14+L14))+ L15*(1+4*(H15-L15)/(H15+L15))+ L16*(1+4*(H16-L16)/(H16+L16))+ L17*(1+4*(H17-L17)/(H17+L17))+ L18*(1+4*(H18-L18)/(H18+L18))+ L19*(1+4*(H19-L19)/(H19+L19)))
Don
|
This formula works to find a stock price above Headley's acceleration bands.
C >= 0.05*(H0*(1+4*(H0-L0)/(H0+L0))+ H1*(1+4*(H1-L1)/(H1+L1))+ H2*(1+4*(H2-L2)/(H2+L2))+ H3*(1+4*(H3-L3)/(H3+L3))+ H4*(1+4*(H4-L4)/(H4+L4))+ H5*(1+4*(H5-L5)/(H5+L5))+ H6*(1+4*(H6-L6)/(H6+L6))+ H7*(1+4*(H7-L7)/(H7+L7))+ H8*(1+4*(H8-L8)/(H8+L8))+ H9*(1+4*(H9-L9)/(H9+L9))+ H10*(1+4*(H10-L10)/(H10+L10))+ H11*(1+4*(H11-L11)/(H11+L11))+ H12*(1+4*(H12-L12)/(H12+L12))+ H13*(1+4*(H13-L13)/(H13+L13))+ H14*(1+4*(H14-L14)/(H14+L14))+ H15*(1+4*(H15-L15)/(H15+L15))+ H16*(1+4*(H16-L16)/(H16+L16))+ H17*(1+4*(H17-L17)/(H17+L17))+ H18*(1+4*(H18-L18)/(H18+L18))+ H19*(1+4*(H19-L19)/(H19+L19)))
How would I create this formula to show the stock price below the bottom band?
Thanks.
Don Duhon
|
For the Higher Band formula on accelation bands, how would one use the lower band, and finds closes below the lower band?
Thanks,
Don Duhon
Finding symbols where Price is at or above the band for today using a Personal Criteria Formula is fairly easy and probably quicker than a Visual Difference Sort (at least for large Watchlists):
C >= 0.05*(H0*(1+4*(H0-L0)/(H0+L0))+ H1*(1+4*(H1-L1)/(H1+L1))+ H2*(1+4*(H2-L2)/(H2+L2))+ H3*(1+4*(H3-L3)/(H3+L3))+ H4*(1+4*(H4-L4)/(H4+L4))+ H5*(1+4*(H5-L5)/(H5+L5))+ H6*(1+4*(H6-L6)/(H6+L6))+ H7*(1+4*(H7-L7)/(H7+L7))+ H8*(1+4*(H8-L8)/(H8+L8))+ H9*(1+4*(H9-L9)/(H9+L9))+ H10*(1+4*(H10-L10)/(H10+L10))+ H11*(1+4*(H11-L11)/(H11+L11))+ H12*(1+4*(H12-L12)/(H12+L12))+ H13*(1+4*(H13-L13)/(H13+L13))+ H14*(1+4*(H14-L14)/(H14+L14))+ H15*(1+4*(H15-L15)/(H15+L15))+ H16*(1+4*(H16-L16)/(H16+L16))+ H17*(1+4*(H17-L17)/(H17+L17))+ H18*(1+4*(H18-L18)/(H18+L18))+ H19*(1+4*(H19-L19)/(H19+L19)))
The problem in writing the formula for this being the first time Price is at or above the band in the last 30, 60 or 90 days is that the you have to make sure it is below the band the previous 29, 59 or 89 days as well.
-------------------------------------------------------------------------------- -Bruce
|
Hello All,
Does anyone know how to create a scan that would provide a list of stocks that would work well using the Acceleration Bands formula that i2d2 provided?
Thanks.
Don Duhon
|
|