| jrixey |
|
Gold User, Member, Platinum User, TeleChart
|
| Registered User |
|
|
|
|
| Unsure |
|
| Thursday, October 7, 2004 |
| Wednesday, October 29, 2014 2:21:48 PM |
45
[0.02% of all post / 0.01 posts per day] |
|
|
Bruce - your firmua is working great. Thanks verymuch for your help!
|
|
Hi! I have a pcf which looks for compression - in other words, "todays" bar's Open - Close value is 25% or less of the High - Low range of the previous bar. I have the code written as: abs(O-C) <=(H1-L1)*.25.
i am getting bizzare reuts where the scan flags charts where todays bar is much lager than yesterday's. The scan had ben working fine untl recently. Ay idea what is going on or how I need to re-write tthe pcf to get the desired results?
Thanks vey much!
|
|
Your formula is perfect - thanks very much!
|
|
Hi - I am working on a pcf condition which finds situations where the Open - Close of todays bar is less than 25% of the daily range of the prior days bar. I have written the pcf as SQR((O-C)*(O-C))<=(H1-L1)*.25. I have used thwe square root of the square of the open - close range so that the result is a positive number reguardless of whether the bar closes higher or lower on the day. When I use this formula to scan a list of 85 stocks, it returns very few positive results and misses many stocks which return "true" when the condition is checked on the individual stocks.
I also have modified the formula to look for the same result when comparing yesterdays open / close range versus the daily range from two day ago. I have written the modified formula as SQR((O1-C1)*(O1-C1))<=(H2-L2)*.25 This version of the pcf always returns every stock in my scan list as "true" even though most of the stocks do not meet the criterea.
Do you have any idea of what I am doing wrong?
Thanks very much!!!!!!!
I would be thrilled to have you call me at 5123-919-1233 as this is driving me crazy
|
|
Thanks, Bruce! What is the ".z" after the "x" in so many of the formulas?Thanks
|
|
Hi - If I want to write a condition in SF12 looking for situations where "todays" volume is 50% greater than the 20 day average volume, is the formula V>(Avg(V,20)*1.50)?Thanks very much!
|
|
That is a thing of beauty, Bruce! Thanks VERY much!!
|
|
Bruce - Got it in the program but it's still not quite what i'm looking for. What if we add the requirement that the open and close are in the upper half of an up bar or the lower half of a down bar? Also, for an up bar, the last must be above the open, and for a down bar the last must be below the open. In other words, I'm looking for "hammers" and "shooting stars" in candlestick terms.Thanks for putting up with me!
|
|
Sorry I Didn't make this clear! "Upbar" or "Downbar" would be an additional requirement, meanig the the close (most recent price) is above or below, respectively the bar's open. Sorry again for the confusion!
|
|
Thanks very much! How would I combine those into a single condition which would look for either part to be true?
|
|