diff options
| author | xuri <xuri.me@gmail.com> | 2021-10-21 00:33:25 +0800 |
|---|---|---|
| committer | xuri <xuri.me@gmail.com> | 2021-10-21 00:33:25 +0800 |
| commit | 49e80b9e47a76252d27b1e2863541fc3b49ed488 (patch) | |
| tree | bb0296daf5b0628b4d8226887d2e8bbf90f10d56 /calc_test.go | |
| parent | 1df7f32cc641c747433b3f58e0de0deb58785bf3 (diff) | |
ref #65: new formula functions DISC and INTRATE
Diffstat (limited to 'calc_test.go')
| -rw-r--r-- | calc_test.go | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/calc_test.go b/calc_test.go index fb5876c..7262fa9 100644 --- a/calc_test.go +++ b/calc_test.go @@ -1286,6 +1286,8 @@ func TestCalcCellValue(t *testing.T) { "=DDB(10000,1000,5,3)": "1440", "=DDB(10000,1000,5,4)": "864", "=DDB(10000,1000,5,5)": "296", + // DISC + "=DISC(\"04/01/2016\",\"03/31/2021\",95,100)": "0.01", // DOLLARDE "=DOLLARDE(1.01,16)": "1.0625", // DOLLARFR @@ -1300,6 +1302,8 @@ func TestCalcCellValue(t *testing.T) { // FVSCHEDULE "=FVSCHEDULE(10000,A1:A5)": "240000", "=FVSCHEDULE(10000,0.5)": "15000", + // INTRATE + "=INTRATE(\"04/01/2005\",\"03/31/2010\",1000,2125)": "0.225", // IPMT "=IPMT(0.05/12,2,60,50000)": "-205.26988187971995", "=IPMT(0.035/4,2,8,0,5000,1)": "5.257455237829077", @@ -2428,6 +2432,17 @@ func TestCalcCellValue(t *testing.T) { "=DDB(0,0,\"\",0,0)": "strconv.ParseFloat: parsing \"\": invalid syntax", "=DDB(0,0,0,\"\",0)": "strconv.ParseFloat: parsing \"\": invalid syntax", "=DDB(0,0,0,0,\"\")": "strconv.ParseFloat: parsing \"\": invalid syntax", + // DISC + "=DISC()": "DISC requires 4 or 5 arguments", + "=DISC(\"\",\"03/31/2021\",95,100)": "#VALUE!", + "=DISC(\"04/01/2016\",\"\",95,100)": "#VALUE!", + "=DISC(\"04/01/2016\",\"03/31/2021\",\"\",100)": "#VALUE!", + "=DISC(\"04/01/2016\",\"03/31/2021\",95,\"\")": "#VALUE!", + "=DISC(\"04/01/2016\",\"03/31/2021\",95,100,\"\")": "#NUM!", + "=DISC(\"03/31/2021\",\"04/01/2016\",95,100)": "DISC requires maturity > settlement", + "=DISC(\"04/01/2016\",\"03/31/2021\",0,100)": "DISC requires pr > 0", + "=DISC(\"04/01/2016\",\"03/31/2021\",95,0)": "DISC requires redemption > 0", + "=DISC(\"04/01/2016\",\"03/31/2021\",95,100,5)": "invalid basis", // DOLLARDE "=DOLLARDE()": "DOLLARDE requires 2 arguments", "=DOLLARDE(\"\",0)": "strconv.ParseFloat: parsing \"\": invalid syntax", @@ -2459,6 +2474,17 @@ func TestCalcCellValue(t *testing.T) { "=FVSCHEDULE()": "FVSCHEDULE requires 2 arguments", "=FVSCHEDULE(\"\",0)": "strconv.ParseFloat: parsing \"\": invalid syntax", "=FVSCHEDULE(0,\"x\")": "strconv.ParseFloat: parsing \"x\": invalid syntax", + // INTRATE + "=INTRATE()": "INTRATE requires 4 or 5 arguments", + "=INTRATE(\"\",\"03/31/2021\",95,100)": "#VALUE!", + "=INTRATE(\"04/01/2016\",\"\",95,100)": "#VALUE!", + "=INTRATE(\"04/01/2016\",\"03/31/2021\",\"\",100)": "#VALUE!", + "=INTRATE(\"04/01/2016\",\"03/31/2021\",95,\"\")": "#VALUE!", + "=INTRATE(\"04/01/2016\",\"03/31/2021\",95,100,\"\")": "#NUM!", + "=INTRATE(\"03/31/2021\",\"04/01/2016\",95,100)": "INTRATE requires maturity > settlement", + "=INTRATE(\"04/01/2016\",\"03/31/2021\",0,100)": "INTRATE requires investment > 0", + "=INTRATE(\"04/01/2016\",\"03/31/2021\",95,0)": "INTRATE requires redemption > 0", + "=INTRATE(\"04/01/2016\",\"03/31/2021\",95,100,5)": "invalid basis", // IPMT "=IPMT()": "IPMT requires at least 4 arguments", "=IPMT(0,0,0,0,0,0,0)": "IPMT allows at most 6 arguments", |