Exporting Data: Difference between revisions

Latest revision as of 12:21, 6 June 2024

Data saved in your database can be exported to a text file (ASCII) or a .qmd file (MultiCharts data format).

How to export data

Exporting into QMD

To export data into a .qmd file (MultiCharts data format):

Open QuoteManager
Select a symbol or multiple symbols (see Selecting Symbol(s) in Symbol list section).
Click File → Export Data → Export Selected or All Instruments in QMD file; or click the Export Data button on the toolbar.
Select necessary options
Click Next
Enter the name of the *.qmd file and choose the path where it will be located.
Click Next
Click Finish.

Exporting into ASCII

To export data into an ASCII file:

Open QuoteManager
Select a symbol or multiple symbols (see Selecting Symbol(s) in Symbol list section). The program always uses the symbol's Price Scale when exporting.
Click File → Export Data → ASCII , or click the Export Data button on the toolbar.
Select Resolutions and Fields.
Data will be exported into separate files for each resolution and quote field.
You can click Check all button to select all resolutions and quote fields.
If you click Uncheck all button, all previously selected fields and resolutions will be unchecked.
Check / uncheck the Export symbol box to export / not to export symbol name.
Check / uncheck the Export description box to export / not to export symbol description.
In the Time Expressed in menu select a time zone for the quotes date/time.
Check / uncheck the Export milliseconds check box to export / not to export millisecond data.
To select the time period for exporting data, set the Start Date/Start Time and End Date/End Time.
To change column order, drag and drop columns to desired places.
Select the File type for exporting data.
Available file types are Text files(*.txt), ASCII files (*.asc), Comma-separated values(*.csv).

@@ Line 1: / Line 1: @@
-The quotes saved in the storage can be exported to a text file (ASCII) and imported into most of existing programs. The program allows the user to specify the necessary data columns and their order as well as the start/end date/time.
+Data saved in your database can be exported to a '''text file (ASCII)''' or a '''.qmd file''' (MultiCharts data format).
 == How to export data ==
-To export data:
+=== Exporting into QMD ===
-# Select a symbol (see [[<span style="color: red;">'''LINK'''</span> /101_Symbol_List.html name="2";  |Selecting Symbol(s) in Symbol list]] section). The program always uses the symbol's Price Scale when exporting.
+To export data into a '''.qmd file''' (MultiCharts data format):
-# On the '''File''' menu, click '''Export Data''', or click the '''Export Data''' http://www.multicharts.com/img/wiki/toolbar/QM/04_DataExp.png icon on the toolbar.
-# Select '''ASCII''' or press '''Ctrl+E'''.
+# Open [[QuoteManager]]
-# Select the '''Resolution''' and '''Field'''.
+# Select a symbol or multiple symbols (see [[Operating_Symbol_List#Selecting Symbol(s) in Symbol List|Selecting Symbol(s) in Symbol list]] section).
-# In the '''Time Expressed''' in indicate the time zone for the quotes date/time.
+# Click '''File''' → '''Export Data''' → '''Export Selected or All Instruments in QMD file'''; or click the '''Export Data''' button <img src="https://www.multicharts.com/trading-software/images/8/82/Exporting_Data.png?20240605111025" width="24"> on the toolbar.
-# To select the time period for exporting data set the '''Start Date/Start Time''' and '''End Date/End Time'''.
+# Select necessary options
-# To change column order, click the header and keep down the left mouse button as you drag the column to its desired place.
+# Click '''Next'''
+# Enter the name of the *.qmd file and choose the path where it will be located.
+# Click '''Next'''
+# Click '''Finish'''.
+=== Exporting into ASCII===
+To export data into an '''ASCII file''':
+# Open [[QuoteManager]]
+# Select a symbol or multiple symbols (see [[Operating_Symbol_List#Selecting Symbol(s) in Symbol List|Selecting Symbol(s) in Symbol list]] section). The program always uses the symbol's Price Scale when exporting.
+# Click '''File''' → '''Export Data''' → '''ASCII''' , or click the '''Export Data''' button <img src="https://www.multicharts.com/trading-software/images/8/82/Exporting_Data.png?20240605111025" width="24"> on the toolbar.
+# Select '''Resolutions and Fields'''.<br>Data will be exported into separate files for each resolution and quote field.<br>You can click '''Check all''' button to select all resolutions and quote fields.<br>If you click '''Uncheck all''' button, all previously selected fields and resolutions will be unchecked.
+# Check / uncheck the '''Export symbol''' box to export / not to export symbol name.
+# Check / uncheck the '''Export description''' box to export / not to export symbol description.
+# In the '''Time Expressed in''' menu select a time zone for the quotes date/time.
+# Check / uncheck the '''Export milliseconds''' check box to export / not to export millisecond data.
+# To select the time period for exporting data, set the '''Start Date/Start Time''' and '''End Date/End Time'''.
+# To change column order, drag and drop columns to desired places.
+# Select the '''File type''' for exporting data.<br>Available file types are '''Text files(*.txt)''', '''ASCII files (*.asc)''', '''Comma-separated values(*.csv)'''.
 <br>
 [[Category: Managing Data]]