# tablepress/3.4/libraries/vendor/PhpSpreadsheet/Calculation/Financial/FinancialValidations.php

TablePress – Tables in WordPress made easy, version 3.4. 159 lines.

- Page: https://pluginprobe.com/plugins/tablepress/3.4/code/libraries/vendor/PhpSpreadsheet/Calculation/Financial/FinancialValidations.php
- Raw: https://pluginprobe.com/plugins/tablepress/3.4/raw/libraries/vendor/PhpSpreadsheet/Calculation/Financial/FinancialValidations.php
- Modified: 2025-04-29T05:06:50+00:00

Line numbers below start at 1. Link to a line or a range by appending a fragment to the
page URL, for example `https://pluginprobe.com/plugins/tablepress/3.4/code/libraries/vendor/PhpSpreadsheet/Calculation/Financial/FinancialValidations.php#L10-L20`.

```php
<?php

namespace TablePress\PhpOffice\PhpSpreadsheet\Calculation\Financial;

use TablePress\PhpOffice\PhpSpreadsheet\Calculation\DateTimeExcel;
use TablePress\PhpOffice\PhpSpreadsheet\Calculation\Exception;
use TablePress\PhpOffice\PhpSpreadsheet\Calculation\Financial\Constants as FinancialConstants;
use TablePress\PhpOffice\PhpSpreadsheet\Calculation\Information\ExcelError;

class FinancialValidations
{
	/**
				 * @param mixed $date
				 */
				public static function validateDate($date): float
	{
		return DateTimeExcel\Helpers::getDateValue($date);
	}

	/**
				 * @param mixed $settlement
				 */
				public static function validateSettlementDate($settlement): float
	{
		return self::validateDate($settlement);
	}

	/**
				 * @param mixed $maturity
				 */
				public static function validateMaturityDate($maturity): float
	{
		return self::validateDate($maturity);
	}

	/**
				 * @param mixed $value
				 */
				public static function validateFloat($value): float
	{
		if (!is_numeric($value)) {
			throw new Exception(ExcelError::VALUE());
		}

		return (float) $value;
	}

	/**
				 * @param mixed $value
				 */
				public static function validateInt($value): int
	{
		if (!is_numeric($value)) {
			throw new Exception(ExcelError::VALUE());
		}

		return (int) floor((float) $value);
	}

	/**
				 * @param mixed $rate
				 */
				public static function validateRate($rate): float
	{
		$rate = self::validateFloat($rate);
		if ($rate < 0.0) {
			throw new Exception(ExcelError::NAN());
		}

		return $rate;
	}

	/**
				 * @param mixed $frequency
				 */
				public static function validateFrequency($frequency): int
	{
		$frequency = self::validateInt($frequency);
		if (
			($frequency !== FinancialConstants::FREQUENCY_ANNUAL)
			&& ($frequency !== FinancialConstants::FREQUENCY_SEMI_ANNUAL)
			&& ($frequency !== FinancialConstants::FREQUENCY_QUARTERLY)
		) {
			throw new Exception(ExcelError::NAN());
		}

		return $frequency;
	}

	/**
				 * @param mixed $basis
				 */
				public static function validateBasis($basis): int
	{
		if (!is_numeric($basis)) {
			throw new Exception(ExcelError::VALUE());
		}

		$basis = (int) $basis;
		if (($basis < 0) || ($basis > 4)) {
			throw new Exception(ExcelError::NAN());
		}

		return $basis;
	}

	/**
				 * @param mixed $price
				 */
				public static function validatePrice($price): float
	{
		$price = self::validateFloat($price);
		if ($price < 0.0) {
			throw new Exception(ExcelError::NAN());
		}

		return $price;
	}

	/**
				 * @param mixed $parValue
				 */
				public static function validateParValue($parValue): float
	{
		$parValue = self::validateFloat($parValue);
		if ($parValue < 0.0) {
			throw new Exception(ExcelError::NAN());
		}

		return $parValue;
	}

	/**
				 * @param mixed $yield
				 */
				public static function validateYield($yield): float
	{
		$yield = self::validateFloat($yield);
		if ($yield < 0.0) {
			throw new Exception(ExcelError::NAN());
		}

		return $yield;
	}

	/**
				 * @param mixed $discount
				 */
				public static function validateDiscount($discount): float
	{
		$discount = self::validateFloat($discount);
		if ($discount <= 0.0) {
			throw new Exception(ExcelError::NAN());
		}

		return $discount;
	}
}

```