{"id":117,"date":"2007-05-09T11:55:10","date_gmt":"2007-05-09T11:55:10","guid":{"rendered":"http:\/\/www.amibroker.org\/userkb\/2007\/05\/09\/time-calculations\/"},"modified":"2007-07-07T19:41:59","modified_gmt":"2007-07-07T19:41:59","slug":"time-calculations","status":"publish","type":"post","link":"http:\/\/www.amibroker.org\/editable_userkb\/2007\/05\/09\/time-calculations\/","title":{"rendered":"Time Calculations"},"content":{"rendered":"<p>Time calculations are needed when placing GAT (Good At Time) and GTD (Good Till Date) orders. The simplest way is to convert the TimeNum to a SecondNum, perform your calculations in Seconds, and then convert the SecondNum back to a TimeNum. The first two functions below will do that for you.<\/p>\n<p>The next function applies a reference expressed in seconds to your Reference time. This reference would typically be used to Calculate GAT times. You may need this function when you want to apply an offset to a Time Reference and have orders activated automatically during the day without having to be online.<\/p>\n<pre><span style=\"color: #0000BB\"><\/span><span style=\"color: #000000\">function&nbsp;<\/span><span style=\"color: #0000BB\">TimeNumToSecondNum<\/span><span style=\"color: #000000\">(&nbsp;<\/span><span style=\"color: #0000BB\">TimeNumber&nbsp;<\/span><span style=\"color: #000000\">)\r{\r<\/span><span style=\"color: #0000BB\">Seconds&nbsp;<\/span><span style=\"color: #000000\">=&nbsp;<\/span><span style=\"color: #0000BB\">int<\/span><span style=\"color: #000000\">(<\/span><span style=\"color: #0000BB\">TimeNumber<\/span><span style=\"color: #000000\">%<\/span><span style=\"color: #0000BB\">100<\/span><span style=\"color: #000000\">);\r<\/span><span style=\"color: #0000BB\">Minutes&nbsp;<\/span><span style=\"color: #000000\">=&nbsp;<\/span><span style=\"color: #0000BB\">int<\/span><span style=\"color: #000000\">(<\/span><span style=\"color: #0000BB\">TimeNumber<\/span><span style=\"color: #000000\">\/<\/span><span style=\"color: #0000BB\">100<\/span><span style=\"color: #000000\">%<\/span><span style=\"color: #0000BB\">100<\/span><span style=\"color: #000000\">);\r<\/span><span style=\"color: #0000BB\">Hours&nbsp;<\/span><span style=\"color: #000000\">=&nbsp;<\/span><span style=\"color: #0000BB\">int<\/span><span style=\"color: #000000\">(<\/span><span style=\"color: #0000BB\">TimeNumber<\/span><span style=\"color: #000000\">\/<\/span><span style=\"color: #0000BB\">10000<\/span><span style=\"color: #000000\">%<\/span><span style=\"color: #0000BB\">100<\/span><span style=\"color: #000000\">);\r<\/span><span style=\"color: #0000BB\">NumberSecs&nbsp;<\/span><span style=\"color: #000000\">=&nbsp;<\/span><span style=\"color: #0000BB\">int<\/span><span style=\"color: #000000\">(<\/span><span style=\"color: #0000BB\">3600<\/span><span style=\"color: #000000\">*<\/span><span style=\"color: #0000BB\">Hours<\/span><span style=\"color: #000000\">+<\/span><span style=\"color: #0000BB\">60<\/span><span style=\"color: #000000\">*<\/span><span style=\"color: #0000BB\">Minutes<\/span><span style=\"color: #000000\">+<\/span><span style=\"color: #0000BB\">Seconds<\/span><span style=\"color: #000000\">);\rreturn&nbsp;<\/span><span style=\"color: #0000BB\">NumberSecs<\/span><span style=\"color: #000000\">;<\/span><\/pre>\n<pre><span style=\"color: #0000BB\"><\/span><span style=\"color: #000000\">function&nbsp;<\/span><span style=\"color: #0000BB\">SecondNumToTimeNum<\/span><span style=\"color: #000000\">(&nbsp;<\/span><span style=\"color: #0000BB\">SecondNum&nbsp;<\/span><span style=\"color: #000000\">)\r{\r<\/span><span style=\"color: #0000BB\">Hours&nbsp;<\/span><span style=\"color: #000000\">=&nbsp;<\/span><span style=\"color: #0000BB\">int<\/span><span style=\"color: #000000\">(<\/span><span style=\"color: #0000BB\">SecondNum&nbsp;<\/span><span style=\"color: #000000\">\/<\/span><span style=\"color: #0000BB\">3600<\/span><span style=\"color: #000000\">);\r<\/span><span style=\"color: #0000BB\">Minutes&nbsp;<\/span><span style=\"color: #000000\">=&nbsp;<\/span><span style=\"color: #0000BB\">int<\/span><span style=\"color: #000000\">((<\/span><span style=\"color: #0000BB\">SecondNum&nbsp;<\/span><span style=\"color: #000000\">-<\/span><span style=\"color: #0000BB\">Hours<\/span><span style=\"color: #000000\">*<\/span><span style=\"color: #0000BB\">3600<\/span><span style=\"color: #000000\">)\/<\/span><span style=\"color: #0000BB\">60<\/span><span style=\"color: #000000\">);\r<\/span><span style=\"color: #0000BB\">Seconds&nbsp;<\/span><span style=\"color: #000000\">=&nbsp;<\/span><span style=\"color: #0000BB\">int<\/span><span style=\"color: #000000\">((<\/span><span style=\"color: #0000BB\">SecondNum&nbsp;<\/span><span style=\"color: #000000\">-<\/span><span style=\"color: #0000BB\">Hours<\/span><span style=\"color: #000000\">*<\/span><span style=\"color: #0000BB\">3600<\/span><span style=\"color: #000000\">)-<\/span><span style=\"color: #0000BB\">Minutes<\/span><span style=\"color: #000000\">*<\/span><span style=\"color: #0000BB\">60<\/span><span style=\"color: #000000\">);\r<\/span><span style=\"color: #0000BB\">TimeNumber&nbsp;<\/span><span style=\"color: #000000\">=&nbsp;<\/span><span style=\"color: #0000BB\">Hours<\/span><span style=\"color: #000000\">*<\/span><span style=\"color: #0000BB\">10000&nbsp;<\/span><span style=\"color: #000000\">+&nbsp;<\/span><span style=\"color: #0000BB\">Minutes<\/span><span style=\"color: #000000\">*<\/span><span style=\"color: #0000BB\">100&nbsp;<\/span><span style=\"color: #000000\">+&nbsp;<\/span><span style=\"color: #0000BB\">Seconds<\/span><span style=\"color: #000000\">;\rreturn&nbsp;<\/span><span style=\"color: #0000BB\">TimeNumber<\/span><span style=\"color: #000000\">;\r}<\/span><\/pre>\n<pre><span style=\"color: #0000BB\"><\/span><span style=\"color: #000000\">function&nbsp;<\/span><span style=\"color: #0000BB\">ApplyOffsetToTimeNum<\/span><span style=\"color: #000000\">(&nbsp;<\/span><span style=\"color: #0000BB\">RefTimeNumber<\/span><span style=\"color: #000000\">,&nbsp;<\/span><span style=\"color: #0000BB\">Offset&nbsp;<\/span><span style=\"color: #000000\">)\r{\r<\/span><span style=\"color: #0000BB\">OffsetSecondNum&nbsp;<\/span><span style=\"color: #000000\">=&nbsp;<\/span><span style=\"color: #0000BB\">TimeNumToSecondNum<\/span><span style=\"color: #000000\">(&nbsp;<\/span><span style=\"color: #0000BB\">RefTimeNumber&nbsp;<\/span><span style=\"color: #000000\">)&nbsp;+&nbsp;<\/span><span style=\"color: #0000BB\">Offset<\/span><span style=\"color: #000000\">;\r<\/span><span style=\"color: #0000BB\">OffsetTimeNumber&nbsp;<\/span><span style=\"color: #000000\">=&nbsp;<\/span><span style=\"color: #0000BB\">SecondNumToTimeNum<\/span><span style=\"color: #000000\">(&nbsp;<\/span><span style=\"color: #0000BB\">OffsetSecondNum&nbsp;<\/span><span style=\"color: #000000\">);\rreturn&nbsp;<\/span><span style=\"color: #0000BB\">OffsetTimeNumber<\/span><span style=\"color: #000000\">;\r}<\/span><\/pre>\n<pre><span style=\"color: #0000BB\">OffSet&nbsp;<\/span><span style=\"color: #000000\">=&nbsp;<\/span><span style=\"color: #0000BB\">Param<\/span><span style=\"color: #000000\">(<\/span><span style=\"color: #DD0000\">&quot;Offset&nbsp;in&nbsp;Seconds&quot;<\/span><span style=\"color: #000000\">,<\/span><span style=\"color: #0000BB\">0<\/span><span style=\"color: #000000\">,-<\/span><span style=\"color: #0000BB\">100<\/span><span style=\"color: #000000\">,<\/span><span style=\"color: #0000BB\">100<\/span><span style=\"color: #000000\">,<\/span><span style=\"color: #0000BB\">1<\/span><span style=\"color: #000000\">);\r<\/span><span style=\"color: #0000BB\">RefTimeNum&nbsp;<\/span><span style=\"color: #000000\">=&nbsp;<\/span><span style=\"color: #0000BB\">ParamTime<\/span><span style=\"color: #000000\">(<\/span><span style=\"color: #DD0000\">&quot;ReferenceTime&quot;<\/span><span style=\"color: #000000\">,<\/span><span style=\"color: #0000BB\">Now<\/span><span style=\"color: #000000\">(<\/span><span style=\"color: #0000BB\">2<\/span><span style=\"color: #000000\">));\r<\/span><span style=\"color: #0000BB\">CalcTimeNum&nbsp;<\/span><span style=\"color: #000000\">=&nbsp;<\/span><span style=\"color: #0000BB\">ApplyOffsetToTimeNum<\/span><span style=\"color: #000000\">(&nbsp;<\/span><span style=\"color: #0000BB\">RefTimeNum<\/span><span style=\"color: #000000\">,&nbsp;<\/span><span style=\"color: #0000BB\">Offset&nbsp;<\/span><span style=\"color: #000000\">);\r<\/span><span style=\"color: #0000BB\">Title&nbsp;<\/span><span style=\"color: #000000\">=<\/span><span style=\"color: #DD0000\">&quot;\\n&quot;<\/span><span style=\"color: #000000\">+\r<\/span><span style=\"color: #DD0000\">&quot;&nbsp;Reference&nbsp;Time:&nbsp;&quot;<\/span><span style=\"color: #000000\">+<\/span><span style=\"color: #0000BB\">StrRight<\/span><span style=\"color: #000000\">(<\/span><span style=\"color: #0000BB\">NumToStr<\/span><span style=\"color: #000000\">(<\/span><span style=\"color: #0000BB\">DateTimeConvert<\/span><span style=\"color: #000000\">(&nbsp;<\/span><span style=\"color: #0000BB\">2<\/span><span style=\"color: #000000\">,&nbsp;<\/span><span style=\"color: #0000BB\">DateNum<\/span><span style=\"color: #000000\">(),&nbsp;<\/span><span style=\"color: #0000BB\">RefTimeNum<\/span><span style=\"color: #000000\">),<\/span><span style=\"color: #0000BB\">formatDateTime<\/span><span style=\"color: #000000\">),<\/span><span style=\"color: #0000BB\">11<\/span><span style=\"color: #000000\">)+<\/span><span style=\"color: #DD0000\">&quot;\\n&quot;<\/span><span style=\"color: #000000\">+\r<\/span><span style=\"color: #DD0000\">&quot;Calculated&nbsp;Time:&nbsp;&quot;<\/span><span style=\"color: #000000\">+<\/span><span style=\"color: #0000BB\">StrRight<\/span><span style=\"color: #000000\">(<\/span><span style=\"color: #0000BB\">NumToStr<\/span><span style=\"color: #000000\">(<\/span><span style=\"color: #0000BB\">DateTimeConvert<\/span><span style=\"color: #000000\">(&nbsp;<\/span><span style=\"color: #0000BB\">2<\/span><span style=\"color: #000000\">,&nbsp;<\/span><span style=\"color: #0000BB\">DateNum<\/span><span style=\"color: #000000\">(),&nbsp;<\/span><span style=\"color: #0000BB\">CalcTimeNum&nbsp;<\/span><span style=\"color: #000000\">),<\/span><span style=\"color: #0000BB\">formatDateTime<\/span><span style=\"color: #000000\">),<\/span><span style=\"color: #0000BB\">11<\/span><span style=\"color: #000000\">)+<\/span><span style=\"color: #DD0000\">&quot;\\n&quot;<\/span><span style=\"color: #000000\">;<\/span><\/pre>\n<p>Edited by Al Venosa.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Time calculations are needed when placing GAT (Good At Time) and GTD (Good Till Date) orders. The simplest way is to convert the TimeNum to a SecondNum, perform your calculations in Seconds, and then convert the SecondNum back to a TimeNum. The first two functions below will do that for you. The next function applies [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[64],"tags":[],"_links":{"self":[{"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/posts\/117"}],"collection":[{"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/comments?post=117"}],"version-history":[{"count":0,"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/posts\/117\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/media?parent=117"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/categories?post=117"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/tags?post=117"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}