Keldan security mapping
This mapping is used for all security types. The mapping is used in Tools → Create security → Keldan.
Mapping name: mapping.keldan
Updated fields
|
|
|
Mapping table
Row | Source field | Value mapping | FA field | Script |
|---|---|---|---|---|
1 | name | s.name | ||
2 | isin | s.isinCode | ||
3 | country | s.country | ||
4 | currency | s.currency | ||
5 | exchange | s.exchange | ||
6 | s.type | output="C" | ||
7 | type | bond=D;share=E | s.type | |
8 | day_count_method | act_act=Act/Act Year | s.accrualCalendar | |
9 | calendar | IS=Sat/Sun | s.holidayCalendar | |
10 | no_of_settlement_days | s.settlementDateOffset | ||
11 | outstanding_amount | s.share | ||
12 | base_instrument | s.baseInstrument | ||
13 | business_day_convention | unadjusted=NoAdjust | s.businessDayConvention | |
14 | coupon | s.coupon | ||
15 | premium | s.spread | ||
16 | index_symbol | s.linkedIndex | ||
17 | rate_symbol | s.baseInstrument | ||
18 | frequency | Annual=P12M | s.couponFrequency | |
19 | ex_coupon_period | s.exCouponPeriod | ||
20 | first_coupon_start_date | s.firstCouponDate | ||
21 | issue_date | s.issueDate | ||
22 | maturity_date | s.maturityDate | ||
23 | price_multiplier | s.multiplier | ||
24 | price_multiplier | s.multiplierView | ||
25 | lot_size | s.blockSize | ||
26 | security_code | s.securityCode | ||
27 | symbol | s.securityCode | ||
28 | s.status | output="ACTIVE" | ||
29 | isin | s.updateCode | ||
30 | s.indexBaseValue | output = "" | ||
31 | base_index_value | s.indexBaseValue | ||
32 | s.referenceIndexlag1 | if("[s.indexBaseValue]" != "") {
output = "1"
} else {
otuput = ""
} | ||
33 | s.referenceIndexlag2 | if("[s.indexBaseValue]" != "" ) {
output = "2"
} else {
otuput = ""
} | ||
34 | s.referenceIndexCalculationMode | if("[s.indexBaseValue]" != "") {
output = "2"
} else {
otuput = ""
} | ||
35 | s.referenceIndexConvention | if("[s.indexBaseValue]" != "") {
output = "0"
} else {
otuput = ""
} | ||
36 | s.tags | output="Reference data-Keldan"; |