New Mathematical Functions—SI Pro
Download printable PDFBeginning with Stock Investor 3.5, we have added a variety of mathematical expressions that you can use in creating custom fields within the Custom Field Editor. You can access these expressions from the pulldown menu on the lower right side of the Custom Field Editor (Figure 1). The expressions now available in Stock Investor Pro include:
Stock Investor Pro
Share this articleReturns the absolute value of [x]. 



Returns the next highest integer that is greater than or equal to [x]. Rounds the number whose next highest integer CEILING() returns. 



Returns the value e^[x]. The value of e, the base of natural logs, has an approximate value of 2.72. 



Returns the future value of a financial investment. [x] represents the constant periodic payment (in decimal format), [y] is the periodic interest rate (if payments are made monthly, divide the annual interest rate by 12), and [z] is the number of periods over which the payments are made. The function assumes that payments are made at the end of each period. 



Returns the nearest integer that is less than or equal to [x]. 



Returns the compounded growth rate from [y] to [x] over [z] periods. 



Evaluates the logical expression [x] and then returns one of two expressions. If [x] is true, IIF() returns [y]. If [x] is false, IIF() returns [z]. 



Evaluates [x] and returns the integer (nonfraction) portion of the expression. 



If the value of [x] is NULL, 0 is returned, otherwise 1 is returned. 

Evaluates a set of expressions—x1, , [xn] (up to 24 values) and returns the expression with the highest value. 



Returns the lowest value in the list from [x1] to [xn] (up to 24 values). 



Returns the payment amount on a loan with beginning principal [x], fixed interest rate per period in decimal format [y] (if monthly payments are made on the load but the interest rate is annual, divide the annual interest rate by 12), and the total number of payments [z]. The function assumes a constant periodic interest rate and that payments are made at the end of each period. 



Returns the present value of an investment where [x] is the periodic payment amount (assumes that payments are made at the end of the period), [y] is the periodic interest rate in decimal format (if the interest rate is annual and payments are made monthly, divide the annual interest rate by 12), and [z] is the total number of payments. 



Returns a 1 if [x] is positive, –1 if [x] is negative, and 0 if [x] is zero. 


