192
edits
Changes
Jump to navigation
Jump to search
m
#* see [[:Category:QuoteManager#Opening QuoteManager|how]]
# In QuoteManager main menu select '''File''', then point to '''Import Data''' and click '''Import Instruments…'''
# Select the file location and click
# Click '''Next'''
# Select the instruments to import
<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 ==
# 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.
# 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.
# Make sure the '''Resolution''' is valid. If the value is not correct, the possible causes may be the reason:<br>
#* 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>
# 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.
# If the price or volume needs to be multiplied or divided, select a proper factor in '''Price Multiplier''' or '''Volume Multiplier'''.
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]]
