Difference between revisions of "Exporting Data"

From MultiCharts
Jump to navigation Jump to search
Line 31: Line 31:
 
# Open '''QuoteManager''' window
 
# Open '''QuoteManager''' window
 
#* see [[:Category:QuoteManager#Opening QuoteManager|how]]
 
#* 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.
+
# 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.  
 
# On the '''File''' menu, click '''Export Data''', or click the '''Export Data''' [[File:QM_Export.png]] icon on the toolbar.  
 
# Select '''ASCII''' or press '''Ctrl+E'''.  
 
# Select '''ASCII''' or press '''Ctrl+E'''.  

Revision as of 18:38, 17 August 2017

The quotes saved in the storage 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

To export data for all instruments into an .qmd file (MultiCharts data format):

  1. Open QuoteManager window
  2. In QuoteManager main menu select File, then point to Export Data and click Export All Instruments… ;or
    Click the Export Data QM Export.png icon on the toolbar.
  3. Select necessary options
  4. Click Next
  5. Enter the name of the *.qmd file and choose the path where it will be located.
  6. Click Next
  7. Click Finish.

To export data for a particular instrument / group of instruments into an .qmd file (MultiCharts data format):

  1. Open QuoteManager window
  2. Select a symbol (see Selecting Symbol(s) in Symbol list section). The program always uses the symbol's Price Scale when exporting.
  3. In QuoteManager main menu select File, then point to Export Data and click Export Instruments… ;or
    Click the Export Data QM Export.png icon 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.

To export data into an ASCII file:

  1. Open QuoteManager window
  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. On the File menu, click Export Data, or click the Export Data QM Export.png icon on the toolbar.
  4. Select ASCII or press Ctrl+E.
  5. 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.
  6. Check / uncheck the Export symbol check box to export / not to export symbol name.
  7. Check / uncheck the Export description check box to export / not to export symbol description.
  8. In the Time Expressed in indicate the time zone for the quotes date/time.
  9. Check / uncheck the Export milliseconds check box to export / not to export millisecond data.
  10. To select the time period for exporting data set the Start Date/Start Time and End Date/End Time.
  11. To change column order, click the header and keep down the left mouse button as you drag the column to its desired place.
  12. Select the File type for exporting data. Available file types are Text files(*.txt), ASCII files (*.asc), Comma-separated values(*.csv).