Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

EXP operator in Worden Help Database Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
jackmerz
Posted : Friday, August 9, 2013 2:28:45 PM
Registered User
Joined: 12/2/2004
Posts: 17

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_L
Posted : Friday, August 9, 2013 2:43:35 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

The EXP() function is the natural exponential function and is the inverse of the LOG() or natural logarithm function. So EXP(2) is the same as e2

PCF Formula Descriptions

If you wanted to raise something to the power of 2, you would use ^ 2. So for example 3 ^ 2 = 9. You could raise something to the power of 1/2 to get the square root or you could use the SQR() function. So for example both 9 ^ (1 / 2) = 3 and SQR(9) = 3.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
jackmerz
Posted : Friday, August 9, 2013 2:53:12 PM
Registered User
Joined: 12/2/2004
Posts: 17

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

Bruce_L
Posted : Friday, August 9, 2013 3:04:17 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

I will see what I can do about getting the label changed in the help files.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.