Investment Studio > Expressions > Functions > Alphabetic list

A B C D E F G H I K L M N O P Q R S T U V W X Y Z

Result type Function name Arguments
float abs (float argument)
float accrint (date issue_date, date first_interest_date, date interest_date, float annual_interest_rate, float par_value = 1000, integer payments_per_year, integer day_count_basis = 0)
float accrintm (date issue_date, date maturity_date, float annual_interest_rate, float par_value = 1000, integer day_count_basis = 0)
float array[*][2] acd (float array[*][5] dhlcv, float previous_acd = 0)
float acos (float argument)
float acosh (float argument)
string address (integer row_number, integer column_number, integer absolute = 1)
float array[*][2] adx (float array[*][4] dhlc, integer days = 14, float previous_adx = 0)
float array[*][2] adxr (float array[*][4] dhlc, integer days = 14, float previous_adxr = 0)
float array[*][2] ard (float array[*][2] dc, integer days)
float array[*][2] aro (float array[*][2] dc, integer days)
array array (reference cell_reference)
float array[*][2] aru (float array[*][2] dc, integer days)
float array[*][2] asi (float array[*][5] dohlc, float limit_move = 10000, float previous_asi = 0)
float asin (float argument)
float asinh (float argument)
float asset_ask (integer asset_index, date quote_date)
float asset_ask_size (integer asset_index, date quote_date)
float asset_bid (integer asset_index, date quote_date)
float asset_bid_size (integer asset_index, date quote_date)
float asset_close (integer asset_index, date quote_date)
string asset_currency (integer asset_index)
float array[*][2] asset_fee_flows (integer asset_index, date start_date, date end_date, float start_flow = 0, float end_flow = 0)
float asset_fees (integer asset_index, date start_date, date end_date)
float asset_first_trade (integer asset_index)
string asset_flag (integer asset_index, date quote_date)
float array[*][2] asset_flows (integer asset_index, date start_date, date end_date, float start_flow = 0, float end_flow = 0)
float asset_high (integer asset_index, date quote_date)
float asset_investment (integer asset_index, date start_date, date end_date)
float asset_last_trade (integer asset_index)
float asset_low (integer asset_index, date quote_date)
string asset_name (integer asset_index)
float asset_nav (integer asset_index, date quote_date, boolean allow_old = FALSE)
float asset_open (integer asset_index, date quote_date)
float asset_open_interest (integer asset_index, date quote_date)
float asset_percent_bonds (integer asset_index)
float asset_percent_cash (integer asset_index)
float asset_percent_other (integer asset_index)
float asset_percent_stocks (integer asset_index)
float asset_principal (integer asset_index, date start_date, date end_date)
float array[*][2] asset_principal_flows (integer asset_index, date start_date, date end_date, float start_flow = 0, float end_flow = 0)
float array[*][*] asset_quotes (integer asset_index, string fields, date start_date, date end_date = start_date, integer max_quotes = -1)
string asset_symbol (integer asset_index)
float asset_units (integer asset_index, date quote_date)
float array[*][2]   (integer asset_index, date start_date, date end_date)
float asset_volume (integer asset_index, date quote_date)
float atan (float argument)
float atan2 (float x, float y)
float atanh (float argument)
float array[*][2] atr (float array[*][4] dhlc, integer days = 14)
float avedev (float data [, ...])
float average (float data [, ...])
float array[1][2] ba (float array[*][2] dc_asset, float array[*][2] dc_market, float risk_free_rate = 0)
float beta (float a, float b)
float betadist (float x, float alpha, float beta, float a = 0, float b = 1, boolean cumulative = TRUE)
float betainv (float probability, float alpha, float beta, float a = 0, float b = 1)
float binomdist (integer successes, integer trials, float success_probability, boolean cumulative = TRUE)
float array[1][length] blackman (integer length)
float   (integer length, integer position)
float array[*][4] bol (float array[*][2] dc, integer days = 20, float sigma = 2)
float array[*][2] cbi (float array[*][2] dc, integer days_tolerance = 7)
float array[*][2] cci (float array[*][4] dhlc, integer days = 5)
float ceiling (float number, float step)
string char (integer ansi_code)
float chi2 (float array[rows][cols] actual_values, float array[rows][cols] expected_values)
float chidist (float x, integer degrees_of_freedom, boolean cumulative = TRUE)
float chiinv (float probability, integer degrees_of_freedom)
float chitest (float array[rows][cols] actual_values, float array[rows][cols] expected_values)
  choose (integer argument_index, argument [, ...])
string clean (string argument)
integer code (string argument)
integer column ()
integer   (reference cell_reference)
integer array[1][*]   (reference range_reference)
integer columns (array[*][*] argument)
float combin (integer n, integer k)
string concatenate (string argument [, ...])
float confidence (float alpha, float standard_deviation, integer size)
float array[*][data_columns] convolve (float array[1][*] window, float amplification, float array[*][data_columns] data)
float array[*][data_columns]   (float array[1][*] window, float amplification, float array[*][data_columns] data, integer first_column, integer last_column = first_column)
float correl (float array[rows][cols] a, float array[rows][cols] b, boolean nonbiased = FALSE)
float cos (float argument)
float cosh (float argument)
integer count (data [, ...])
integer counta (data [, ...])
integer countblank (array argument)
integer countif (array data, string criteria)
float coupdaybs (date settlement_date, date maturity_date, integer coupons_per_year, integer day_count_basis = 0)
float coupdays (date settlement_date, date maturity_date, integer coupons_per_year, integer day_count_basis = 0)
float coupdaysnc (date settlement_date, date maturity_date, integer coupons_per_year, integer day_count_basis = 0)
date coupncd (date settlement_date, date maturity_date, integer coupons_per_year, integer day_count_basis = 0)
float coupnum (date settlement_date, date maturity_date, integer coupons_per_year, integer day_count_basis = 0)
date couppcd (date settlement_date, date maturity_date, integer coupons_per_year, integer day_count_basis = 0)
float covar (float array[rows][cols] a, float array[rows][cols] b, boolean nonbiased = FALSE)
float critbinom (integer trials, float success_probability, float criterion)
float array[*][2] crosses (float array[*][*] values, integer value_column, float threshold)
float array[*][2]   (float array[*][*] values, integer value_column, float array[*][*] thresholds, integer threshold_column)
float array[*][2] csp (float array[*][5] dohlc, integer lookback_days = 5, float none_below_average_fraction = 0.1, float long_above_average_fraction = 0.7, float no_trend_below_slope = 0.001, float no_trend_above_slope = -0.001)
float cumipmt (float interest_rate, integer payment_periods, float present_value, integer first_period, integer last_period, integer paymentTiming = 0)
float cumprinc (float interest_rate, integer payment_periods, float present_value, integer first_period, integer last_period, integer paymentTiming = 0)
float currency_convert (string from_currency, string to_currency, date conversion_date, float from_value = 1)
date date (integer year, integer month, integer day)
date datevalue (string argument)
integer day (date argument)
float days360 (date start_date, date end_date, boolean european = FALSE)
float db (float initial_cost, float salvage_value, integer total_periods, integer period, integer months_in_first_year = 12)
float ddb (float initial_cost, float salvage_value, integer total_periods, integer period, float factor = 2)
float degrees (float argument)
float devsq (float data [, ...])
float array[*][2] di (float array[*][4] dhlc)
float array[*][2] dim (float array[*][4] dhlc, integer days = 14, float start_dim = 0)
float array[*][2] dip (float array[*][4] dhlc, integer days = 14, float start_dip = 0)
float disc (date settlement_date, date maturity_date, float price_per_100_face_value, float redemption_value_per_100_face_value, integer day_count_basis = 0)
float array[*][2] dm (float array[*][3] dhl)
string dollar (float amount, integer digits = 2)
float dollarde (float fractional_dollar, integer denominator)
float dollarfr (float decimal_dollar, integer denominator)
float array[*][2] dpo (float array[*][2] dc, integer days)
float duration (date settlement_date, date maturity_date, float annual_coupon_rate, float annual_yield, integer coupons_per_year, integer day_count_basis = 0)
date edate (date start_date, integer months)
float effect (date nominal_interest_rate, integer compounding_periods_per_year)
float array[*][2] efi (float array[*][3] dcv)
float array[*][2] ema (float array[*][2] dc, integer days, float previous_ema = 0)
float array[*][2] eom (float array[*][4] dhlv, float volume_divisor = 10000)
date eomonth (date start_date, integer months)
float erf (float argument)
integer even (integer argument)
boolean exact (string a, string b)
float exp (float argument)
float expondist (float x, float lambda, boolean cumulative = TRUE)
float exponinv (float probabililty, float lambda)
float array[*][3] extrema (float array[*][*] table, integer column, boolean include_end_points = FALSE)
float fact (integer argument)
float factdouble (integer argument)
float fdist (float x, integer degrees_of_freedom_numerator, integer degrees_of_freedom_denominator, boolean cumulative = TRUE)
float array[*][3] fftc (float array data)
float array[*][3] fftp (float array data)
integer find (string sub_string, string in_string, integer from_position = 1)
float finv (float probability, integer degrees_of_freedom_numerator, integer degrees_of_freedom_denominator)
float fisher (float argument)
float fisherinv (float argument)
string fixed (float value, integer digits = 2, boolean no_commas = FALSE)
array[m][n] flipcols (array[m][n] argument)
array[m][n] fliprows (array[m][n] argument)
float floor (float number, float step)
float forecast (float x, float array known_ys, float array known_xs)
float frac (float argument)
float array[*][1] frequency (float array data, float array bins)
float ftest (float array a, float array b)
float fv (float interest_rate, integer payment_periods, float periodic_payment, float present_value = 0, integer payment_timing = 0)
float fvschedule (float principal, float array rate_schedule)
float gamma (float argument)
float gammadist (float x, float alpha, float beta, boolean cumulative)
float gammainv (float probability, float alpha, float beta)
float gammaln (float argument)
integer gcd (integer data [, ...])
float geomean (float data [, ...])
float array[*][1] growth (float array known_ys, float array known_xs = {1, 2, 3 [, ...]}, float array new_xs = known_xs, boolean fit_constant = TRUE)
float array[1][length] hamming (integer length)
float   (integer length, integer position)
float array[1][length] hanning (integer length)
float   (integer length, integer position)
float harmean (float data [, ...])
float array[*][data_columns] hipass (float array[*][4] filter_parameters, float amplification, float array[*][data_columns] data)
float array[*][data_columns]   (float array[*][4] filter_parameters, float amplification, float array[*][data_columns] data, integer first_column, integer last_column = first_column)
  hlookup (lookup_value, array[*][*] table, integer result_row = 1, boolean range_lookup = TRUE)
integer hour (time argument)
float hypgeomdist (integer sample_successes, integer sample_size, integer population_successes, integer population_size, boolean cumulative = FALSE)
  if (boolean condition, true_result = TRUE, false_result = FALSE)
  index (array[*][*] table, integer row = 0, integer column = 0)
  indirect (reference cell_reference)
float int (float argument)
float intercept (float array known_ys, float array known_xs)
float intrate (date settlement_date, date maturity_date, float investment, float redemption, integer day_count_basis = 0)
float ipmt (float interest_rate, integer period, integer payment_periods, float present_value, float future_value = 0, integer payment_timing = 0)
float irr (float array cash_flows, float guess = 10%)
float array[*][4] kb (float array[*][4] dhlc, integer ema_days = 20, integer atr_days = 10, float multiplier = 2, float previous_ema = 0)
float kurt (float data [, ...])
float large (float array table, integer rank)
integer lcm (integer data [, ...])
string left (string in_string, integer length = 1)
integer len (string argument)
float array[*][*] linest (float array known_ys, float array known_xs = {1, 2, 3 [, ...]}, boolean fit_constant = TRUE, boolean statistics = FALSE)
float ln (float argument)
float log (float number, float base = 10)
float log10 (float argument)
float array[*][*] logest (float array known_ys, float array known_xs = {1, 2, 3 [, ...]}, boolean fit_constant = TRUE, boolean statistics = FALSE)
float loginv (float probability, float mean, float standard_deviation)
float lognormdist (float x, float mean, float standard_deviation, boolean cumulative = TRUE)
  lookup (lookup_value, array[*][*] table)
    (lookup_value, array values, array results)
float array[*][data_columns] lopass (float array[*][4] filter_parameters, float amplification, float array[*][data_columns] data)
float array[*][data_columns]   (float array[*][4] filter_parameters, float amplification, float array[*][data_columns] data, integer first_column, integer last_column = first_column)
string lower (string argument)
float array[n][n] m1 (integer n)
float array[*][2] ma (float array[*][2] dc, integer days)
float array[*][3] macd (float array[*][2] dc, integer n_long = 26, integer n_short = 12, integer n_signal = 9, float previous_long_ema = 0, float previous_short_ema = 0, float previous_signal_ema = 0)
float array[1][4] make_ema (integer days)
float array[*][4] make_hipass (integer poles, float normalized_cutoff)
float array[*][4] make_lopass (integer poles, float normalized_cutoff)
float array[1][4] make_notch (float normalized_frequency, float radius)
float array[1][4] make_resonator (float normalized_frequency, float zero_gain, float peak_gain)
float array[n][1] makevector (integer n, float start = 1, float increment = 1)
integer match (lookup_value, array[*][*] table, integer match_type = 1)
float max (float data [, ...])
float mdeterm (float array[n][n] argument)
float mduration (date settlement_date, date maturity_date, float annual_coupon_rate, float annual_yield, integer coupons_per_year, integer day_count_basis = 0)
float median (float data [, ...])
float array[1][poles + 1] mem (float array data, integer poles)
float array[1][3] memdom (float array mem_coefficients, boolean power, float normalized_frequency)
float array[1][3]   (float array mem_coefficients, boolean power, float from_normalized_frequency, float normalized_frequency_step, integer steps)
float array[1][2] memf (float array mem_coefficients, boolean power, float normalized_frequency)
float array[steps][2]   (float array mem_coefficients, boolean power, float from_normalized_frequency, float normalized_frequency_step, integer steps)
float array[1][2] memp (float array mem_coefficients, boolean power, float period)
float array[steps][2]   (float array mem_coefficients, boolean power, float from_period, float period_step, integer steps)
float array[*][2] mfi (float array[*][5] dhlcv, integer days)
float array[*][2] mfm (float array[*][5] dhlcv, integer days)
float array[*][2] mfp (float array[*][5] dhlcv, integer days)
float array[*][2] mi (float array[*][3] dhl, integer sum_days = 25, integer ema_days = 9, float previous_ema_1 = 0, float previous_ema_2 = 0)
string mid (string in_string, integer start, integer length)
float min (float data [, ...])
integer minute (time argument)
float array[n][n] minverse (float array[n][n] argument)
float mirr (float array cash_flows, float financing_interest_rate, float reinvestment_interest_rate)
float array[rows_a][columns_b] mmult (float array[rows_a][n] a, float array[n][columns_b] b)
float array[*][2] mo (float array[*][2] dc, integer days)
integer mod (integer numerator, integer denominator)
float mode (float data [, ...])
integer month (date argument)
array mop (string operation_string, array data [, ...])
float mround (float number, float multiple)
float array[n][1] msolve (float array[n][n] a, float array[n][1] b)
array msort (array[*][*] table, boolean ascending = TRUE, boolean rowwise = TRUE)
float array[m][n] msub (float array[m][n] a, float array[m][n] b)
float array[m][n] msum (float array[m][n] a, float array[m][n] b)
float multinomial (integer data [, ...])
float negbinomdist (integer failures, integer successes, float success_probability)
integer networkdays (date start_date, date end_date, date array holidays = {})
float nominal (float effective_interest_rate, integer compounding_periods_per_year)
float normdist (float x, float mean, float standard_deviation, boolean cumulative = TRUE)
float norminv (float probability, float mean, float standard_deviation)
float normsdist (float x, boolean cumulative = TRUE)
float normsinv (float probability)
float array[*][data_columns] notch (float array[1][4] filter_parameters, float amplification, float array[*][data_columns] data)
float array[*][data_columns]   (float array[1][*] filter_parameters, float amplification, float array[*][data_columns] data, integer first_column, integer last_column = first_column)
float now ()
float nper (float interest_rate, float periodic_payment, float present_value, float future_value = 0, integer payment_timing = 0)
float npv (float discount_rate, float cash_flows [, ...])
float array[*][2] nvi (float array[*][3] dcv, float start_nvi = 1)
float array[*][2] obv (float array[*][3] dcv, float start_obv = 0)
float odd (float argument)
reference offset (reference base_reference, integer rows, integer columns, integer height = 0, integer width = 0)
float pearson (float array a, float array b)
float percentile (float array data, float left_alfa)
float percentrank (float array data, float x, integer significant_digits = 3)
float permut (integer n, integer k)
float pi ()
float pmt (float interest_rate, integer payment_periods, float present_value, float future_value = 0, integer payment_timing = 0)
float poisson (integer events, float lambda, boolean cumulative = TRUE)
float portfolio_converted_currency_part (string currency_code, integer porfolio_index, date quote_date, boolean allow_old = FALSE)
string portfolio_currency (integer porfolio_index)
float portfolio_currency_part (string currency_code, integer porfolio_index, date quote_date, boolean allow_old = FALSE)
float array[*][2] portfolio_fee_flows (integer portfolio_index, date start_date, date end_date, float start_flow = 0, float end_flow = 0)
float portfolio_fees (integer portfolio_index, date start_date, date end_date)
float portfolio_first_trade (integer porfolio_index)
array[*][2] portfolio_flags (integer portfolio_index, date quote_date)
float array[*][2] portfolio_flows (integer portfolio_index, date start_date, date end_date, float start_flow = 0, float end_flow = 0)
float portfolio_investment (integer portfolio_index, date start_date, date end_date)
float portfolio_last_trade (integer porfolio_index)
string portfolio_name (integer porfolio_index)
float portfolio_nav (integer portfolio_index, date quote_date, boolean allow_old = FALSE)
float portfolio_percent_bonds (integer portfolio_index, date quote_date, boolean allow_old = FALSE)
float portfolio_percent_cash (integer portfolio_index, date quote_date, boolean allow_old = FALSE)
float portfolio_percent_other (integer portfolio_index, date quote_date, boolean allow_old = FALSE)
float portfolio_percent_stocks (integer portfolio_index, date quote_date, boolean allow_old = FALSE)
float portfolio_principal (integer portfolio_index, date start_date, date end_date)
float array[*][2] portfolio_principal_flows (integer portfolio_index, date start_date, date end_date, float start_flow = 0, float end_flow = 0)
float array[*][2] portfolio_quotes (integer portfolio_index, date start_date, date end_date = start_date, integer max_quotes = -1)
string portfolio_symbol (integer porfolio_index)
float power (float base, float exponent)
float ppmt (float interest_rate, integer period, integer payment_periods, float present_value, float future_value = 0, integer payment_timing = 0)
float price (date settlement_date, date maturity_date, float annual_coupon_rate, float annual_yield, float redemption_value_per_100_face_value, integer coupons_per_year, integer day_count_basis = 0)
float pricedisc (date settlement_date, date maturity_date, float discount_rate, float redemption_value_per_100_face_value, integer day_count_basis = 0)
float pricemat (date settlement_date, date maturity_date, date issue_date, float interest_rate_at_issue, float annual_yield, integer day_count_basis = 0)
float prob (float array x_values, float array probabilities, float lower_limit, float upper_limit = lower_limit)
float product (float data [, ...])
string proper (string argument)
float pv (float interest_rate, integer payment_periods, float periodic_payment, float future_value = 0, integer payment_timing = 0)
float array[*][2] pvi (float array[*][3] dcv, float start_pvi = 1)
float array[*][2] pvt (float array[*][3] dcv, float start_pvt = 0)
float quartile (float array data, integer quartile)
integer quotient (integer numerator, integer denominator)
float radians (float argument)
float rand ()
integer randbetween (integer bottom, integer top)
integer rank (float number, float array data, integer order = 0)
float rate (integer payment_periods, float periodic_payment, float present_value = 0, float future_value = 0, integer payment_timing = 0, float guess = 10%)
float received (date settlement_date, date maturity_date, float investment, float discount_rate, integer day_count_basis = 0)
float array[1][length] rectangle (integer length)
float   (integer length, integer position)
string replace (string in_string, integer start, integer length, string replacement_string)
string rept (string in_string, integer number_times)
float array[*][1] resample (float rate_factor, float array data)
float array[*][data_columns] resonate (float array[1][4] filter_parameters, float amplification, float array[*][data_columns] data)
float array[*][data_columns]   (float array[1][4] filter_parameters, float amplification, float array[*][data_columns] data, integer first_column, integer last_column = first_column)
string right (string in_string, integer length = 1)
float array[*][2] roc (float array[*][2] dc, integer days)
float round (float number, integer digits)
float rounddown (float number, integer digits = 0)
float roundup (float number, integer digits = 0)
integer row ()
integer   (reference cell_reference)
integer array[*][1]   (reference range_reference)
integer rows (array argument)
float array[*][2] rs (float array[*][2] dc_asset, float array[*][2] dc_reference, integer days)
float array[*][2] rsi (float array[*][2] dc, integer days)
float rsq (float array a, float array b)
float array[*][2] sar (float array[*][3] dhl, float min_af = 0.02, float max_af = 0.2)
integer search (string sub_string, string in_string, integer from_position = 1)
integer second (time argument)
float seriessum (float x, float n, float m, float coefficient [, ...])
float array[*][2] si (float array[*][5] dohlc, float limit_move = 10000)
integer sign (float argument)
float sin (float argument)
float sinh (float argument)
float skew (float data [, ...])
float sln (float initial_cost, float salvage_value, float total_periods)
float slope (float array known_ys, float array known_xs)
float small (float array table, integer rank)
float sqr (float argument)
float sqrt (float argument)
float sqrtpi (float argument)
float standardize (float x, float mean, float standard_deviation)
float stdev (float data [, ...])
float stdevp (float data [, ...])
float steyx (float array known_ys, float array known_xs)
float array[*][4] sto (float array[*][4] dhlc, integer raw_days, integer fast_days, integer slow_days)
array[*][*] subarray (array[*][*] source_array, integer start_row, integer end_row, integer start_column, integer end_column)
string substitute (string in_string, string old_string, string new_string, integer instance_number)
float sum (float data [, ...])
float sumif (array test_range, string criteria, array sum_range = test_range)
float sumproduct (float array a, float array b [, ...])
float sumsq (float data [, ...])
float sumx2my2 (float array a, float array b)
float sumx2py2 (float array a, float array b)
float sumxmy2 (float array a, float array b)
array[m][n] swapcols (array[m][n] table, integer column_1, integer column_2)
array[m][n] swaprows (array[m][n] table, integer row_1, integer row_2)
float syd (float initial_cost, float salvage_value, float life, float total_periods)
array[*][*] sync (array[*][*] a, array[*][*] b, keep_unmatched = TRUE)
string t (argument)
float tan (float argument)
float tanh (float argument)
float tbilleq (date settlement_date, date maturity_date, float discount_rate)
float tbillprice (date settlement_date, date maturity_date, float discount_rate)
float tbillyield (date settlement_date, date maturity_date, float price_per_100_face_value)
float tdist (float x, integer degrees_of_freedom, integer tails, boolean cumulative = TRUE)
time time ()
time timevalue (string argument)
float tinv (float probability, integer degrees_of_freedom)
date today ()
float array[*][2] tp (float array[*][4] dhlc)
float array[*][2] tr (float array[*][4] dhlc)
integer transaction_asset (integer transaction_number)
array[*][*] transpose (array argument)
float array[*][1] trend (float array known_ys, float array known_xs = {1, 2, 3 [, ...]}, float array new_xs = known_xs, boolean fit_constant = TRUE)
float array[1][length] triangle (integer length)
float   (integer length, integer position)
string trim (string argument)
float trimmean (float array data, float percent)
float array[*][2] trix (float array[*][2] dc, integer days, float previous_ema_1 = 0, float previous_ema_2 = 0, float previous_ema_3 = 0)
float trunc (float argument, integer digits = 0)
float array[*][2] tsi (float array[*][2] dc, integer long_days, integer short_days)
float ttest (float array a, float array b, integer tails, integer type)
float array[*][2] udr (float array[*][3] dcv, integer days)
string upper (string argument)
float value (string argument)
float var (float data [, ...])
float varp (float data [, ...])
float vdb (float initial_cost, float salvage_value, float total_periods, float start_period, float end_period, float factor = 2, boolean no_switch = FALSE)
float array[*][2] vhf (float array[*][2] dc, integer days)
  vlookup (lookup_value, array[*][*] table, integer result_column = 1, boolean range_lookup = TRUE)
float array[*][2] voi (float array[*][3] dhl, integer days = 10, float previous_ema = 0)
float array[*][2] wad (float array[*][4] dhlc, float start_wad = 0)
integer weekday (date serial_number, integer return_type = 1)
float weibull (float x, float shape, float scale, boolean cumulative = TRUE)
float weibullinv (float probability, float shape, float scale)
integer workday (date start_date, integer days, date array holidays = {})
float array[*][2] wro (float array[*][4] dhlc, integer days)
float xirr (float array cash_flows, date array dates, float guess = 10%)
float xnpv (float discount_rate, float array cash_flows, date array dates)
integer year (date argument)
float yearfrac (date start_date, date end_date, integer day_count_basis = 0)
float yield (date settlement_date, date maturity_date, float annual_coupon_rate, float price_per_100_face_value, float redemption_value_per_100_face_value, integer coupons_per_year, integer day_count_basis = 0)
float ztest (float array data, float x, float standard_deviation = stdev(data))
float array[*][2] zzi (float array[*][2] dc, float relative_separation_threshold = 10%, boolean logarithmic = FALSE)