kspread

financial.cpp File Reference

#include <math.h>
#include "CalculationSettings.h"
#include "FinancialModule.h"
#include "FunctionModuleRegistry.h"
#include "Functions.h"
#include "functions/helper.h"
#include "ValueCalc.h"
#include "ValueConverter.h"
#include <kcalendarsystem.h>
#include <KGenericFactory>
#include <KLocale>
#include "FinancialModule.moc"
Include dependency graph for financial.cpp:

Go to the source code of this file.

Defines

#define ROUND(x, y)   (floor ((x) + 0.5))

Functions

void awNpv (ValueCalc *c, Value &res, Value val, Value rate)
static Value calc_fvifa (ValueCalc *, Value rate, Value nper)
Value func_accrint (valVector args, ValueCalc *calc, FuncExtra *)
Value func_accrintm (valVector args, ValueCalc *calc, FuncExtra *)
Value func_amordegrc (valVector args, ValueCalc *calc, FuncExtra *)
Value func_amorlinc (valVector args, ValueCalc *calc, FuncExtra *)
Value func_compound (valVector args, ValueCalc *calc, FuncExtra *)
Value func_continuous (valVector args, ValueCalc *calc, FuncExtra *)
Value func_coupnum (valVector args, ValueCalc *calc, FuncExtra *)
Value func_cumipmt (valVector args, ValueCalc *calc, FuncExtra *)
Value func_cumprinc (valVector args, ValueCalc *calc, FuncExtra *)
Value func_db (valVector args, ValueCalc *calc, FuncExtra *)
Value func_ddb (valVector args, ValueCalc *calc, FuncExtra *)
Value func_disc (valVector args, ValueCalc *calc, FuncExtra *)
Value func_dollarde (valVector args, ValueCalc *calc, FuncExtra *)
Value func_dollarfr (valVector args, ValueCalc *calc, FuncExtra *)
Value func_duration (valVector args, ValueCalc *calc, FuncExtra *)
Value func_duration_add (valVector args, ValueCalc *calc, FuncExtra *)
Value func_effective (valVector args, ValueCalc *calc, FuncExtra *)
Value func_euro (valVector args, ValueCalc *calc, FuncExtra *)
Value func_euroconvert (valVector args, ValueCalc *calc, FuncExtra *)
Value func_fv (valVector args, ValueCalc *calc, FuncExtra *)
Value func_fv_annuity (valVector args, ValueCalc *calc, FuncExtra *)
Value func_fvschedule (valVector args, ValueCalc *calc, FuncExtra *)
Value func_intrate (valVector args, ValueCalc *calc, FuncExtra *)
Value func_ipmt (valVector args, ValueCalc *calc, FuncExtra *)
Value func_ispmt (valVector args, ValueCalc *calc, FuncExtra *)
Value func_level_coupon (valVector args, ValueCalc *calc, FuncExtra *)
Value func_mduration (valVector args, ValueCalc *calc, FuncExtra *)
Value func_mirr (valVector args, ValueCalc *calc, FuncExtra *)
Value func_nominal (valVector args, ValueCalc *calc, FuncExtra *)
Value func_nper (valVector args, ValueCalc *calc, FuncExtra *)
Value func_npv (valVector args, ValueCalc *calc, FuncExtra *)
Value func_oddlprice (valVector args, ValueCalc *calc, FuncExtra *)
Value func_oddlyield (valVector args, ValueCalc *calc, FuncExtra *)
Value func_pmt (valVector args, ValueCalc *calc, FuncExtra *)
Value func_ppmt (valVector args, ValueCalc *calc, FuncExtra *)
Value func_pricemat (valVector args, ValueCalc *calc, FuncExtra *)
Value func_pv (valVector args, ValueCalc *calc, FuncExtra *)
Value func_pv_annuity (valVector args, ValueCalc *calc, FuncExtra *)
Value func_received (valVector args, ValueCalc *calc, FuncExtra *)
Value func_rri (valVector args, ValueCalc *calc, FuncExtra *)
Value func_sln (valVector args, ValueCalc *calc, FuncExtra *)
Value func_syd (valVector args, ValueCalc *calc, FuncExtra *)
Value func_tbilleq (valVector args, ValueCalc *calc, FuncExtra *)
Value func_tbillprice (valVector args, ValueCalc *calc, FuncExtra *)
Value func_tbillyield (valVector args, ValueCalc *calc, FuncExtra *)
Value func_vdb (valVector args, ValueCalc *calc, FuncExtra *)
Value func_xirr (valVector args, ValueCalc *calc, FuncExtra *)
Value func_xnpv (valVector args, ValueCalc *calc, FuncExtra *)
Value func_yielddisc (valVector args, ValueCalc *calc, FuncExtra *)
Value func_yieldmat (valVector args, ValueCalc *calc, FuncExtra *)
Value func_zero_coupon (valVector args, ValueCalc *calc, FuncExtra *)
static Value getPay (ValueCalc *calc, Value rate, Value nper, Value pv, Value fv, Value type)
static Value getPrinc (ValueCalc *calc, Value start, Value pay, Value rate, Value period)
static double helper_eurofactor (const QString &currency)
static Value helper_ipmt (ValueCalc *calc, Value rate, Value per, Value nper, Value pv, Value fv, Value type)
 K_PLUGIN_FACTORY (FinancialModulePluginFactory, registerPlugin< FinancialModule >();) FinancialModule
static double vdbGetGDA (const double cost, const double salvage, const double life, const double period, const double depreciationFactor)
static double vdbInterVDB (const double cost, const double salvage, const double life, const double life1, const double period, const double depreciationFactor)
static double xirrResult (valVector &args, ValueCalc *calc, double &rate)
static double xirrResultDerive (valVector &args, ValueCalc *calc, double &rate)

Define Documentation

#define ROUND ( x,
 )     (floor ((x) + 0.5))

Function Documentation

void awNpv ( ValueCalc c,
Value res,
Value  val,
Value  rate 
)

Definition at line 349 of file financial.cpp.

static Value calc_fvifa ( ValueCalc ,
Value  rate,
Value  nper 
) [static]

Definition at line 361 of file financial.cpp.

Value func_accrint ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 615 of file financial.cpp.

Value func_accrintm ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 656 of file financial.cpp.

Value func_amordegrc ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 686 of file financial.cpp.

Value func_amorlinc ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 751 of file financial.cpp.

Value func_compound ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 792 of file financial.cpp.

Value func_continuous ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 811 of file financial.cpp.

Value func_coupnum ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 829 of file financial.cpp.

Value func_cumipmt ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 875 of file financial.cpp.

Value func_cumprinc ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 914 of file financial.cpp.

Value func_db ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 954 of file financial.cpp.

Value func_ddb ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 996 of file financial.cpp.

Value func_disc ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 1040 of file financial.cpp.

Value func_dollarde ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 1077 of file financial.cpp.

Value func_dollarfr ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 1099 of file financial.cpp.

Value func_duration ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 1124 of file financial.cpp.

Value func_duration_add ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 1150 of file financial.cpp.

Value func_effective ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 1188 of file financial.cpp.

Value func_euro ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 1205 of file financial.cpp.

Value func_euroconvert ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 1219 of file financial.cpp.

Value func_fv ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 1244 of file financial.cpp.

Value func_fv_annuity ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 1301 of file financial.cpp.

Value func_fvschedule ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 1277 of file financial.cpp.

Value func_intrate ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 1320 of file financial.cpp.

Value func_ipmt ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 1346 of file financial.cpp.

Value func_ispmt ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 1365 of file financial.cpp.

Value func_level_coupon ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 1457 of file financial.cpp.

Value func_mduration ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 1389 of file financial.cpp.

Value func_mirr ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 1426 of file financial.cpp.

Value func_nominal ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 1483 of file financial.cpp.

Value func_nper ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 1509 of file financial.cpp.

Value func_npv ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 1538 of file financial.cpp.

Value func_oddlprice ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 1559 of file financial.cpp.

Value func_oddlyield ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 1605 of file financial.cpp.

Value func_pmt ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 1652 of file financial.cpp.

Value func_ppmt ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 1671 of file financial.cpp.

Value func_pricemat ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 1708 of file financial.cpp.

Value func_pv ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 1747 of file financial.cpp.

Value func_pv_annuity ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 1778 of file financial.cpp.

Value func_received ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 1795 of file financial.cpp.

Value func_rri ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 1825 of file financial.cpp.

Value func_sln ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 1845 of file financial.cpp.

Value func_syd ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 1865 of file financial.cpp.

Value func_tbilleq ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 1891 of file financial.cpp.

Value func_tbillprice ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 1912 of file financial.cpp.

Value func_tbillyield ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 1938 of file financial.cpp.

Value func_vdb ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 1965 of file financial.cpp.

Value func_xirr ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 2047 of file financial.cpp.

Value func_xnpv ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 2091 of file financial.cpp.

Value func_yielddisc ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 2136 of file financial.cpp.

Value func_yieldmat ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 2163 of file financial.cpp.

Value func_zero_coupon ( valVector  args,
ValueCalc calc,
FuncExtra  
)

Definition at line 2196 of file financial.cpp.

static Value getPay ( ValueCalc calc,
Value  rate,
Value  nper,
Value  pv,
Value  fv,
Value  type 
) [static]

Definition at line 376 of file financial.cpp.

static Value getPrinc ( ValueCalc calc,
Value  start,
Value  pay,
Value  rate,
Value  period 
) [static]

Definition at line 405 of file financial.cpp.

static double helper_eurofactor ( const QString currency  )  [static]

Definition at line 421 of file financial.cpp.

static Value helper_ipmt ( ValueCalc calc,
Value  rate,
Value  per,
Value  nper,
Value  pv,
Value  fv,
Value  type 
) [static]

Definition at line 446 of file financial.cpp.

K_PLUGIN_FACTORY ( FinancialModulePluginFactory  ,
registerPlugin< FinancialModule >();   
)

Definition at line 113 of file financial.cpp.

static double vdbGetGDA ( const double  cost,
const double  salvage,
const double  life,
const double  period,
const double  depreciationFactor 
) [static]

Definition at line 471 of file financial.cpp.

static double vdbInterVDB ( const double  cost,
const double  salvage,
const double  life,
const double  life1,
const double  period,
const double  depreciationFactor 
) [static]

Definition at line 505 of file financial.cpp.

static double xirrResult ( valVector args,
ValueCalc calc,
double &  rate 
) [static]

Definition at line 559 of file financial.cpp.

static double xirrResultDerive ( valVector args,
ValueCalc calc,
double &  rate 
) [static]

Definition at line 587 of file financial.cpp.