{"id":1093,"date":"2015-01-29T18:45:08","date_gmt":"2015-01-29T23:45:08","guid":{"rendered":"http:\/\/www.amibroker.com\/kb\/?p=1093"},"modified":"2015-02-11T19:01:50","modified_gmt":"2015-02-12T00:01:50","slug":"importing-auxilliary-data-into-amibroker-database","status":"publish","type":"post","link":"https:\/\/www.amibroker.com\/wordpress\/kb\/2015\/01\/29\/importing-auxilliary-data-into-amibroker-database\/","title":{"rendered":"Importing auxilliary data into AmiBroker database"},"content":{"rendered":"<p>AmiBroker database structure offers the following fields: Open, High, Low, Close, Volume, OpenInt, Aux1, Aux2. The last two fields, i.e. <strong>Aux1<\/strong> and <strong>Aux2<\/strong> are meant for storing any custom historical data-arrays we may need.<\/p><p>Pretty often, we already have quotations data present in the database and we just want to put some extra data into auxiliary fields. To combine existing data with imported data, we can need to use hybrid mode. In the <a href=\"http:\/\/www.amibroker.com\/guide\/w_impwizard.html\">Import Wizard<\/a> just add this command in &#8220;Additional commands&#8217; field.<\/p><pre>\r# This example assumes that file has format: \r# Symbol, Year-Month-Day, auxiliary_data1, auxiliary_data2\r$FORMAT Name, Date_YMD, Aux1, Aux2\r$HYBRID 1\r$ALLOWNEG 1\r<\/pre><p>Hybrid mode works so that with each imported record it looks for matching record in the database and it combines existing data with data being imported. If OHLC prices are not provided in the imported file you need to specify $ALLOWNEG 1 option. Otherwise you would get error messages about missing close price.<\/p><p>Auxiliary data fields can then be read using simply <strong>Aux1<\/strong> and <strong>Aux2<\/strong> identifiers:<\/p><code style=\"color: #0000BB\">Plot<\/span><span style=\"color: #000000\">(&nbsp;<\/span><span style=\"color: #0000BB\">Aux1<\/span><span style=\"color: #000000\">,&nbsp;<\/span><span style=\"color: #DD0000\">&quot;Aux1&quot;<\/span><span style=\"color: #000000\">,&nbsp;<\/span><span style=\"color: #0000BB\">colorRed&nbsp;<\/span><span style=\"color: #000000\">)<\/code><p>However &#8211; if two additional fields are not enough for our purposes, we can also import quotes into some synthetic tickers and have another set of OHLC, V, OI, Aux1 and Aux2 fields available for importing. Synthetic ticker in this context means just a custom symbol name that&#8217;s used just for storing such extra data. So &#8211; instead of importing additional arrays into IBM ticker or AAPL ticker, we could use for example IBM_extra and AAPL_extra symbols and their fields.<\/p><p>Using such common naming pattern (i.e. identical &#8216;_extra&#8217; suffix with the original ticker name) will be useful, because later on to access data from the selected field we could use just the following AFL call:<\/p><code style=\"color: #0000BB\">myVal&nbsp;<\/span><span style=\"color: #000000\">=&nbsp;<\/span><span style=\"color: #0000BB\">Foreign<\/span><span style=\"color: #000000\">(&nbsp;<\/span><span style=\"color: #0000BB\">Name<\/span><span style=\"color: #000000\">()&nbsp;+<\/span><span style=\"color: #DD0000\">&quot;_extra&quot;<\/span><span style=\"color: #000000\">,&nbsp;<\/span><span style=\"color: #DD0000\">&quot;C&quot;<\/span><span style=\"color: #000000\">)<\/code><p>and this line will read value from <strong>Close<\/strong> field of the respective &#8216;extra&#8217; ticker as we select IBM or AAPL.<\/p><p>An alternative way to store and handle several custom arrays would be to use SQL database, then we could use ODBC plugin to read such data. The documentation of ODBC plugin is available at:<\/p><p><a href=\"http:\/\/www.amibroker.com\/odbc.html\" title=\"ODBC plugin\">http:\/\/www.amibroker.com\/odbc.html<\/a><\/p>","protected":false},"excerpt":{"rendered":"<p>AmiBroker database structure offers the following fields: Open, High, Low, Close, Volume, OpenInt, Aux1, Aux2. The last two fields, i.e. Aux1 and Aux2 are meant for storing any custom historical data-arrays we may need.Pretty often, we already have quotations data present in the database and we just want to put some extra data into auxiliary [&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\/1093"}],"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=1093"}],"version-history":[{"count":2,"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/posts\/1093\/revisions"}],"predecessor-version":[{"id":1099,"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/posts\/1093\/revisions\/1099"}],"wp:attachment":[{"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/media?parent=1093"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/categories?post=1093"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/tags?post=1093"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}