384
edits
Importing Data: Difference between revisions
From MultiCharts
m
→Importing .qmd data (MultiCharts data format)
Dave Masalov (talk | contribs) No edit summary |
|||
| (5 intermediate revisions by 3 users not shown) | |||
| Line 4: | Line 4: | ||
#* see [[:Category:QuoteManager#Opening QuoteManager|how]] | #* see [[:Category:QuoteManager#Opening QuoteManager|how]] | ||
# In QuoteManager main menu select '''File''', then point to '''Import Data''' and click '''Import Instruments…''' | # In QuoteManager main menu select '''File''', then point to '''Import Data''' and click '''Import Instruments…''' | ||
# Select the file location | # Select the file location | ||
# Click '''Next''' | # Click '''Next''' | ||
# Select the instruments to import | # Select the instruments to import | ||
| Line 21: | Line 21: | ||
<br> | <br> | ||
== What values can be imported == | |||
For different data types different values can be imported. Some of them are obligatory and marked below as '''bold'''. | |||
* '''Tick data:''' | |||
'''Date''', '''Time''', '''Price''', '''Volume'''. | |||
* '''Minute data:''' | |||
'''Date''', '''Time''', '''Open''', '''High''', '''Low''', '''Close''', '''Volume''', Up Volume, Down Volume, Unchanged Volume, Up Ticks, Down Ticks, Unchanged Ticks, Total Ticks. | |||
* '''Daily data:''' | |||
'''Date''', '''Open''', '''High''', '''Low''', '''Close''', '''Volume''', Up Volume, Down Volume, Unchanged Volume, Up Ticks, Down Ticks, Unchanged Ticks, Total Ticks, Open Interest. | |||
== How to import ASCII data == | == How to import ASCII data == | ||
| Line 31: | Line 45: | ||
# Select '''ASCII''' or press '''Ctrl+I'''. | # Select '''ASCII''' or press '''Ctrl+I'''. | ||
# Indicate the '''Path'''. The path can be typed in, pasted from the clipboard or selected using the mouse. The selected path persists after converting the file so on next operation the previous path will be used by default. If it is necessary to move up a level, click the '''Up''' icon. To change the method of displaying files click the rightmost icon '''Views''' and select an option from the drop down menu. | # Indicate the '''Path'''. The path can be typed in, pasted from the clipboard or selected using the mouse. The selected path persists after converting the file so on next operation the previous path will be used by default. If it is necessary to move up a level, click the '''Up''' icon. To change the method of displaying files click the rightmost icon '''Views''' and select an option from the drop down menu. | ||
# Select the desired file from the indicated folder. | # Select the desired file from the indicated folder. Only one file can be imported at a time. | ||
# If the '''Contents of the selected file''' field the information is garbled, choose the proper encoding in the File origin. | # If the '''Contents of the selected file''' field the information is garbled, choose the proper encoding in the File origin. | ||
# Make sure the '''Resolution''' is valid. If the value is not correct, the possible causes may be the reason:<br> | # Make sure the '''Resolution''' is valid. If the value is not correct, the possible causes may be the reason:<br> | ||
| Line 55: | Line 69: | ||
#* Wrong detection of the starting line of quotes | #* Wrong detection of the starting line of quotes | ||
#*: To set '''Start at Row''' You should indicate how many lines to skip.<br><div style="background-color: #F8F6CD;">After those parameters have been properly set, the program analyses the file again and sets the proper Resolution.</div> | #*: To set '''Start at Row''' You should indicate how many lines to skip.<br><div style="background-color: #F8F6CD;">After those parameters have been properly set, the program analyses the file again and sets the proper Resolution.</div> | ||
# Select '''Field Ask''', '''Bid''' or '''Trade''' to define what | # Select '''Field Ask''', '''Bid''' or '''Trade''' to define what kind of data the file contains. It is only possible to import only '''one''' quote field at a time. | ||
# In the '''Time Zone''' please select the time zone of the quotes' origin. | # In the '''Time Zone''' please select the time zone of the quotes' origin. | ||
# If the price or volume needs to be multiplied or divided, select a proper factor in '''Price Multiplier''' or '''Volume Multiplier'''. | # If the price or volume needs to be multiplied or divided, select a proper factor in '''Price Multiplier''' or '''Volume Multiplier'''. | ||
| Line 123: | Line 137: | ||
Other data types may not be added to the database - use [[Mapping_ASCII|ASCII Mapping]] to process such files. | Other data types may not be added to the database - use [[Mapping_ASCII|ASCII Mapping]] to process such files. | ||
ASCII files that are larger than 4 GB cannot be processed correctly. | |||
[[Category:Managing Data]] | [[Category:Managing Data]] | ||
