{"id":1701,"date":"2014-06-27T09:01:11","date_gmt":"2014-06-27T08:01:11","guid":{"rendered":"http:\/\/help.sdna.lu\/?p=1701&#038;lang=en"},"modified":"2015-12-03T13:50:45","modified_gmt":"2015-12-03T12:50:45","slug":"security-price","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=1701","title":{"rendered":"Security price"},"content":{"rendered":"<h3><b><span style=\"text-decoration: underline;\">Security Price:<\/span><\/b><\/h3>\n<table>\n<tbody>\n<tr>\n<th width=\"350px\">Name<\/th>\n<th width=\"20px\">Type<\/th>\n<th width=\"15px\">Mandatory<\/th>\n<th width=\"250px\">Description<\/th>\n<\/tr>\n<tr>\n<td valign=\"top\">&lt;<span style=\"color: #993300;\">Record<\/span> <span style=\"color: #0000ff;\">Type<\/span> =&#8221;<span style=\"color: #ff0000;\">35<\/span>&#8220;&gt;<\/td>\n<td valign=\"top\">Long<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Type of object to import. 35 is for security price<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;DBId&gt;&lt;\/DBId&gt;<\/span><\/td>\n<td valign=\"top\">Long<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Database Id in DeMaSy. It is displayed in Utilities<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;SecurityCode&gt;&lt;\/SecurityCode&gt;<\/span><\/td>\n<td valign=\"top\">Char(50)<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Code of security<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;StockExchange&gt;&lt;\/StockExchange&gt;<\/span><\/td>\n<td valign=\"top\">Char(50)<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Stock exchange code<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;StartDate&gt;&lt;\/StartDate&gt;<\/span><\/td>\n<td valign=\"top\">Date\/Time<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">First day of price<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;EndDate&gt;&lt;\/EndDate&gt;<\/span><\/td>\n<td valign=\"top\">Date\/Time<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Last day of price<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;Price&gt;&lt;\/Price&gt;<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Security price value (amount for shares and percentage for\u00a0 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\"><span style=\"color: #993300;\">&lt;ACPrice&gt;&lt;\/ACPrice&gt;<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td align=\"center\" valign=\"top\">N<\/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\"><span style=\"color: #993300;\">&lt;ACCurrency&gt;&lt;\/ACCurrency&gt;<\/span><\/td>\n<td valign=\"top\">Char(50)<\/td>\n<td align=\"center\" valign=\"top\">N<\/td>\n<td valign=\"top\">Currency (ISO code) in which the ACPrice is expressed.<\/td>\n<\/tr>\n<tr>\n<td><span style=\"color: #993300;\">&lt;\/Record&gt;<\/span><\/td>\n<td valign=\"top\"><\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td>End of block<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<a href=\"https:\/\/sdna.lu\/?media_dl=4867\">PDF version<\/a>\n","protected":false},"excerpt":{"rendered":"<p>Security Price: Name Type Mandatory Description &lt;Record Type =&#8221;35&#8220;&gt; Long Y Type of object to import. 35 is for security price &lt;DBId&gt;&lt;\/DBId&gt; Long Y Database Id in DeMaSy. It is displayed in Utilities &lt;SecurityCode&gt;&lt;\/SecurityCode&gt; Char(50) Y Code of security &lt;StockExchange&gt;&lt;\/StockExchange&gt; Char(50) Y Stock exchange code &lt;StartDate&gt;&lt;\/StartDate&gt; Date\/Time Y First day of price &lt;EndDate&gt;&lt;\/EndDate&gt; Date\/Time Y [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[15,22,12],"class_list":["post-1701","post","type-post","status-publish","format-standard","hentry","category-utils","tag-interface","tag-security-price","tag-xml"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1701","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=1701"}],"version-history":[{"count":6,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1701\/revisions"}],"predecessor-version":[{"id":4868,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1701\/revisions\/4868"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1701"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1701"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1701"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}