You are here

Home » API reference » Loft Data Grids 7.2 » Financial.php » PHPExcel_Calculation_Financial

private static function PHPExcel_Calculation_Financial::_validFrequency in Loft Data Grids 7.2

Same name and namespace in other branches
  1. 6.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php \PHPExcel_Calculation_Financial::_validFrequency()
7 calls to PHPExcel_Calculation_Financial::_validFrequency()
PHPExcel_Calculation_Financial::COUPDAYBS in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
* COUPDAYBS * * Returns the number of days from the beginning of the coupon period to the settlement date. * * Excel Function: * COUPDAYBS(settlement,maturity,frequency[,basis]) * * @access public * @category Financial Functions *
PHPExcel_Calculation_Financial::COUPDAYS in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
* COUPDAYS * * Returns the number of days in the coupon period that contains the settlement date. * * Excel Function: * COUPDAYS(settlement,maturity,frequency[,basis]) * * @access public * @category Financial Functions *
PHPExcel_Calculation_Financial::COUPDAYSNC in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
* COUPDAYSNC * * Returns the number of days from the settlement date to the next coupon date. * * Excel Function: * COUPDAYSNC(settlement,maturity,frequency[,basis]) * * @access public * @category Financial Functions *
PHPExcel_Calculation_Financial::COUPNCD in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
* COUPNCD * * Returns the next coupon date after the settlement date. * * Excel Function: * COUPNCD(settlement,maturity,frequency[,basis]) * * @access public * @category Financial Functions *
PHPExcel_Calculation_Financial::COUPNUM in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
* COUPNUM * * Returns the number of coupons payable between the settlement date and maturity date, * rounded up to the nearest whole coupon. * * Excel Function: * COUPNUM(settlement,maturity,frequency[,basis]) * * @access public *…

... See full list

File

vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php, line 105

Class

PHPExcel_Calculation_Financial
PHPExcel_Calculation_Financial

Code

private static function _validFrequency($frequency) {
  if ($frequency == 1 || $frequency == 2 || $frequency == 4) {
    return true;
  }
  if (PHPExcel_Calculation_Functions::getCompatibilityMode() == PHPExcel_Calculation_Functions::COMPATIBILITY_GNUMERIC && ($frequency == 6 || $frequency == 12)) {
    return true;
  }
  return false;
}