Your right the formula specified was not a 14 period ATR. It's the base formula for the ATR indicator.
Before we can create the scan condition, we first have to iterate the basic ATR formula for 14 periods. Then we can setup the condition ...... ATR(14) > C * 0.025.
The formula after we do that will be as follows:
((((H-L+ABS(H-C1)+ABS(L-C1))/2) + ((H1-L1+ABS(H1-C2)+ABS(L1-C2))/2) + ((H2-L2+ABS(H2-C3)+ ABS(L2-C3))/2) + ((H3-L3+ABS(H3-C4)+ABS(L3- C4))/2) + ((H4-L4+ABS(H4-C5)+ABS(L4-C5))/2) + ((H5-L5+ABS(H5-C6)+ABS(L5-C6))/2) + ((H6-L6+ABS(H6-C7)+ABS(L6-C7))/2) + ((H7-L7+ABS(H7-C8)+ABS(L7-C8))/2) + ((H8-L8+ABS(H8-C9)+ABS(L8-C9))/2) + ((H9-L9+ABS(H9-C10)+ABS(L9-C10))/2) + ((H10-L10+ABS(H10-C11)+ABS(L10-C11))/2) + ((H11-L11+ABS(H11-C12)+ABS(L11-C12))/2) + ((H12-L12+ABS(H12-C13)+ABS(L12-C13))/2) + ((H13-L13+ABS(H13-C14)+ABS(L13-C14))/2))/14) > (C*0.025)
To make this a scan condition go to the Library menu & initiate the Conditions menu. Under that menu choose "New Condition Formula". When the "Edit PFC" box pops up, paste the above formula into the box. Test the formula to make sure it works. Fill in the Name box to name your condition. Then save it.
You now have the condition you want to put into a scan.
|
Damn Bruce, isn't there any shorter formula for this ?
|
If you haven't done so yet, you'll have to create a Custom Indicator using your formula. Then it will be available on the indicator menu for you to add to your charts. The formula you've listed is saying that you want to know if Williams %R is greator than or equal to a value of -50. If this is what you're trying to do, then you'll have to create a "Custom PFC % True" indicator. This type of indicator just shows whether your formula condition has been met or not (i.e., wheter the conditon is true or not).
To do this:
(1.) bring up a chart
(2.) go to the "Add Plot to Chart" menu, make sure you're on the indicators tab, then search for & choose to add "Custom PFC % True Indicator" to the chart
(3.) once this indicator is on the chart, you'll have to edit it to add your Williams %R formula
(4.) open the drop-down menu on the newly added indicator & choose the edit function
(5.) type your formula into the formula box, then hit the "test" button to make sure your formula works correctly & doesn't need any corrections (your formula, as listed, is correctly formatted & will work)
(6.) before closing the edit function, name your custom indicator in the label box & make any other changes you want like choosing a color or type of line style
(7.) once the indicator is setup like you prefer, hit the "OK" button & exit the edit function
(8.) now you want to save your custom indicator so that you can add it to charts .... go to the indicator drop-down menu & choose "Save This Indicator"..... in the pop-up box that appears input the indicator name again & hit the OK button ... the indicator is now saved in your indicators list & available to add to charts
(9.) you can now go to any chart & add your new indicator by using the "Add Plot to Chart" funtion again
|
Create a new Easy Scan with the following condition added: "Price as Percent of 52 Week High"
Then edit the condition for what you want. For example, choose the following parameters for the condition:
Less than
Daily (for time frame)
85.00 (for value)
This should bring back all stocks that presently have a price that is at least 15% below their 52 week high.
|
I made one mistake in the formula just posted for the ATR condition. The last part of the formula should be C * 0.025 which is what you wanted. Instead I put C * 0.25. Sorry for the mistake.
|
try the following:
((H-L + ABS(H-C1) + ABS(L-C1)) /2) > C * 0.25
|
Need the formula for getting the number of days since the lates Max High
(e.g., number of days since MaxH50).
|
Bruce,
Thanks for the reply & info.
Question though....... if EXP is the inverse log function, then whey doesn't Worden Bros (or somebody) put that comment or definition in the help files....... instead of just saying EXP = exponent ????
|
EXP is the exponent function in the Worden Help files.
I'm trying to use an exponential function in an indicator I'm creating. However, the EXP command (function) doesn't work correctly & bring back the right value when I test the EXP operator in the "Edit PFC tester". Furthermore, the online Help Files are useless. There are no examples there or instructions on how to correctly use the exponent function.
Using & testing the most basic exponent, 2, brings back a value of 7.39 which is the square root of 54.6121. That makes no sense at all. In addition, there is no way to write the square of the closing price which the indicator writing function will interpret, calculate, & bring back a correct value which can be seperately tested & verified with a scientific calculator.
Why have this function in the program when it's not useable ??
What's the answer ??
|
Bruce,
Thanks for the help/info.
J.M.
|