Skip to content

ISIN_VALID

Info

New in Atfinity 17.

Description

ISIN_VALID checks whether a string is a valid ISIN (International Securities Identification Number, ISO 6166), the 12-character code identifying a security such as a share or bond. It verifies the format and the Luhn check digit. It does not verify that the security actually exists.

Syntax

ISIN_VALID(isin)

Returns: true if the ISIN is structurally valid, false if not, unknown if the argument is not a string.

Example

ISIN_VALID('US0378331005')

Returns true, a valid ISIN.

ISIN_VALID('US0378331006')

Returns false, the check digit does not match.