Python nper_handlerの例

コード例 #1

def test_nper_missing_pv():
    response = handlers.nper_handler({
        "rate": 0.005833333333333,
        "pmt": -150,
    }, None)

    assert 'error' in response

コード例 #2

def test_nper_missing_pmt():
    response = handlers.nper_handler({
        "rate": 0.005833333333333,
        "pv": 8000
    }, None)

    assert 'error' in response

コード例 #3

def test_nper_handler():
    # TODO test data types
    response = handlers.nper_handler(
        {
            "rate": 0.005833333333333,
            "pmt": -150,
            "pv": 8000
        }, None)
    assert 'result' in response
    assert round(response.get('result'), 5) == 64.07335

    # TODO Excel docs claim this isn't supported but Excel produces a value...
    response = handlers.nper_handler(
        {
            "rate": 0.005833333333333,
            "pv": 8000,
            "fv": -100
        }, None)
    assert 'result' in response
    assert round(response.get('result'), 5) == -753.39346

    response = handlers.nper_handler(
        {
            "rate": 0.005833333333333,
            "pmt": -150,
            "pv": 8000,
            "fv": -100
        }, None)
    assert 'result' in response
    assert round(response.get('result'), 5) == 63.40344

    response = handlers.nper_handler(
        {
            "rate": 0.005833333333333,
            "pmt": -150,
            "pv": 8000,
            "fv": -100,
            "type": 1
        }, None)
    assert 'result' in response
    assert round(response.get('result'), 5) == 62.95762

コード例 #4

ファイル: test_lambda_handlers.py プロジェクト: vvvlc/financial-functions

def test_nper_handler():
    # TODO test data types
    response = handlers.nper_handler(
        {
            "rate": 0.005833333333333,
            "pmt": -150,
            "pv": 8000
        }, None)
    assert 'result' in response
    assert response.get('result').tolist() == pytest.approx(64.07335)

    # TODO Excel docs claim this isn't supported but Excel produces a value...
    response = handlers.nper_handler(
        {
            "rate": 0.005833333333333,
            "pv": 8000,
            "fv": -100
        }, None)
    assert 'result' in response
    assert response.get('result').tolist() == pytest.approx(-753.39346)

    response = handlers.nper_handler(
        {
            "rate": 0.005833333333333,
            "pmt": -150,
            "pv": 8000,
            "fv": -100
        }, None)
    assert 'result' in response
    assert response.get('result').tolist() == pytest.approx(63.40344)

    response = handlers.nper_handler(
        {
            "rate": 0.005833333333333,
            "pmt": -150,
            "pv": 8000,
            "fv": -100,
            "type": 1
        }, None)
    assert 'result' in response
    assert response.get('result').tolist() == pytest.approx(62.95762)

コード例 #5

def test_nper_missing_rate():
    response = handlers.nper_handler({"pmt": -150, "pv": 8000}, None)

    assert 'error' in response