{"id":5,"date":"2006-03-04T20:56:07","date_gmt":"2006-03-05T01:56:07","guid":{"rendered":"http:\/\/www.amibroker.com\/kb\/2006\/03\/04\/how-to-export-quotations-from-amibroker-to-csv-file\/"},"modified":"2014-12-04T08:24:21","modified_gmt":"2014-12-04T13:24:21","slug":"how-to-export-quotations-from-amibroker-to-csv-file","status":"publish","type":"post","link":"https:\/\/www.amibroker.com\/wordpress\/kb\/2006\/03\/04\/how-to-export-quotations-from-amibroker-to-csv-file\/","title":{"rendered":"How to export quotations from AmiBroker to CSV file ?"},"content":{"rendered":"

The easiest way to export quotes to CSV file is to use the below formula from Automatic Analysis window:
(Analysis -> Automatic Analysis)

Filter<\/span>=<\/span>1<\/span>;
<\/span>AddColumn<\/span>(<\/span>O<\/span>,<\/span>"Open"<\/span>);
<\/span>AddColumn<\/span>(<\/span>H<\/span>,<\/span>"High"<\/span>);
<\/span>AddColumn<\/span>(<\/span>L<\/span>,<\/span>"Low"<\/span>);
<\/span>AddColumn<\/span>(<\/span>C<\/span>,<\/span>"Close"<\/span>);
<\/span>AddColumn<\/span>(<\/span>V<\/span>,<\/span>"Volume"<\/span>,<\/span>1.0<\/span>);
<\/span>AddColumn<\/span>(<\/span>OI<\/span>,<\/span>"Open Interest"<\/span>,<\/span>1.0<\/span>)<\/code>

  1. Open: Analysis->Formula Editor<\/strong><\/li>
  2. Paste the above formula into formula window <\/li>
  3. Choose Tools->Send to Auto-Analysis<\/strong> menu in the Formula Editor<\/li>
  4. In Automatic Analysis window select Apply to: All Stocks<\/strong>, Range: All quotations<\/strong> (or any other time range or filter, depending on what you need to export) <\/li>
  5. Press Explore<\/strong> button <\/li>
  6. Press Export<\/strong> button, specify the name and press OK<\/li><\/ol>","protected":false},"excerpt":{"rendered":"

    The easiest way to export quotes to CSV file is to use the below formula from Automatic Analysis window:(Analysis -> Automatic Analysis)<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[5,6],"tags":[53,14,54,31],"_links":{"self":[{"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/posts\/5"}],"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=5"}],"version-history":[{"count":1,"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/posts\/5\/revisions"}],"predecessor-version":[{"id":814,"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/posts\/5\/revisions\/814"}],"wp:attachment":[{"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/media?parent=5"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/categories?post=5"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/tags?post=5"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}