1,501
edits
No edit summary |
|||
Line 1: | Line 1: | ||
The program supports importing from most known text (ASCII) files. The principal requirement for the file is a clear structure, data integrity and absence of logical errors. | The program supports importing from most known text (ASCII) files. The principal requirement for the file is a clear structure, data integrity and absence of logical errors. | ||
See [[ | See [[#Invalid ASCII files|Invalid ASCII files]] section for information on the most common file faults. | ||
The program is based on analyzing several hundreds of quote files, most in unique formats, which served as principles for file structure analysis. Despite successful automatic recognition of over 95% of files, there are still situations requiring the user to interfere, mostly because of improper file structure or if the program cannot make up a conclusion on its structure. | The program is based on analyzing several hundreds of quote files, most in unique formats, which served as principles for file structure analysis. Despite successful automatic recognition of over 95% of files, there are still situations requiring the user to interfere, mostly because of improper file structure or if the program cannot make up a conclusion on its structure. | ||
<div style="background-color: #E3FBE5;">Note: For more information on known import limitations see [[ | <div style="background-color: #E3FBE5;">Note: For more information on known import limitations see [[#ASCII Import Limitations|ASCII Import Limitations]] section. Be careful when importing files.</div> | ||
<br> | |||
== How to import ASCII data == | |||
To import data: | To import data: | ||
# Select a symbol (see [[Operating_Symbol_List#Selecting Symbol(s) in Symbol List|Selecting Symbol(s) in Symbol list]] section). If the selected symbol contains quotes with the same timestamp as in the file, they'll be overwritten without warning. Make sure the symbol's price scale matches the price scale of the input data file. The program always uses the symbol's price scale when importing. | # Select a symbol (see [[Operating_Symbol_List#Selecting Symbol(s) in Symbol List|Selecting Symbol(s) in Symbol list]] section). If the selected symbol contains quotes with the same timestamp as in the file, they'll be overwritten without warning. Make sure the symbol's price scale matches the price scale of the input data file. The program always uses the symbol's price scale when importing. | ||
Line 40: | Line 41: | ||
# To select the time period for importing data set the '''Start Date/Start Date Time''' and '''End Date/End Date Time'''. | # To select the time period for importing data set the '''Start Date/Start Date Time''' and '''End Date/End Date Time'''. | ||
<br> | |||
== Invalid ASCII files == | == Invalid ASCII files == | ||
In most cases the invalid files are lacking the required fields, lacking data in some column, mixed up time and dates, irregular bar intervals. The program filters most faults and informs the user of them, but it is not possible in each and every case. Please see the analysis of typical invalid files below. | In most cases the invalid files are lacking the required fields, lacking data in some column, mixed up time and dates, irregular bar intervals. The program filters most faults and informs the user of them, but it is not possible in each and every case. Please see the analysis of typical invalid files below. | ||
<br> | |||
=== Invalid structure === | === Invalid structure === | ||
'''Example 1'''. Two of the four necessary bar components are missing: | '''Example 1'''. Two of the four necessary bar components are missing: | ||
<br> | <br> | ||
Line 55: | Line 59: | ||
1.2065, 1.2069, 1.2065, 1.2069<br> | 1.2065, 1.2069, 1.2065, 1.2069<br> | ||
1.2069, 1.2070, 1.2066, 1.2066<br> | 1.2069, 1.2070, 1.2066, 1.2066<br> | ||
<br> | <br> | ||
=== Incomplete data === | |||
'''Example 1'''. File has a damaged string: | '''Example 1'''. File has a damaged string: | ||
<br> | <br> | ||
Line 73: | Line 78: | ||
СС12-D,17/01/1995,3.47,3.5,3.38,3.41,0,7425600,-0.011461,,<br> | СС12-D,17/01/1995,3.47,3.5,3.38,3.41,0,7425600,-0.011461,,<br> | ||
СС12-D,18/01/1995,3.45,3.5,3.41,3.5,0,766400,0.002903,-3.518377,<br> | СС12-D,18/01/1995,3.45,3.5,3.41,3.5,0,766400,0.002903,-3.518377,<br> | ||
<br> | <br> | ||
=== Logical errors === | |||
'''Example 1'''. The file has a 60 minute interval, but with 1759 instead of 1800: | '''Example 1'''. The file has a 60 minute interval, but with 1759 instead of 1800: | ||
<br> | <br> | ||
Line 91: | Line 97: | ||
GBPUSD,19890627,1,0100,15485,B,N,N<br> | GBPUSD,19890627,1,0100,15485,B,N,N<br> | ||
GBPUSD,19890627,1,0100,15493,A,N,N<br> | GBPUSD,19890627,1,0100,15493,A,N,N<br> | ||
<br> | <br> | ||
== ASCII Import Limitations == | == ASCII Import Limitations == | ||
<div style="background-color: #F8F6CD;">Important: Local data storage saves the following resolution types: 1 Tick, 1 Minute, 1 Day. All other resolutions are sampled from those.</div> | <div style="background-color: #F8F6CD;">Important: Local data storage saves the following resolution types: 1 Tick, 1 Minute, 1 Day. All other resolutions are sampled from those.</div> |