726
edits
Exporting Data: Difference between revisions
From MultiCharts
no edit summary
Dave Masalov (talk | contribs) No edit summary |
No edit summary |
||
| (9 intermediate revisions by 6 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). | 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. | The program allows the user to specify the necessary data columns and their order as well as the start/end date/time. | ||
| Line 5: | Line 5: | ||
== How to export data == | == How to export data == | ||
To export data for all instruments into | To export data for all instruments into a '''.qmd file''' (MultiCharts data format): | ||
# Open '''QuoteManager''' window | # Open '''QuoteManager''' window | ||
#* see [[:Category:QuoteManager#Opening QuoteManager|how]] | #* see [[:Category:QuoteManager#Opening QuoteManager|how]] | ||
# In QuoteManager main menu select '''File''', then point to '''Export Data''' and click '''Export All Instruments…''' ;or <br>Click the Export Data | # 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. | ||
# 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): | To export data for a particular instrument / group of instruments into an '''.qmd file''' (MultiCharts data format): | ||
# 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 (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 | # 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 | # Select necessary options | ||
# Click '''Next''' | # Click '''Next''' | ||
| Line 28: | Line 28: | ||
# Click '''Finish'''. | # Click '''Finish'''. | ||
To export data into an ASCII file: | To export data into an '''ASCII file''': | ||
# 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''' | # 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'''. | ||
# Select the '''Resolution''' and '''Field'''. | # 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. | # 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 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, 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)'''. | |||
<br> | <br> | ||
[[Category: Managing Data]] | [[Category: Managing Data]] | ||
