Finance Functions

Generate financial data including credit cards, bank accounts, and securities

Finance Functions

Generate realistic financial data including payment methods, bank accounts, securities identifiers, and trading data.

Payment & Banking

generate_credit_card_number

Generate credit card numbers.

Category: Finance Type: Generator Data Types: string

Parameter	Type	Default	Description
`card_type`	string	random	`visa`, `mastercard`, `amex`, `discover`

columns:
  - name: card_number
    function: generate_credit_card_number
    parameters:
      card_type: visa

Output: 4111111111111111

generate_iban

Generate International Bank Account Numbers.

Category: Finance Type: Generator Data Types: string

columns:
  - name: iban
    function: generate_iban

Output: DE89370400440532013000

generate_currency_code

Generate ISO 4217 currency codes.

Category: Finance Type: Generator Data Types: string

columns:
  - name: currency
    function: generate_currency_code

Output: USD, EUR, GBP, JPY

generate_price

Generate monetary amounts.

Category: Finance Type: Generator Data Types: decimal, money

Parameter	Type	Default	Description
`left_digits`	integer	4	Digits before decimal
`right_digits`	integer	2	Digits after decimal
`positive`	boolean	true	Only positive numbers
`min_value`	float	none	Minimum value
`max_value`	float	none	Maximum value
`base_price_column`	string	none	Column for base price
`multiplier`	float	1.0	Multiplier for base price

Basic price:

columns:
  - name: amount
    function: generate_price
    parameters:
      min_value: 10
      max_value: 1000

Calculated from another column:

columns:
  - name: subtotal
    function: generate_price
  - name: tax
    function: generate_price
    parameters:
      base_price_column: subtotal
      multiplier: 0.08

Output: 99.99, 1234.56

Securities & Trading

generate_cusip

Generate CUSIP securities identifiers.

Category: Finance Type: Generator Data Types: string

columns:
  - name: cusip
    function: generate_cusip

Output: 037833100

generate_isin

Generate International Securities Identification Numbers.

Category: Finance Type: Generator Data Types: string

Parameter	Type	Default	Description
`country_code`	string	`US`	Two-letter country code

columns:
  - name: isin
    function: generate_isin
    parameters:
      country_code: GB

Output: US0378331005, GB0002634946

generate_sedol

Generate SEDOL codes.

Category: Finance Type: Generator Data Types: string

columns:
  - name: sedol
    function: generate_sedol

Output: B0WNLY7

generate_bloomberg_ticker

Generate Bloomberg terminal ticker symbols.

Category: Finance Type: Generator Data Types: string

Parameter	Type	Default	Description
`asset_type`	string	`Equity`	`Equity`, `Bond`, `Currency`, `Commodity`, `Index`

columns:
  - name: ticker
    function: generate_bloomberg_ticker
    parameters:
      asset_type: Equity

Output: AAPL US Equity, EURUSD Curncy

generate_bond_rating

Generate credit ratings.

Category: Finance Type: Generator Data Types: string

Parameter	Type	Default	Description
`agency`	string	`SP`	`SP`, `Moody`, `Fitch`

columns:
  - name: rating
    function: generate_bond_rating
    parameters:
      agency: Moody

Output: AAA, Aa1, BBB+

generate_derivative_id

Generate derivative instrument identifiers.

Category: Finance Type: Generator Data Types: string

Parameter	Type	Default	Description
`derivative_type`	string	`Option`	`Option`, `Future`, `Swap`

columns:
  - name: contract_id
    function: generate_derivative_id
    parameters:
      derivative_type: Option

Output: AAPL240315C00150000

generate_fx_pair

Generate foreign exchange currency pairs.

Category: Finance Type: Generator Data Types: string

columns:
  - name: currency_pair
    function: generate_fx_pair

Output: EUR/USD, GBP/JPY

generate_options_symbol

Generate options contract symbols.

Category: Finance Type: Generator Data Types: string

columns:
  - name: options_contract
    function: generate_options_symbol

Output: AAPL240315C00150000

generate_futures_symbol

Generate futures contract symbols.

Category: Finance Type: Generator Data Types: string

columns:
  - name: futures_contract
    function: generate_futures_symbol

Output: ESH24, CLF25

Trading Operations

generate_clearing_number

Generate clearing house reference numbers.

Parameter	Type	Default	Description
`clearing_house`	string	`DTC`	`DTC`, `NSCC`, `OCC`, `CME`

columns:
  - name: clearing_ref
    function: generate_clearing_number

generate_settlement_id

Generate trade settlement identifiers.

Parameter	Type	Default	Description
`settlement_type`	string	`DVP`	`DVP`, `RVP`, `FOP`

columns:
  - name: settlement_id
    function: generate_settlement_id

generate_trade_confirmation

Generate trade confirmation numbers.

columns:
  - name: confirmation_number
    function: generate_trade_confirmation

Risk & Portfolio

generate_risk_metric

Generate VaR, beta, and other risk metrics.

Parameter	Type	Default	Description
`metric_type`	string	`VaR`	`VaR`, `Beta`, `Sharpe`, `Volatility`, `Tracking_Error`, `Max_Drawdown`, `Information_Ratio`

columns:
  - name: var_95
    function: generate_risk_metric
    parameters:
      metric_type: VaR

Output: 95% VaR: 2.35%

generate_portfolio_benchmark

Generate benchmark index names.

Parameter	Type	Default	Description
`asset_class`	string	`Equity`	`Equity`, `Fixed_Income`, `Commodity`, `Real_Estate`

columns:
  - name: benchmark
    function: generate_portfolio_benchmark

Output: S&P 500 Index, Bloomberg US Aggregate Bond Index

Insurance Functions - Insurance-specific financial data
Masking Functions - Mask financial data

Finance Functions