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.