+1 888 340 6572

Exporting Data: Difference between revisions

From MultiCharts
 
(5 intermediate revisions by 2 users not shown)
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''' → '''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.  
# Select necessary options  
# Select necessary options  
# Click '''Next'''
# Click '''Next'''
Line 16: Line 16:
# Click '''Finish'''.
# 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 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''':
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.
# 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''' → '''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 '''ASCII''' or press '''Ctrl+E'''.
# 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.
# 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''' box to export / not to export symbol name.
# Check / uncheck the '''Export symbol''' check box to export / not to export symbol name.
# Check / uncheck the '''Export description''' box to export / not to export symbol description.   
# Check / uncheck the '''Export description''' check box to export / not to export symbol description.   
# In the '''Time Expressed in''' menu select a time zone for the quotes date/time.  
# 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.
# 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 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.
# 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)'''.
# Select the '''File type''' for exporting data.<br>Available file types are '''Text files(*.txt)''', '''ASCII files (*.asc)''', '''Comma-separated values(*.csv)'''.
<br>
<br>


[[Category: Managing Data]]
[[Category: Managing Data]]

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):

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

Exporting into ASCII

To export data into an ASCII file:

  1. Open QuoteManager
  2. 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.
  3. Click File → Export Data → ASCII , or click the Export Data button on the toolbar.
  4. 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.
  5. Check / uncheck the Export symbol box to export / not to export symbol name.
  6. Check / uncheck the Export description box to export / not to export symbol description.
  7. In the Time Expressed in menu select a time zone for the quotes date/time.
  8. Check / uncheck the Export milliseconds check box to export / not to export millisecond data.
  9. To select the time period for exporting data, set the Start Date/Start Time and End Date/End Time.
  10. To change column order, drag and drop columns to desired places.
  11. Select the File type for exporting data.
    Available file types are Text files(*.txt), ASCII files (*.asc), Comma-separated values(*.csv).


Retrieved from "https://www.multicharts.com/trading-software/index.php?title=Exporting_Data&oldid=12407"
Powered by MediaWiki