PHPOffice / PHPExcel

ARCHIVED
Other
11.46k stars 4.2k forks source link

Treasury Yield Function #1390

Open hosain4w opened 6 years ago

hosain4w commented 6 years ago

Treasury Yield Function didn't available in PHPEXCEL. I've developed as per Microsoft instruction but unfortunately it takes too time to give output for more than 12 digits. Can I know, how can i resolve slowness issue for above 12 digits.

$mdate = '15/11/2016'; $sdate= '15/02/2008'; $cr = 5.75; //8.59%

    $price = 102.662233775443

$objPHPExcel->cYIELD($sdate,$mdate,($cr/100),$price,100,2,1);