FinancialTest Class Reference

Inheritance diagram for FinancialTest:

Collaboration diagram for FinancialTest:

Public Member Functions
	setUp ()
	testACCRINT ()
	providerACCRINT More...
	providerACCRINT ()
	testACCRINTM ()
	providerACCRINTM More...
	providerACCRINTM ()
	testAMORDEGRC ()
	providerAMORDEGRC More...
	providerAMORDEGRC ()
	testAMORLINC ()
	providerAMORLINC More...
	providerAMORLINC ()
	testCOUPDAYBS ()
	providerCOUPDAYBS More...
	providerCOUPDAYBS ()
	testCOUPDAYS ()
	providerCOUPDAYS More...
	providerCOUPDAYS ()
	testCOUPDAYSNC ()
	providerCOUPDAYSNC More...
	providerCOUPDAYSNC ()
	testCOUPNCD ()
	providerCOUPNCD More...
	providerCOUPNCD ()
	testCOUPNUM ()
	providerCOUPNUM More...
	providerCOUPNUM ()
	testCOUPPCD ()
	providerCOUPPCD More...
	providerCOUPPCD ()
	testCUMIPMT ()
	providerCUMIPMT More...
	providerCUMIPMT ()
	testCUMPRINC ()
	providerCUMPRINC More...
	providerCUMPRINC ()
	testDB ()
	providerDB More...
	providerDB ()
	testDDB ()
	providerDDB More...
	providerDDB ()
	testDISC ()
	providerDISC More...
	providerDISC ()
	testDOLLARDE ()
	providerDOLLARDE More...
	providerDOLLARDE ()
	testDOLLARFR ()
	providerDOLLARFR More...
	providerDOLLARFR ()
	testEFFECT ()
	providerEFFECT More...
	providerEFFECT ()
	testFV ()
	providerFV More...
	providerFV ()
	testFVSCHEDULE ()
	providerFVSCHEDULE More...
	providerFVSCHEDULE ()
	testINTRATE ()
	providerINTRATE More...
	providerINTRATE ()
	testIPMT ()
	providerIPMT More...
	providerIPMT ()
	testIRR ()
	providerIRR More...
	providerIRR ()
	testISPMT ()
	providerISPMT More...
	providerISPMT ()
	testMIRR ()
	providerMIRR More...
	providerMIRR ()
	testNOMINAL ()
	providerNOMINAL More...
	providerNOMINAL ()
	testNPER ()
	providerNPER More...
	providerNPER ()
	testNPV ()
	providerNPV More...
	providerNPV ()
	testPRICE ()
	providerPRICE More...
	providerPRICE ()
	testRATE ()
	providerRATE More...
	providerRATE ()
	testXIRR ()
	providerXIRR More...
	providerXIRR ()

Detailed Description

Definition at line 6 of file FinancialTest.php.

Member Function Documentation

providerACCRINT()

FinancialTest::providerACCRINT

(

)

Definition at line 31 of file FinancialTest.php.

    {
        return new testDataFileIterator('rawTestData/Calculation/Financial/ACCRINT.data');
        }

providerACCRINTM()

FinancialTest::providerACCRINTM

(

)

Definition at line 47 of file FinancialTest.php.

    {
        return new testDataFileIterator('rawTestData/Calculation/Financial/ACCRINTM.data');
        }

providerAMORDEGRC()

FinancialTest::providerAMORDEGRC

(

)

Definition at line 63 of file FinancialTest.php.

    {
        return new testDataFileIterator('rawTestData/Calculation/Financial/AMORDEGRC.data');
        }

providerAMORLINC()

FinancialTest::providerAMORLINC

(

)

Definition at line 79 of file FinancialTest.php.

    {
        return new testDataFileIterator('rawTestData/Calculation/Financial/AMORLINC.data');
        }

providerCOUPDAYBS()

FinancialTest::providerCOUPDAYBS

(

)

Definition at line 95 of file FinancialTest.php.

    {
        return new testDataFileIterator('rawTestData/Calculation/Financial/COUPDAYBS.data');
        }

providerCOUPDAYS()

FinancialTest::providerCOUPDAYS

(

)

Definition at line 111 of file FinancialTest.php.

    {
        return new testDataFileIterator('rawTestData/Calculation/Financial/COUPDAYS.data');
        }

providerCOUPDAYSNC()

FinancialTest::providerCOUPDAYSNC

(

)

Definition at line 127 of file FinancialTest.php.

    {
        return new testDataFileIterator('rawTestData/Calculation/Financial/COUPDAYSNC.data');
        }

providerCOUPNCD()

FinancialTest::providerCOUPNCD

(

)

Definition at line 143 of file FinancialTest.php.

    {
        return new testDataFileIterator('rawTestData/Calculation/Financial/COUPNCD.data');
        }

providerCOUPNUM()

FinancialTest::providerCOUPNUM

(

)

Definition at line 159 of file FinancialTest.php.

    {
        return new testDataFileIterator('rawTestData/Calculation/Financial/COUPNUM.data');
        }

providerCOUPPCD()

FinancialTest::providerCOUPPCD

(

)

Definition at line 175 of file FinancialTest.php.

    {
        return new testDataFileIterator('rawTestData/Calculation/Financial/COUPPCD.data');
        }

providerCUMIPMT()

FinancialTest::providerCUMIPMT

(

)

Definition at line 191 of file FinancialTest.php.

    {
        return new testDataFileIterator('rawTestData/Calculation/Financial/CUMIPMT.data');
        }

providerCUMPRINC()

FinancialTest::providerCUMPRINC

(

)

Definition at line 207 of file FinancialTest.php.

    {
        return new testDataFileIterator('rawTestData/Calculation/Financial/CUMPRINC.data');
        }

providerDB()

FinancialTest::providerDB

(

)

Definition at line 223 of file FinancialTest.php.

    {
        return new testDataFileIterator('rawTestData/Calculation/Financial/DB.data');
        }

providerDDB()

FinancialTest::providerDDB

(

)

Definition at line 239 of file FinancialTest.php.

    {
        return new testDataFileIterator('rawTestData/Calculation/Financial/DDB.data');
        }

providerDISC()

FinancialTest::providerDISC

(

)

Definition at line 255 of file FinancialTest.php.

    {
        return new testDataFileIterator('rawTestData/Calculation/Financial/DISC.data');
        }

providerDOLLARDE()

FinancialTest::providerDOLLARDE

(

)

Definition at line 271 of file FinancialTest.php.

    {
        return new testDataFileIterator('rawTestData/Calculation/Financial/DOLLARDE.data');
        }

providerDOLLARFR()

FinancialTest::providerDOLLARFR

(

)

Definition at line 287 of file FinancialTest.php.

    {
        return new testDataFileIterator('rawTestData/Calculation/Financial/DOLLARFR.data');
        }

providerEFFECT()

FinancialTest::providerEFFECT

(

)

Definition at line 303 of file FinancialTest.php.

    {
        return new testDataFileIterator('rawTestData/Calculation/Financial/EFFECT.data');
        }

providerFV()

FinancialTest::providerFV

(

)

Definition at line 319 of file FinancialTest.php.

    {
        return new testDataFileIterator('rawTestData/Calculation/Financial/FV.data');
        }

providerFVSCHEDULE()

FinancialTest::providerFVSCHEDULE

(

)

Definition at line 335 of file FinancialTest.php.

    {
        return new testDataFileIterator('rawTestData/Calculation/Financial/FVSCHEDULE.data');
        }

providerINTRATE()

FinancialTest::providerINTRATE

(

)

Definition at line 351 of file FinancialTest.php.

    {
        return new testDataFileIterator('rawTestData/Calculation/Financial/INTRATE.data');
        }

providerIPMT()

FinancialTest::providerIPMT

(

)

Definition at line 367 of file FinancialTest.php.

    {
        return new testDataFileIterator('rawTestData/Calculation/Financial/IPMT.data');
        }

providerIRR()

FinancialTest::providerIRR

(

)

Definition at line 383 of file FinancialTest.php.

    {
        return new testDataFileIterator('rawTestData/Calculation/Financial/IRR.data');
        }

providerISPMT()

FinancialTest::providerISPMT

(

)

Definition at line 399 of file FinancialTest.php.

    {
        return new testDataFileIterator('rawTestData/Calculation/Financial/ISPMT.data');
        }

providerMIRR()

FinancialTest::providerMIRR

(

)

Definition at line 415 of file FinancialTest.php.

    {
        return new testDataFileIterator('rawTestData/Calculation/Financial/MIRR.data');
        }

providerNOMINAL()

FinancialTest::providerNOMINAL

(

)

Definition at line 431 of file FinancialTest.php.

    {
        return new testDataFileIterator('rawTestData/Calculation/Financial/NOMINAL.data');
        }

providerNPER()

FinancialTest::providerNPER

(

)

Definition at line 447 of file FinancialTest.php.

    {
        return new testDataFileIterator('rawTestData/Calculation/Financial/NPER.data');
        }

providerNPV()

FinancialTest::providerNPV

(

)

Definition at line 463 of file FinancialTest.php.

    {
        return new testDataFileIterator('rawTestData/Calculation/Financial/NPV.data');
        }

providerPRICE()

FinancialTest::providerPRICE

(

)

Definition at line 479 of file FinancialTest.php.

    {
        return new testDataFileIterator('rawTestData/Calculation/Financial/PRICE.data');
        }

providerRATE()

FinancialTest::providerRATE

(

)

Definition at line 495 of file FinancialTest.php.

    {
        return new testDataFileIterator('rawTestData/Calculation/Financial/RATE.data');
        }

providerXIRR()

FinancialTest::providerXIRR

(

)

Definition at line 511 of file FinancialTest.php.

    {
        return new testDataFileIterator('rawTestData/Calculation/Financial/XIRR.data');
        }

setUp()

FinancialTest::setUp

(

)

Definition at line 9 of file FinancialTest.php.

References PHPExcel_Calculation_Functions\COMPATIBILITY_EXCEL, defined, and PHPExcel_Calculation_Functions\setCompatibilityMode().

    {
        if (!defined('PHPEXCEL_ROOT'))
        {
            define('PHPEXCEL_ROOT', APPLICATION_PATH . '/');
        }
        require_once(PHPEXCEL_ROOT . 'PHPExcel/Autoloader.php');

        PHPExcel_Calculation_Functions::setCompatibilityMode(PHPExcel_Calculation_Functions::COMPATIBILITY_EXCEL);
        }

Here is the call graph for this function:

testACCRINT()

FinancialTest::testACCRINT

(

)

providerACCRINT

Definition at line 23 of file FinancialTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_Financial','ACCRINT'),$args);
                $this->assertEquals($expectedResult, $result, NULL, 1E-8);
        }

testACCRINTM()

FinancialTest::testACCRINTM

(

)

providerACCRINTM

Definition at line 39 of file FinancialTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_Financial','ACCRINTM'),$args);
                $this->assertEquals($expectedResult, $result, NULL, 1E-8);
        }

testAMORDEGRC()

FinancialTest::testAMORDEGRC

(

)

providerAMORDEGRC

Definition at line 55 of file FinancialTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_Financial','AMORDEGRC'),$args);
                $this->assertEquals($expectedResult, $result, NULL, 1E-8);
        }

testAMORLINC()

FinancialTest::testAMORLINC

(

)

providerAMORLINC

Definition at line 71 of file FinancialTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_Financial','AMORLINC'),$args);
                $this->assertEquals($expectedResult, $result, NULL, 1E-8);
        }

testCOUPDAYBS()

FinancialTest::testCOUPDAYBS

(

)

providerCOUPDAYBS

Definition at line 87 of file FinancialTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_Financial','COUPDAYBS'),$args);
                $this->assertEquals($expectedResult, $result, NULL, 1E-8);
        }

testCOUPDAYS()

FinancialTest::testCOUPDAYS

(

)

providerCOUPDAYS

Definition at line 103 of file FinancialTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_Financial','COUPDAYS'),$args);
                $this->assertEquals($expectedResult, $result, NULL, 1E-8);
        }

testCOUPDAYSNC()

FinancialTest::testCOUPDAYSNC

(

)

providerCOUPDAYSNC

Definition at line 119 of file FinancialTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_Financial','COUPDAYSNC'),$args);
                $this->assertEquals($expectedResult, $result, NULL, 1E-8);
        }

testCOUPNCD()

FinancialTest::testCOUPNCD

(

)

providerCOUPNCD

Definition at line 135 of file FinancialTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_Financial','COUPNCD'),$args);
                $this->assertEquals($expectedResult, $result, NULL, 1E-8);
        }

testCOUPNUM()

FinancialTest::testCOUPNUM

(

)

providerCOUPNUM

Definition at line 151 of file FinancialTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_Financial','COUPNUM'),$args);
                $this->assertEquals($expectedResult, $result, NULL, 1E-8);
        }

testCOUPPCD()

FinancialTest::testCOUPPCD

(

)

providerCOUPPCD

Definition at line 167 of file FinancialTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_Financial','COUPPCD'),$args);
                $this->assertEquals($expectedResult, $result, NULL, 1E-8);
        }

testCUMIPMT()

FinancialTest::testCUMIPMT

(

)

providerCUMIPMT

Definition at line 183 of file FinancialTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_Financial','CUMIPMT'),$args);
                $this->assertEquals($expectedResult, $result, NULL, 1E-8);
        }

testCUMPRINC()

FinancialTest::testCUMPRINC

(

)

providerCUMPRINC

Definition at line 199 of file FinancialTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_Financial','CUMPRINC'),$args);
                $this->assertEquals($expectedResult, $result, NULL, 1E-8);
        }

testDB()

FinancialTest::testDB

(

)

providerDB

Definition at line 215 of file FinancialTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_Financial','DB'),$args);
                $this->assertEquals($expectedResult, $result, NULL, 1E-8);
        }

testDDB()

FinancialTest::testDDB

(

)

providerDDB

Definition at line 231 of file FinancialTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_Financial','DDB'),$args);
                $this->assertEquals($expectedResult, $result, NULL, 1E-8);
        }

testDISC()

FinancialTest::testDISC

(

)

providerDISC

Definition at line 247 of file FinancialTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_Financial','DISC'),$args);
                $this->assertEquals($expectedResult, $result, NULL, 1E-8);
        }

testDOLLARDE()

FinancialTest::testDOLLARDE

(

)

providerDOLLARDE

Definition at line 263 of file FinancialTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_Financial','DOLLARDE'),$args);
                $this->assertEquals($expectedResult, $result, NULL, 1E-8);
        }

testDOLLARFR()

FinancialTest::testDOLLARFR

(

)

providerDOLLARFR

Definition at line 279 of file FinancialTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_Financial','DOLLARFR'),$args);
                $this->assertEquals($expectedResult, $result, NULL, 1E-8);
        }

testEFFECT()

FinancialTest::testEFFECT

(

)

providerEFFECT

Definition at line 295 of file FinancialTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_Financial','EFFECT'),$args);
                $this->assertEquals($expectedResult, $result, NULL, 1E-8);
        }

testFV()

FinancialTest::testFV

(

)

providerFV

Definition at line 311 of file FinancialTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_Financial','FV'),$args);
                $this->assertEquals($expectedResult, $result, NULL, 1E-8);
        }

testFVSCHEDULE()

FinancialTest::testFVSCHEDULE

(

)

providerFVSCHEDULE

Definition at line 327 of file FinancialTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_Financial','FVSCHEDULE'),$args);
                $this->assertEquals($expectedResult, $result, NULL, 1E-8);
        }

testINTRATE()

FinancialTest::testINTRATE

(

)

providerINTRATE

Definition at line 343 of file FinancialTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_Financial','INTRATE'),$args);
                $this->assertEquals($expectedResult, $result, NULL, 1E-8);
        }

testIPMT()

FinancialTest::testIPMT

(

)

providerIPMT

Definition at line 359 of file FinancialTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_Financial','IPMT'),$args);
                $this->assertEquals($expectedResult, $result, NULL, 1E-8);
        }

testIRR()

FinancialTest::testIRR

(

)

providerIRR

Definition at line 375 of file FinancialTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_Financial','IRR'),$args);
                $this->assertEquals($expectedResult, $result, NULL, 1E-8);
        }

testISPMT()

FinancialTest::testISPMT

(

)

providerISPMT

Definition at line 391 of file FinancialTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_Financial','ISPMT'),$args);
                $this->assertEquals($expectedResult, $result, NULL, 1E-8);
        }

testMIRR()

FinancialTest::testMIRR

(

)

providerMIRR

Definition at line 407 of file FinancialTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_Financial','MIRR'),$args);
                $this->assertEquals($expectedResult, $result, NULL, 1E-8);
        }

testNOMINAL()

FinancialTest::testNOMINAL

(

)

providerNOMINAL

Definition at line 423 of file FinancialTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_Financial','NOMINAL'),$args);
                $this->assertEquals($expectedResult, $result, NULL, 1E-8);
        }

testNPER()

FinancialTest::testNPER

(

)

providerNPER

Definition at line 439 of file FinancialTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_Financial','NPER'),$args);
                $this->assertEquals($expectedResult, $result, NULL, 1E-8);
        }

testNPV()

FinancialTest::testNPV

(

)

providerNPV

Definition at line 455 of file FinancialTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_Financial','NPV'),$args);
                $this->assertEquals($expectedResult, $result, NULL, 1E-8);
        }

testPRICE()

FinancialTest::testPRICE

(

)

providerPRICE

Definition at line 471 of file FinancialTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_Financial','PRICE'),$args);
                $this->assertEquals($expectedResult, $result, NULL, 1E-8);
        }

testRATE()

FinancialTest::testRATE

(

)

providerRATE

Definition at line 487 of file FinancialTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_Financial','RATE'),$args);
                $this->assertEquals($expectedResult, $result, NULL, 1E-8);
        }

testXIRR()

FinancialTest::testXIRR

(

)

providerXIRR

Definition at line 503 of file FinancialTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_Financial','XIRR'),$args);
                $this->assertEquals($expectedResult, $result, NULL, 1E-8);
        }

---

The documentation for this class was generated from the following file:

• libs/composer/vendor/phpoffice/phpexcel/unitTests/Classes/PHPExcel/Calculation/FinancialTest.php