DividendTaxRates

V8 Message Definiton

Records in this table define the withholding tax rate applied to discrete dividends for option pricing, keyed by ISO 3166 country code. The effective dividend seen by the option holder is: dividendAmount * (1 - withholdingRate). Example: US = 0.0 (no withholding), DE = 0.2 (20% withheld, 80% to trader).

METADATA

Attribute	Value
Topic	3585-option-pricing
MLink Token	EqtAnalytics
Product	SRAnalytics
accessType	SELECT
MLink Endpoint	MLink-Live

Table Definition

Field	Type	Key	Default Value	Comment
countryCode	VARCHAR(3)	PRI	''	domicile of the exchange ISO 3166
withholdingRate	FLOAT		0	fraction of dividend withheld as tax 00 no withholding NMS 02 20 withheld EUREX
modifiedBy	VARCHAR(24)		''
modifiedIn	enum - SysEnvironment		'None'
timestamp	DATETIME(6)		'1900-01-01 00:00:00.000000'

PRIMARY KEY DEFINITION (Unique)

Field	Sequence
countryCode	1

CREATE TABLE EXAMPLE QUERY

CREATE TABLE `SRAnalytics`.`MsgDividendTaxRates` (
    `countryCode` VARCHAR(3) NOT NULL DEFAULT '' COMMENT 'domicile of the exchange (ISO 3166)',
    `withholdingRate` FLOAT NOT NULL DEFAULT 0 COMMENT 'fraction of dividend withheld as tax (0.0 = no withholding (NMS), 0.2 = 20% withheld (EUREX))',
    `modifiedBy` VARCHAR(24) NOT NULL DEFAULT '',
    `modifiedIn` ENUM('None','Neptune','Pluto','V7_Stable','V7_Latest','Saturn','Venus','Mars','SysTest','V7_Current') NOT NULL DEFAULT 'None',
    `timestamp` DATETIME(6) NOT NULL DEFAULT '1900-01-01 00:00:00.000000',
    PRIMARY KEY USING HASH (`countryCode`)
) ENGINE=SRSE DEFAULT CHARSET=LATIN1 COMMENT='Records in this table define the withholding tax rate applied to discrete dividends for option pricing, keyed by ISO 3166 country code.\nThe effective dividend seen by the option holder is: dividendAmount * (1 - withholdingRate).\nExample: US = 0.0 (no withholding), DE = 0.2 (20% withheld, 80% to trader).';

SELECT TABLE EXAMPLE QUERY

SELECT
    `countryCode`,
    `withholdingRate`,
    `timestamp`
FROM `SRAnalytics`.`MsgDividendTaxRates`
WHERE 
    /* Replace with a VARCHAR(3) */ 
    `countryCode` = 'Example_countryCode';

Doc Columns Query

SELECT * FROM SRAnalytics.doccolumns WHERE TABLE_NAME='DividendTaxRates' ORDER BY ordinal_position ASC;