How yo import the excel data to amibroker?

YA YA

Newbie
Messages
1
Likes
0
(1)Import Wizard
(2)Pick file - > Next
(3) Skip, Time, High , Low , volume, Ticker

Fail to import the data.
Please help me.:(

,09:14:00,23498,23498,23498,313,313,
,09:15:00,23498,23498,23498,314,1,
,09:15:00,23507,23498,23502,410,96,
,09:15:01,23507,23498,23498,492,82,
,09:15:02,23507,23496,23497,528,36,
,09:15:03,23507,23484,23489,571,43,
,09:15:04,23507,23484,23491,601,30,
 
(1)Import Wizard
(2)Pick file - > Next
(3) Skip, Time, High , Low , volume, Ticker

Fail to import the data.
Please help me.:(

,09:14:00,23498,23498,23498,313,313,
,09:15:00,23498,23498,23498,314,1,
,09:15:00,23507,23498,23502,410,96,
,09:15:01,23507,23498,23498,492,82,
,09:15:02,23507,23496,23497,528,36,
,09:15:03,23507,23484,23489,571,43,
,09:15:04,23507,23484,23491,601,30,

If you are correct in point (3) your data columns do not match.

I would expect something like ,09:14:00, 100.41, 100.38, 5000, IBM.
.it looks like you have an extra column in your data and nothing resembling a stock or currency symbol.

The figures for high, low and volume are not real figures by the way, just examples. Also you need to check exactly how times are meant to be input. Is it with colons or just the number for example. Generally the user manual/technical manual will include a sample of a few lines that will show the syntax.

I think if you send a few lines of your sample file to am I broker support or go to their user forum, they will be able to assist.
 
Last edited:
Top