{"id":1112,"date":"2015-01-26T14:25:29","date_gmt":"2015-01-26T19:25:29","guid":{"rendered":"http:\/\/www.amibroker.com\/kb\/?p=1112"},"modified":"2015-02-12T14:26:22","modified_gmt":"2015-02-12T19:26:22","slug":"choosing-compression-method-for-aux1-and-aux2-fields","status":"publish","type":"post","link":"https:\/\/www.amibroker.com\/wordpress\/kb\/2015\/01\/26\/choosing-compression-method-for-aux1-and-aux2-fields\/","title":{"rendered":"Choosing compression method for Aux1 and Aux2 fields"},"content":{"rendered":"<p>Apart from regular Open, High, Low, Close, Volume, OpenInt fields &#8211; AmiBroker database allows to store custom data in auxiliary fields called Aux1 and Aux2. This allows to import our custom arrays and store in the database.<\/p><p>Since the data stored in those fields will vary, depending on the actual records imported in there &#8211; then in case of time-compressed intervals we may need to determine how exactly these values are compressed if we e.g. switch from <strong>Daily<\/strong> to <strong>Weekly<\/strong> interval. By default these values would get compressed the same way as <strong>Close<\/strong> field, i.e. Last value from given period would be used. We can however choose specific compression method if we need these fields to behave differently (for example like Volume, where weekly record represents a Sum of daily volumes).<\/p><p>The compression mode for Aux1 and Aux2 can be defined in File->Database Settings->Intraday Settings dialog <strong>Aux1,2 aggregation mode<\/strong> field:<\/p><p><img src=\"\/\/www.amibroker.com\/kb\/wp-content\/uploads\/2015\/02\/auxc.png\" alt=\"Aux compression mode\" \/> <\/p>","protected":false},"excerpt":{"rendered":"<p>Apart from regular Open, High, Low, Close, Volume, OpenInt fields &#8211; AmiBroker database allows to store custom data in auxiliary fields called Aux1 and Aux2. This allows to import our custom arrays and store in the database.Since the data stored in those fields will vary, depending on the actual records imported in there &#8211; then [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[5],"tags":[],"_links":{"self":[{"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/posts\/1112"}],"collection":[{"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/comments?post=1112"}],"version-history":[{"count":2,"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/posts\/1112\/revisions"}],"predecessor-version":[{"id":1115,"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/posts\/1112\/revisions\/1115"}],"wp:attachment":[{"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/media?parent=1112"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/categories?post=1112"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/tags?post=1112"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}