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
About ASCII importing and mapping issue
- Andrew MultiCharts
- Posts: 1587
- Joined: 11 Oct 2011
- Has thanked: 931 times
- Been thanked: 559 times
Re: About ASCII importing and mapping issue
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?
Re: About ASCII importing and mapping issue
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
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
Re: About ASCII importing and mapping issue
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!
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!
- Andrew MultiCharts
- Posts: 1587
- Joined: 11 Oct 2011
- Has thanked: 931 times
- Been thanked: 559 times
Re: About ASCII importing and mapping issue
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:
...
Example:
File1:
01.01.11 1234 1234 1234 1234 100 ...
31.01.11 4321 4321 4321 4321 200 ...
File2:
...
Re: About ASCII importing and mapping issue
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
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
- Andrew MultiCharts
- Posts: 1587
- Joined: 11 Oct 2011
- Has thanked: 931 times
- Been thanked: 559 times
Re: About ASCII importing and mapping issue
Would you be able to send me these 2 files (above) and the exported instrument from Quote Manager (.qmd) to ashuvlenov@multicharts.com?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
Re: About ASCII importing and mapping issue
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....
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....