{"id":1945,"date":"2014-07-11T10:46:52","date_gmt":"2014-07-11T09:46:52","guid":{"rendered":"http:\/\/help.sdna.lu\/?p=1945&lang=en"},"modified":"2020-07-30T13:58:16","modified_gmt":"2020-07-30T12:58:16","slug":"security-2","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=1945","title":{"rendered":"Security"},"content":{"rendered":"

Security:<\/span><\/b><\/span><\/h3>\n\n\n\n
RecordType;DBId;Name;Description;SerialNumber;Code;SecurityType;Basis;SecurityCountry;StockExchange;Currency;
\nIssueDate;IssueRate;IssueValue;NomValue;InterestRate;FirstIntDate;Frequency;MaturityDate;CouponDate;FirstCouponDate;
\nSecurityCode;OrgSecurityCode<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Nr<\/th>\nName<\/th>\nType<\/th>\nDescription<\/th>\n<\/tr>\n
1<\/td>\nRecordType<\/span><\/td>\nLong<\/td>\nType of object to import. 32 is for security<\/td>\n<\/tr>\n
2<\/td>\nDBId<\/span><\/td>\nLong<\/td>\nDatabase Id in DeMaSy. It is displayed in Utilities<\/td>\n<\/tr>\n
3<\/td>\nName<\/span><\/td>\nChar(100)<\/td>\nName of the Security<\/td>\n<\/tr>\n
4<\/td>\nDescription<\/span><\/td>\nChar(255)<\/td>\nSecurity description<\/td>\n<\/tr>\n
5<\/td>\nSerialNumber<\/span><\/td>\nChar(50)<\/td>\nSerial number<\/td>\n<\/tr>\n
6<\/td>\nCode<\/span><\/td>\nChar(50)<\/td>\nSecurity code used in DeMaSy<\/td>\n<\/tr>\n
7<\/td>\nSecurityType<\/span><\/td>\nInteger<\/td>\nCode type of security (share, bond,…)<\/td>\n<\/tr>\n
8<\/td>\nBasis<\/span><\/td>\nInteger<\/td>\nFor Bonds:
\n1 = 365\/366
\n2 = 365\/365
\n3 = 365\/360
\n4 = 360\/360 Europe
\n5 = 365\/365 Quasi-coupon (US treasury)
\n6 = 360\/360 USA
\n7 = 360\/365
\n8 = 360\/366<\/td>\n<\/tr>\n
9<\/td>\nSecurityCountry<\/span><\/td>\nChar(50)<\/td>\nIssue country (ISO code)<\/td>\n<\/tr>\n
10<\/td>\nStockExchange<\/span><\/td>\nChar(50)<\/td>\nStock exchange code<\/td>\n<\/tr>\n
11<\/td>\nCurrency<\/span><\/td>\nChar(10)<\/td>\nSecurity currency (ISO code)<\/td>\n<\/tr>\n
12<\/td>\nIssueDate<\/span><\/td>\nDate\/Time<\/td>\nSecurity issue date (for bonds)<\/td>\n<\/tr>\n
13<\/td>\nIssueRate<\/span><\/td>\nDouble<\/td>\nSecurity issue rate (for bonds) – if not provided = 100%<\/td>\n<\/tr>\n
14<\/td>\nIssueValue<\/span><\/td>\nDouble<\/td>\nIssue value (for bonds)<\/td>\n<\/tr>\n
15<\/td>\nNomValue<\/span><\/td>\nDouble<\/td>\nNominal value<\/td>\n<\/tr>\n
16<\/td>\nInterestRate<\/span><\/td>\nDouble<\/td>\nInterest rate (for fixed rate bonds) – zero for floating rates (to be provided by the user)<\/td>\n<\/tr>\n
17<\/td>\nFirstIntDate<\/span><\/td>\nDate\/Time<\/td>\nFirst interest date (for bonds)<\/td>\n<\/tr>\n
18<\/td>\nFrequency<\/span><\/td>\nInteger<\/td>\nCoupon frequency ( for bonds ):
\n1 = Yearly
\n2 = Twice a year
\n3 = Quaterly
\n6 = Twice a month
\n12 = Monthly<\/td>\n<\/tr>\n
19<\/td>\nMaturityDate<\/span><\/td>\nDate\/Time<\/td>\nMaturity date (for bonds)<\/td>\n<\/tr>\n
20<\/td>\nCouponDate<\/span><\/td>\nDate\/Time<\/td>\nCoupon date (for bonds) – format: MMDD<\/td>\n<\/tr>\n
21<\/td>\nFirstCouponDate<\/span><\/td>\nDate\/Time<\/td>\nFirst coupon date after issuance date<\/td>\n<\/tr>\n
22<\/td>\nSecurityCode<\/span><\/td>\nChar(50)<\/td>\n\/<\/td>\n<\/tr>\n
23<\/td>\nOrgSecurityCode<\/span><\/td>\nChar(50)<\/td>\n\/<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

Security: RecordType;DBId;Name;Description;SerialNumber;Code;SecurityType;Basis;SecurityCountry;StockExchange;Currency; IssueDate;IssueRate;IssueValue;NomValue;InterestRate;FirstIntDate;Frequency;MaturityDate;CouponDate;FirstCouponDate; SecurityCode;OrgSecurityCode Nr Name Type Description 1 RecordType Long Type of object to import. 32 is for security 2 DBId Long Database Id in DeMaSy. It is displayed in Utilities 3 Name Char(100) Name of the Security 4 Description Char(255) Security description 5 SerialNumber Char(50) Serial number 6 Code Char(50) Security code used […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[237],"tags":[],"class_list":["post-1945","post","type-post","status-publish","format-standard","hentry","category-interface-utils"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1945","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1945"}],"version-history":[{"count":4,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1945\/revisions"}],"predecessor-version":[{"id":9336,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1945\/revisions\/9336"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1945"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1945"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1945"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}