Investment Studio > Expressions > Functions > Financial

Result type Function name Arguments
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 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 cumipmt (float interest_rate, integer payment_periods, float present_value, integer first_period, integer last_period, integer payment_timing = 0)
float cumprinc (float interest_rate, integer payment_periods, float present_value, integer first_period, integer last_period, integer payment_timing = 0)
float currency_convert (string from_currency, string to_currency, date conversion_date, float from_value = 1)
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 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 dollarde (float fractional_dollar, integer denominator)
float dollarfr (float decimal_dollar, integer denominator)
float duration (date settlement_date, date maturity_date, float annual_coupon_rate, float annual_yield, integer coupons_per_year, integer day_count_basis = 0)
float effect (date nominal_interest_rate, integer compounding_periods_per_year)
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 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 mduration (date settlement_date, date maturity_date, float annual_coupon_rate, float annual_yield, integer coupons_per_year, integer day_count_basis = 0)
float mirr (float array cash_flows, float financing_interest_rate, float reinvestment_interest_rate)
float nominal (float effective_interest_rate, integer compounding_periods_per_year)
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 pmt (float interest_rate, integer payment_periods, float present_value, float future_value = 0, integer payment_timing = 0)
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 pv (float interest_rate, integer payment_periods, float periodic_payment, float future_value = 0, integer payment_timing = 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 sln (float initial_cost, float salvage_value, float total_periods)
float syd (float initial_cost, float salvage_value, float total_periods, float period)
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 vdb (float initial_cost, float salvage_value, float total_periods, float start_period, float end_period, float factor = 2, boolean no_switch = FALSE)
float xirr (float array cash_flows, date array dates, float guess = 10%)
float xnpv (float discount_rate, float array cash_flows, date array dates)
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)