{"id":1948,"date":"2014-07-11T10:47:31","date_gmt":"2014-07-11T09:47:31","guid":{"rendered":"http:\/\/help.sdna.lu\/?p=1948&#038;lang=en"},"modified":"2021-11-29T15:09:03","modified_gmt":"2021-11-29T14:09:03","slug":"security-price-2","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=1948","title":{"rendered":"Security price"},"content":{"rendered":"<h3><span style=\"color: #ff0000;\"><b><span style=\"text-decoration: underline;\">Security Price:<\/span><\/b><\/span><\/h3>\n<table>\n<tbody>\n<tr>\n<td valign=\"center\">RecordType;DBId;SecurityCode;StockExchange;StartDate;Price;ACPrice;ACCurrency<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<table>\n<tbody>\n<tr>\n<th width=\"10\">Nr<\/th>\n<th width=\"250\">Name<\/th>\n<th width=\"20\">Type<\/th>\n<th width=\"350\">Description<\/th>\n<\/tr>\n<tr>\n<td valign=\"top\">1<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">RecordType<\/span><\/td>\n<td valign=\"top\">Long<\/td>\n<td valign=\"top\">Type of object to import. 35 is for security price<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">2<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">DBId<\/span><\/td>\n<td valign=\"top\">Long<\/td>\n<td valign=\"top\">Database Id in DeMaSy. It is displayed in Utilities<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">3<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">SecurityCode<\/span><\/td>\n<td valign=\"top\">Char(50)<\/td>\n<td valign=\"top\">Code of security<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">4<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">StockExchange<\/span><\/td>\n<td valign=\"top\">Char(50)<\/td>\n<td valign=\"top\">Stock exchange code<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">5<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">StartDate<\/span><\/td>\n<td valign=\"top\">Date\/Time<\/td>\n<td valign=\"top\">First day of price (format YYYYMMDD)<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">6<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">Price<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td valign=\"top\">Security price value (amount for shares and percentage for bonds). The currency of the security price provided is always supposed to be the currency of the security<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">7<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">ACPrice<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td valign=\"top\">Security price in another currency. If the security price is not provided in the currency of the security, the ACPrice and ACCurrency fields must be provided. Price field will be converted by DeMaSy using the available exchange rates.<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">8<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">ACCurrency<\/span><\/td>\n<td valign=\"top\">Char(50)<\/td>\n<td valign=\"top\">Currency (ISO code) in which the ACPrice is expressed.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"<p>Security Price: RecordType;DBId;SecurityCode;StockExchange;StartDate;Price;ACPrice;ACCurrency Nr Name Type Description 1 RecordType Long Type of object to import. 35 is for security price 2 DBId Long Database Id in DeMaSy. It is displayed in Utilities 3 SecurityCode Char(50) Code of security 4 StockExchange Char(50) Stock exchange code 5 StartDate Date\/Time First day of price (format YYYYMMDD) 6 Price [&hellip;]<\/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-1948","post","type-post","status-publish","format-standard","hentry","category-interface-utils"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1948","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=1948"}],"version-history":[{"count":7,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1948\/revisions"}],"predecessor-version":[{"id":11687,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1948\/revisions\/11687"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1948"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1948"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1948"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}