About ASCII importing and mapping issue

I' ve got 60 csv file of the same symbol

The symbol is a futures which means a total of 60 months data.

No matter I use importing or mapping function. Both doesn't work.

When using The importing function, I imported the 60 files, and find that only the data of the first month could be shown.

(ps. I need the multi file importing function, it's really not user friendly...)

When using the mapping function, situation worsen, after the mapping process

Only one month of data show up....

Please help, thanks a lot

Please, provide some details. How did you add the instrument? What is the name of it? What type of data do you have in files? Was you import successful for all of 60 files?

thanks for your response!

i add the symbol in quote manager,

instrument -> add symbol -> manually

with the setting of

data source = ASCII mapping
symbol = HSI
category = Futures
exchange = HKFE

after create the symbol, i left click on the symbol, and use ctrl-i to import my 60 csv files seperately

i import for 60 times as there are 60 files, and all files have been imported successfully.

after that, i open new chart in MC and try to open the 60 months data,

and MC can only show data of 1 year only

as i want to figure out the problem, i import the 60 files the second time,

this time, i reload the chart once a csv file have been imported, and everything looks fine.

the chart show 5 year data correctly, so i reload the chart to confirm it, frustrating thing comes.

the 5 year chart no longer exist.... it turns to a 1 year chart again....

the tick data file consist of 6 type of data, as follow respectively...

symbol -- date -- time -- price -- volume -- transaction type
HSI 20061003 094401 17497 18 020
HSI 20061003 094401 17497 16 020
HSI 20061003 094401 17497 8 020
HSI 20061003 094401 17497 1 020
HSI 20061003 094401 17497 1 020
HSI 20061003 094401 17497 10 020
HSI 20061003 094401 17497 1 020
HSI 20061003 094401 17497 4 020
HSI 20061003 094401 17497 7 020
HSI 20061003 094401 17497 1 020

the transaction type is for personal reference only, and i leave it as undefined when i go through the import process.

all 60 files imported successfully without error

some more info about my import problem, i test one more time, try to import the data one by one,

and find that it crop out the data in a way that it just crop out the old data, and can only keep the newest 12 month data, so after i import the 60 files, only the newest 12 month(i.e.12 files) data can be kept in the database.

hope there would be some advise for me, thanks a lot!

Could you give examples of some (better all) of your first and last lines from your 60 files?

Example:

File1:
01.01.11 1234 1234 1234 1234 100 ...
31.01.11 4321 4321 4321 4321 200 ...
File2:
...

as shown below, thanks a lot!

2006-10
HSI,20061003,094401,17497,18,020
HSI,20061031,161458,18340,2,001

2006-11
HSI,20061101,094401,18332,1,020
HSI,20061130,161458,18998,1,001

2006-12
HSI,20061201,094400,18968,7,020
HSI,20061229,161459,20018,2,001

2007-01
HSI,20070102,094400,20088,2,020
HSI,20070131,161500,20155,1,001

2007-02
HSI,20070201,094403,20359,1,020
HSI,20070228,161459,19509,2,001

2007-03
HSI,20070301,094402,19443,2,020
HSI,20070330,161459,19879,1,001

2007-04
HSI,20070402,094402,19966,1,020
HSI,20070430,161459,20095,4,001

2007-05
HSI,20070502,094402,20200,1,020
HSI,20070531,161459,20693,1,001

2007-06
HSI,20070601,094402,20800,20,020
HSI,20070629,161458,21875,17,001

2007-07
HSI,20070703,094403,22051,63,020
HSI,20070731,161459,23219,1,001

2007-08
HSI,20070801,094402,22960,1,020
HSI,20070831,161459,23855,1,001

2007-09
HSI,20070903,094403,23791,1,020
HSI,20070928,161500,27182,2,001

2007-10
HSI,20071002,094403,27848,1,020
HSI,20071031,161459,31268,1,001

2007-11
HSI,20071101,094402,31691,1,020
HSI,20071130,161459,28880,1,001

2007-12
HSI,20071203,094401,29080,1,020
HSI,20071231,122959,27910,3,001

2008-01
HSI,20080102,094401,27720,1,020
HSI,20080131,161506,23494,1,001

2008-02
HSI,20080201,094401,23750,1,020
HSI,20080229,161459,24210,2,001

2008-03
HSI,20080303,094403,23215,1,020
HSI,20080331,161500,22630,4,001

2008-04
HSI,20080401,094402,23100,1,020
HSI,20080430,161459,25750,1,001

2008-05
HSI,20080502,094402,26501,1,020
HSI,20080530,163000,24459,10,001

2008-06
HSI,20080602,094401,24480,1,020
HSI,20080630,163000,22123,1,001

2008-07
HSI,20080702,094402,21720,1,020
HSI,20080731,162959,22775,8,001

2008-08
HSI,20080801,094402,22445,1,020
HSI,20080829,162959,21260,3,001

2008-09
HSI,20080901,094402,21000,1,020
HSI,20080930,162959,18082,1,001

2008-10
HSI,20081002,094402,18100,1,020
HSI,20081031,162959,13940,1,001

2008-11
HSI,20081103,094401,13875,1,020
HSI,20081128,162959,13988,1,001

2008-12
HSI,20081201,094401,13826,1,020
HSI,20081231,125959,14397,1,001

2009-01
HSI,20090102,094401,14397,1,020
HSI,20090130,162959,13214,1,001

2009-02
HSI,20090202,094402,13069,1,020
HSI,20090227,162959,12698,2,001

2009-03
HSI,20090302,094401,12300,1,020
HSI,20090331,161500,13556,3,001

2009-04
HSI,20090401,094402,13683,1,020
HSI,20090430,161459,15387,1,001

2009-05
HSI,20090504,094401,15511,1,020
HSI,20090529,161459,18150,1,001

2009-06
HSI,20090601,094401,18380,1,020
HSI,20090630,161459,18421,1,001

2009-07
HSI,20090702,094402,18649,1,020
HSI,20090731,161500,20363,1,001

2009-08
HSI,20090803,094401,20566,1,020
HSI,20090831,161459,19623,2,001

2009-09
HSI,20090901,094401,19751,1,020
HSI,20090930,161459,20895,1,001

2009-10
HSI,20091002,094403,20212,1,020
HSI,20091030,161500,21630,1,001

2009-11
HSI,20091102,094404,21132,1,020
HSI,20091130,161500,21748,1,001

2009-12
HSI,20091201,094401,21680,1,020
HSI,20091231,122959,21925,1,001

2010-01
HSI,20100104,094401,21850,1,020
HSI,20100129,161459,20203,1,001

2010-02
HSI,20100201,094402,19940,1,020
HSI,20100226,161459,20537,1,001

2010-03
HSI,20100301,094401,20761,1,020
HSI,20100331,161459,21235,1,001

2010-04
HSI,20100401,094402,21380,1,020
HSI,20100430,161459,20882,1,001

2010-05
HSI,20100503,094403,20488,1,020
HSI,20100531,161459,19713,1,001

2010-06
HSI,20100601,094403,19555,1,020
HSI,20100630,161459,20079,3,001

2010-07
HSI,20100702,094402,19981,1,020
HSI,20100730,161459,20975,1,001

2010-08
HSI,20100802,094401,21219,1,020
HSI,20100831,161458,20318,2,001

2010-09
HSI,20100901,094402,20463,1,020
HSI,20100930,161459,22332,1,001

2010-10
HSI,20101004,094401,22494,1,020
HSI,20101029,161500,22973,1,001

2010-11
HSI,20101101,094402,23250,1,020
HSI,20101130,161459,23028,1,001

2010-12
HSI,20101201,094401,22997,1,020
HSI,20101231,122959,23030,1,001

2011-01
HSI,20110103,094401,23180,1,020
HSI,20110131,161459,23372,1,001

2011-02
HSI,20110201,094401,23449,1,020
HSI,20110228,161458,23304,2,001

2011-03
HSI,20110301,094402,23300,1,020
HSI,20110331,161459,23520,1,001

2011-04
HSI,20110401,091402,23591,1,020
HSI,20110429,161459,23495,1,001

2011-05
HSI,20110503,091402,23600,1,020
HSI,20110531,161459,23550,1,001

2011-06
HSI,20110601,091401,23572,1,020
HSI,20110630,161500,22428,1,001

2011-07
HSI,20110704,091402,22900,1,020
HSI,20110729,161459,22330,1,001

2011-08
HSI,20110801,091402,22635,1,020
HSI,20110831,161459,20455,1,001

2011-09
HSI,20110901,091402,20600,1,020
HSI,20110930,161459,17423,1,001

2006-10
HSI,20061003,094401,17497,18,020
HSI,20061031,161458,18340,2,001

2006-11
HSI,20061101,094401,18332,1,020
HSI,20061130,161458,18998,1,001

Would you be able to send me these 2 files (above) and the exported instrument from Quote Manager (.qmd) to ashuvlenov@multicharts.com?

sure, file sent, thanks!

before investigating my case, let me show you more info about the issue.

i try to important data from Oct, 2006 to Mar, 2009, and the cropping data problem appear once,

and i do some more testing on it, i find that the data could be shown completely and flawless

with 5 min chart.

but for daily chart, weekly chart and monthly chart, various cropping problem appear, photo shown as follow...

Daily Chart


you can see that only data from Mar, 2008 - Mar, 2009 can be shown, which is one year of the latest data.

Weekly Chart


for weekly chart, the data cropped in a strange way...
the first bar is the week of 17/8/2007, the second bar is week of 21/3/2008,
the third bar is week of 4/7/2008, after that, its data from Aug, 2008 to Mar, 2009

Monthly Chart


the first bar is Aug, 2007, after that, it's data from Feb, 2008 to Mar, 2009
the data just mess up in a strange way....