Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Profile: jackmerz
About
User Name: jackmerz
Groups: Beta Testers, Gold User, Member, Platinum User, TeleChart
Rank: Registered User
Real Name:
Location
Occupation:
Interests:
Gender: Unsure
Statistics
Joined: Thursday, December 2, 2004
Last Visit: Monday, August 3, 2015 3:57:27 AM
Number of Posts: 17
[0.01% of all post / 0.00 posts per day]
Avatar
Last 10 Posts
Topic: ATR condition
Posted: Sunday, March 22, 2015 3:40:01 PM

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.

 

 

Topic: PCF formula for Number of periods
Posted: Saturday, March 21, 2015 9:52:14 PM

Damn Bruce, isn't there any shorter formula for this ?

Topic: Williams %R - how to display on a chart
Posted: Saturday, March 21, 2015 9:38:22 PM

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

 

Topic: 52week high scan
Posted: Saturday, March 21, 2015 8:19:31 PM

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.

Topic: ATR condition
Posted: Saturday, March 21, 2015 7:54:11 PM

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.

Topic: ATR condition
Posted: Saturday, March 21, 2015 7:48:31 PM

try the following: 

((H-L + ABS(H-C1) + ABS(L-C1)) /2) > C * 0.25 

 

Topic: Formula for days since last MaxHigh
Posted: Saturday, March 21, 2015 7:24:06 PM

Need the formula for getting the number of days since the lates Max High

(e.g., number of days since MaxH50).

Topic: EXP operator in Worden Help Database
Posted: Friday, August 9, 2013 2:53:12 PM

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 ????

Topic: EXP operator in Worden Help Database
Posted: Friday, August 9, 2013 2:28:45 PM

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 ?? 

Topic: Need formla for : YTD Price Change
Posted: Friday, September 23, 2011 2:22:28 PM
Bruce, 
 
Thanks for the help/info. 
 
J.M.