Exporting Data: Difference between revisions

Revision as of 11:59, 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; 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, or click the Export Data button on the toolbar.
Select ASCII or press Ctrl+E.
Select the Resolution and Field. It is possible to select several resolutions and quote fields for export, data will be exported in 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 check box to export / not to export symbol name.
Check / uncheck the Export description check box to export / not to export symbol description.
In the Time Expressed in indicate the 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, click the header and keep down the left mouse button as you drag the column to its desired place.
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)''' or a '''.qmd file''' (MultiCharts data format).
+Data saved in your database can be exported to a '''text file (ASCII)''' or a '''.qmd file''' (MultiCharts data format).
-The program allows the user to specify the necessary data columns and their order as well as the start/end date/time.
+== How to export data ==
-== How to export data ==
+=== Exporting into QMD ===
-To export data for all instruments into a '''.qmd file''' (MultiCharts data format):
+To export data into a '''.qmd file''' (MultiCharts data format):
-# Open '''QuoteManager''' window
+# Open [[QuoteManager]]
-#* see [[:Category:QuoteManager#Opening QuoteManager|how]]
+# Select a symbol or multiple symbols (see [[Operating_Symbol_List#Selecting Symbol(s) in Symbol List|Selecting Symbol(s) in Symbol list]] section).
-# In QuoteManager main menu select '''File''', then point to '''Export Data''' and click '''Export All Instruments…''' ;or <br>Click the Export Data [[File:QM_Export.png]] icon on the toolbar.
+# Click '''File''' → '''Export Data'''; or <br> 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 necessary options
 # Click '''Next'''
@@ Line 16: / Line 16: @@
 # Click '''Finish'''.
-To export data for a particular instrument / group of instruments into an '''.qmd file''' (MultiCharts data format):
+=== Exporting into ASCII===
-# Open '''QuoteManager''' window
-#* see [[:Category:QuoteManager#Opening QuoteManager|how]]
-# Select a symbol (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.
-# In QuoteManager main menu select '''File''', then point to '''Export Data''' and click '''Export Selected Instruments…''' ;or <br>Click the Export Data [[File:QM_Export.png]] icon 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'''.
 To export data into an '''ASCII file''':
-# Open '''QuoteManager''' window
+# Open [[QuoteManager]]
-#* see [[:Category:QuoteManager#Opening QuoteManager|how]]
 # 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.
-# On the '''File''' menu, click '''Export Data''', or click the '''Export Data''' [[File:QM_Export.png]] icon on the toolbar.
+# Click '''File''' → '''Export Data''', 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 '''ASCII''' or press '''Ctrl+E'''.
 # Select the '''Resolution''' and '''Field'''. It is possible to select several resolutions and quote fields for export, data will be exported in 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.