{"id":1181,"date":"2015-10-01T04:52:34","date_gmt":"2015-10-01T09:52:34","guid":{"rendered":"http:\/\/www.amibroker.com\/kb\/?p=1181"},"modified":"2015-10-01T05:17:16","modified_gmt":"2015-10-01T10:17:16","slug":"how-to-categorize-symbols-coming-from-metastock-databases","status":"publish","type":"post","link":"https:\/\/www.amibroker.com\/wordpress\/kb\/2015\/10\/01\/how-to-categorize-symbols-coming-from-metastock-databases\/","title":{"rendered":"How to categorize symbols coming from Metastock databases"},"content":{"rendered":"<p>Many data vendors that deliver data in MetaStock database format offer quotes in separate MS databases organized in several folders, separate for different markets or industries. <\/p><p>AmiBroker does not have any symbol limits, there is no need to maintain separate databases in AB and all the quotes can be placed in a single database. The configuration process of Metastock database as external data source is described here: <a href=\"http:\/\/www.amibroker.com\/guide\/h_extsources.html\">http:\/\/www.amibroker.com\/guide\/h_extsources.html<\/a><\/p><p>AmiBroker supports internally many ways to categorise symbols into groups, markets, sectors, industries, etc. To learn more about categories available in AmiBroker please check this: <a href=\"http:\/\/www.amibroker.com\/guide\/h_categories.html\">http:\/\/www.amibroker.com\/guide\/h_categories.html<\/a><\/p><p>Now we may want to bring MS folder structure into AmiBroker&#8217;s category system. Sometimes data vendor would prepare appropriate automation scripts to do that work for us, but when they are not available, we can arrange the categories ourselves in the initial setup process.<\/p><p>To do so, we could pick the folders one-by-one, then reassign the symbols to desired categories. The process is the following:<\/p><p>First we configure the database:<\/p><ul><li>Select <strong>File->New->Database<\/strong> menu<li>Enter the folder name and press <strong>Create<\/strong><li>Choose MetaStock plugin as the datasource<li>Press <strong>Configure<\/strong><\/ul><p><img src=\"\/\/www.amibroker.com\/kb\/wp-content\/uploads\/2015\/10\/ms1.png\" alt=\"MS plugin config\" \/><\/p><p>Now we pick <strong>single<\/strong> MetaStock folder (AmiBroker allows to import them all at once, however we want to avoid mixing the symbols from various folders) and press <strong>Retrieve<\/strong> button.<\/p><p><img src=\"\/\/www.amibroker.com\/kb\/wp-content\/uploads\/2015\/10\/ms2.png\" alt=\"MS plugin config\" \/><\/p><p>After pressing <strong>Retrieve<\/strong> we can close the database configuration dialog (OK, then OK again), go to <strong>Symbol->Organize Assignments<\/strong> and reassign the newly imported symbols from Undefined market or Industry into our desired location.<\/p><p><img src=\"\/\/www.amibroker.com\/kb\/wp-content\/uploads\/2015\/10\/ms3.png\" alt=\"MS plugin config\" \/><\/p><p>Now we can return to <strong>File->Database Settings->Configure<\/strong>, retrieve another folder and repeat the assignment for that folder and so on and so on. <\/p><p>It is important to mention that this is just one-time procedure. After it is done, AmiBroker will automatically read all updates directly from MetaStock files.<\/p><p>There are also data-vendors offering data in MS format (such as PremiumData for example) that deliver ready-to-use configuration scripts &#8211; in such case it would allow to avoid such manual setup procedure and synchronize all category assignments automatically. <\/p>","protected":false},"excerpt":{"rendered":"<p>Many data vendors that deliver data in MetaStock database format offer quotes in separate MS databases organized in several folders, separate for different markets or industries. AmiBroker does not have any symbol limits, there is no need to maintain separate databases in AB and all the quotes can be placed in a single database. The [&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":[64,54,63],"_links":{"self":[{"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/posts\/1181"}],"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=1181"}],"version-history":[{"count":3,"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/posts\/1181\/revisions"}],"predecessor-version":[{"id":1193,"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/posts\/1181\/revisions\/1193"}],"wp:attachment":[{"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/media?parent=1181"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/categories?post=1181"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/tags?post=1181"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}