{"id":2603,"date":"2021-06-05T07:10:05","date_gmt":"2021-06-05T07:10:05","guid":{"rendered":"https:\/\/www.overcharts.com\/en\/helpcenter\/?post_type=docs&#038;p=2603"},"modified":"2023-05-12T09:24:40","modified_gmt":"2023-05-12T09:24:40","password":"","slug":"data-export","status":"publish","type":"docs","link":"https:\/\/www.overcharts.com\/en\/helpcenter\/docs\/data-export\/","title":{"rendered":"Data Export"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">The export procedure allows you <strong><em>to export the historical data present in the instrument&#8217;s local database to a text file (csv or txt)<\/em><\/strong> to then be imported, for example, in another (or the same) Overcharts installation (using <strong><a href=\"https:\/\/www.overcharts.com\/en\/helpcenter\/docs\/data-import\/\" target=\"_blank\" rel=\"noreferrer noopener\">data import<\/a><\/strong> procedure) or in another application (usually Excel).<\/p>\n\n\n\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"0-toc-title\"><strong>Access Data Export<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">You can access data-export in one of the following ways:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>from <em>Overcharts main window<\/em> &gt;<em> <strong>Instrument<\/strong><\/em><strong><em>s<\/em> <\/strong>Tab &gt; <em><strong>Data Export <\/strong><\/em>button<\/li>\n\n\n\n<li>or from <em>Overcharts main window<\/em> &gt; <strong><em>Instruments<\/em><\/strong> menu &gt; <em>Data Export<\/em><\/li>\n<\/ul>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">To export data for a specific instrument:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>From <em>Overcharts main window<\/em> &gt; <em><strong>Instruments<\/strong> Tab<\/em>, select the instrument to export<\/li>\n\n\n\n<li><em>Right click <\/em>&gt; <em>Export Data<\/em><\/li>\n<\/ol>\n\n\n\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Export instrument historical data<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The procedure allows you <strong>to export the historical data present in the instrument&#8217;s local database<\/strong> to a text file (csv or txt).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To export data from one or more instruments, follow these steps:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>1<\/strong>. <strong>Make sure that any historical data you wish to export is present in the local database.<\/strong> Data is saved in the database ONLY during a total recalculation\/refresh of the chart and then when opening the chart\/workspace or after connecting to the data-feed. Real-time data is NEVER saved to the database. For example, if you stay connected to your data-feed for 3 days without performing any total recalculation\/refresh of the chart, the latest data in the local database will be that of 3 days ago.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Also, the chart MUST be built using the time frame being exported. For example if you want to export 1-Minute historical data, the chart MUST be constructed with a resolution of 1 or x <em>minutes<\/em>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To perform a total recalculation\/refresh of a chart:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>refresh the chart with the appropriate command (<em>chart window<\/em> &gt; <em>Maintenance<\/em> menu &gt; <em>Refresh<\/em>)<\/li>\n\n\n\n<li>or close the workspace containing the chart &gt; connect the data-feed &gt; reopen the workspace<\/li>\n\n\n\n<li>or keeping the workspace open &gt; disconnect and connect the data-feed again.<\/li>\n<\/ul>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">The historical data interval requested from the data-feed (and therefore saved in the local database) will be only those necessary for calculating the chart. For example, if you want to export the historical data of last 90 days of an instrument, to be sure you have all the data you will have to open a chart of last 90 days or more.<\/p>\n\n\n\n<p class=\"has-background wp-block-paragraph\" style=\"background-color:#cce9f5\">If you have many instruments to update, instead of recalculating\/refreshing every single chart, you can also use the massive <strong><a href=\"https:\/\/www.overcharts.com\/en\/helpcenter\/docs\/historical-data-download\/#0-toc-title\" target=\"_blank\" rel=\"noreferrer noopener\">data download<\/a><\/strong> function.<\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>2<\/strong>. <strong><a href=\"#0-toc-title\">Access<\/a><\/strong> the export procedure.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>3<\/strong>. Set the following parameters:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Time Frame to export<\/strong>: select the time frame to export. The time frame MUST be present in the database. If the instrument uses <strong><a href=\"https:\/\/www.overcharts.com\/en\/helpcenter\/docs\/instrument-configuration\/#5-toc-title\" target=\"_blank\" rel=\"noreferrer noopener\">standard time frames<\/a><\/strong> (<em>99% of cases<\/em>), there are only 3 time frames in the local database: <em>1-Tick<\/em>, <em>1-Minute<\/em>, <em>1-Day<\/em>. During the export you will necessarily have to select one of these time frames. For example, if you select a <em>5-minute<\/em> time frame, NO data will be exported. In fact, 5-minute time frame is NOT present in the local database.<\/li>\n\n\n\n<li><strong>Date Range to export<\/strong>: define the date range to export<\/li>\n\n\n\n<li><strong>File Format<\/strong>: File format is automatically set according to the selected time frame. If you are exporting data to back up the database or import it to another Overcharts installation, we recommend using the preset <strong><em>Standard Export<\/em><\/strong> formats.<\/li>\n\n\n\n<li><strong>Data time zone<\/strong>: Select the time zone to use for the data to be exported (<em>default: UTC<\/em>).<\/li>\n\n\n\n<li><strong>Bar TimeStamp<\/strong>: (<em>only visible for minute time frames<\/em>) Select this option if timestamp in the data being exported is the bar closing time. For example, in a 5-minute bar (from 10:00:00 to 10:04:59), 10:00:00 represents the bar&#8217;s start-time (<em>On Open<\/em>) and 10:05:00 the bar&#8217;s end-time (<em>On Close<\/em>).<\/li>\n<\/ul>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>4<\/strong>. Select the instruments to export by pressing <strong><em>Add<\/em><\/strong> button:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"730\" height=\"177\" src=\"https:\/\/www.overcharts.com\/en\/helpcenter\/wp-content\/uploads\/2021\/06\/export-data-instruments1.png\" alt=\"\" class=\"wp-image-2612\" srcset=\"https:\/\/www.overcharts.com\/en\/helpcenter\/wp-content\/uploads\/2021\/06\/export-data-instruments1.png 730w, https:\/\/www.overcharts.com\/en\/helpcenter\/wp-content\/uploads\/2021\/06\/export-data-instruments1-640x155.png 640w, https:\/\/www.overcharts.com\/en\/helpcenter\/wp-content\/uploads\/2021\/06\/export-data-instruments1-400x97.png 400w\" sizes=\"auto, (max-width: 730px) 100vw, 730px\" \/><\/figure>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-background wp-block-paragraph\" style=\"background-color:#fff36b\"><strong>All instruments in the list will be exported to the same text file<\/strong>. For this reason, if the date range to be exported is very large or more generally the amount of data to be exported is very large (for example when the export time frame is 1-Tick), make sure you have enough disk space. The exported text file may be very large (several gigabytes).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In the <strong><em>Historical data available in the database<\/em><\/strong> column you can check if date range being exported is available in the instrument database. The column shows first and last date available in the database for the time frame being exported. To make reading easier, column\/cell background is colored differently depending on availability:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Green<\/strong>: date range being exported is <strong><em>available<\/em><\/strong> in the database<\/li>\n\n\n\n<li><strong>Yellow<\/strong>: date range being exported is <strong><em>partially available<\/em><\/strong> in the database<\/li>\n\n\n\n<li><strong>Red<\/strong>: date range being exported is <strong><em>NOT available<\/em><\/strong> in the database<\/li>\n\n\n\n<li><strong>Gray<\/strong>: <strong><em>no data<\/em><\/strong> available for the time frame being exported<\/li>\n<\/ul>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">If the background is NOT green, we recommend you modify the date range to be exported or refresh the instrument chart in order to download (if possible) missing data (<em>see step 1<\/em>).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>5<\/strong>. Define the <strong>path<\/strong>, <strong>name<\/strong> and <strong>extension<\/strong> (.txt or .csv) of the export file. <em>DO NOT include the extension in the file name, but select it using the appropriate combo-box.<\/em><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>6<\/strong>. Press <strong>EXPORT<\/strong> button to start the export.<\/p>\n\n\n\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Warnings<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>If the time frame being exported is 1-Tick, you can only export one instrument at a time. This limitation is to avoid creating a text file too large. In fact, 1-Tick time frame can contain millions of data for every single day.<\/li>\n<\/ul>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>The export procedure allows you to export the historical data present in the instrument&#8217;s local database to a text file (csv or txt) to then be imported, for example, in another (or the same) Overcharts installation (using data import procedure) or in another application (usually Excel). Access Data Export You can access data-export in one [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"doc_category":[8],"doc_tag":[],"class_list":["post-2603","docs","type-docs","status-publish","hentry","doc_category-instruments"],"year_month":"2026-10","word_count":869,"total_views":"3","reactions":{"happy":"0","normal":"0","sad":"0"},"author_info":{"name":"Overcharts Team","author_nicename":"overadmin","author_url":"https:\/\/www.overcharts.com\/en\/helpcenter\/author\/overadmin\/"},"doc_category_info":[{"term_name":"Instruments","term_url":"https:\/\/www.overcharts.com\/en\/helpcenter\/docs-category\/instruments\/"}],"doc_tag_info":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\r\n<title>Data Export - Overcharts Help Center<\/title>\r\n<meta name=\"description\" content=\"The export procedure allows you to export the historical data present in the instrument&#039;s local database to a text file (csv or txt).\" \/>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/www.overcharts.com\/en\/helpcenter\/docs\/data-export\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"Data Export - Overcharts Help Center\" \/>\r\n<meta property=\"og:description\" content=\"The export procedure allows you to export the historical data present in the instrument&#039;s local database to a text file (csv or txt).\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/www.overcharts.com\/en\/helpcenter\/docs\/data-export\/\" \/>\r\n<meta property=\"og:site_name\" content=\"Overcharts Help Center\" \/>\r\n<meta property=\"article:modified_time\" content=\"2023-05-12T09:24:40+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/www.overcharts.com\/en\/helpcenter\/wp-content\/uploads\/2021\/06\/export-data-instruments1.png\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"5 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.overcharts.com\\\/en\\\/helpcenter\\\/docs\\\/data-export\\\/\",\"url\":\"https:\\\/\\\/www.overcharts.com\\\/en\\\/helpcenter\\\/docs\\\/data-export\\\/\",\"name\":\"Data Export - Overcharts Help Center\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.overcharts.com\\\/en\\\/helpcenter\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.overcharts.com\\\/en\\\/helpcenter\\\/docs\\\/data-export\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.overcharts.com\\\/en\\\/helpcenter\\\/docs\\\/data-export\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.overcharts.com\\\/en\\\/helpcenter\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/export-data-instruments1.png\",\"datePublished\":\"2021-06-05T07:10:05+00:00\",\"dateModified\":\"2023-05-12T09:24:40+00:00\",\"description\":\"The export procedure allows you to export the historical data present in the instrument's local database to a text file (csv or txt).\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.overcharts.com\\\/en\\\/helpcenter\\\/docs\\\/data-export\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.overcharts.com\\\/en\\\/helpcenter\\\/docs\\\/data-export\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.overcharts.com\\\/en\\\/helpcenter\\\/docs\\\/data-export\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.overcharts.com\\\/en\\\/helpcenter\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/export-data-instruments1.png\",\"contentUrl\":\"https:\\\/\\\/www.overcharts.com\\\/en\\\/helpcenter\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/export-data-instruments1.png\",\"width\":730,\"height\":177},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.overcharts.com\\\/en\\\/helpcenter\\\/docs\\\/data-export\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.overcharts.com\\\/en\\\/helpcenter\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data Export\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.overcharts.com\\\/en\\\/helpcenter\\\/#website\",\"url\":\"https:\\\/\\\/www.overcharts.com\\\/en\\\/helpcenter\\\/\",\"name\":\"Overcharts Help Center\",\"description\":\"Trading Software &amp; Technical Analysis\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.overcharts.com\\\/en\\\/helpcenter\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Data Export - Overcharts Help Center","description":"The export procedure allows you to export the historical data present in the instrument's local database to a text file (csv or txt).","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.overcharts.com\/en\/helpcenter\/docs\/data-export\/","og_locale":"en_US","og_type":"article","og_title":"Data Export - Overcharts Help Center","og_description":"The export procedure allows you to export the historical data present in the instrument's local database to a text file (csv or txt).","og_url":"https:\/\/www.overcharts.com\/en\/helpcenter\/docs\/data-export\/","og_site_name":"Overcharts Help Center","article_modified_time":"2023-05-12T09:24:40+00:00","og_image":[{"url":"https:\/\/www.overcharts.com\/en\/helpcenter\/wp-content\/uploads\/2021\/06\/export-data-instruments1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.overcharts.com\/en\/helpcenter\/docs\/data-export\/","url":"https:\/\/www.overcharts.com\/en\/helpcenter\/docs\/data-export\/","name":"Data Export - Overcharts Help Center","isPartOf":{"@id":"https:\/\/www.overcharts.com\/en\/helpcenter\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.overcharts.com\/en\/helpcenter\/docs\/data-export\/#primaryimage"},"image":{"@id":"https:\/\/www.overcharts.com\/en\/helpcenter\/docs\/data-export\/#primaryimage"},"thumbnailUrl":"https:\/\/www.overcharts.com\/en\/helpcenter\/wp-content\/uploads\/2021\/06\/export-data-instruments1.png","datePublished":"2021-06-05T07:10:05+00:00","dateModified":"2023-05-12T09:24:40+00:00","description":"The export procedure allows you to export the historical data present in the instrument's local database to a text file (csv or txt).","breadcrumb":{"@id":"https:\/\/www.overcharts.com\/en\/helpcenter\/docs\/data-export\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.overcharts.com\/en\/helpcenter\/docs\/data-export\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.overcharts.com\/en\/helpcenter\/docs\/data-export\/#primaryimage","url":"https:\/\/www.overcharts.com\/en\/helpcenter\/wp-content\/uploads\/2021\/06\/export-data-instruments1.png","contentUrl":"https:\/\/www.overcharts.com\/en\/helpcenter\/wp-content\/uploads\/2021\/06\/export-data-instruments1.png","width":730,"height":177},{"@type":"BreadcrumbList","@id":"https:\/\/www.overcharts.com\/en\/helpcenter\/docs\/data-export\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.overcharts.com\/en\/helpcenter\/"},{"@type":"ListItem","position":2,"name":"Data Export"}]},{"@type":"WebSite","@id":"https:\/\/www.overcharts.com\/en\/helpcenter\/#website","url":"https:\/\/www.overcharts.com\/en\/helpcenter\/","name":"Overcharts Help Center","description":"Trading Software &amp; Technical Analysis","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.overcharts.com\/en\/helpcenter\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/www.overcharts.com\/en\/helpcenter\/wp-json\/wp\/v2\/docs\/2603","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.overcharts.com\/en\/helpcenter\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/www.overcharts.com\/en\/helpcenter\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/www.overcharts.com\/en\/helpcenter\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.overcharts.com\/en\/helpcenter\/wp-json\/wp\/v2\/comments?post=2603"}],"version-history":[{"count":20,"href":"https:\/\/www.overcharts.com\/en\/helpcenter\/wp-json\/wp\/v2\/docs\/2603\/revisions"}],"predecessor-version":[{"id":2628,"href":"https:\/\/www.overcharts.com\/en\/helpcenter\/wp-json\/wp\/v2\/docs\/2603\/revisions\/2628"}],"wp:attachment":[{"href":"https:\/\/www.overcharts.com\/en\/helpcenter\/wp-json\/wp\/v2\/media?parent=2603"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/www.overcharts.com\/en\/helpcenter\/wp-json\/wp\/v2\/doc_category?post=2603"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/www.overcharts.com\/en\/helpcenter\/wp-json\/wp\/v2\/doc_tag?post=2603"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}