+1 888 340 6572

Exporting Data: Difference between revisions

From MultiCharts
Line 21: Line 21:
# Open [[QuoteManager]]  
# 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.
# 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''', 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.
# 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 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.
# 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 symbol''' check box to export / not to export symbol name.

Revision as of 12:06, 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 FileExport Data; 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 FileExport DataASCII , or click the Export Data button on the toolbar.
  4. 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.
  5. Check / uncheck the Export symbol check box to export / not to export symbol name.
  6. Check / uncheck the Export description check box to export / not to export symbol description.
  7. In the Time Expressed in indicate the 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, click the header and keep down the left mouse button as you drag the column to its desired place.
  11. Select the File type for exporting data. Available file types are Text files(*.txt), ASCII files (*.asc), Comma-separated values(*.csv).