How yo import the excel data to amibroker?

This is a discussion on How yo import the excel data to amibroker? within the Trading Software forums, part of the Commercial category; (1)Import Wizard (2)Pick file - > Next (3) Skip, Time, High , Low , volume, Ticker Fail to import the ...

Reply
 
LinkBack Thread Tools Search this Thread
Old Mar 14, 2017, 1:09pm   #1
 
1 Posts
Joined Mar 2017
How yo import the excel data to amibroker?

(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,
YA YA is offline   Reply With Quote
Old Mar 17, 2017, 6:44pm   #2
Joined Nov 2006
Obviously your Date column is missing!
fxtr is offline   Reply With Quote
Old Mar 20, 2017, 4:29pm   #3
 
Charlton's Avatar
Joined Nov 2003
Quote:
Originally Posted by YA YA View Post
(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.
__________________
Onwards and Upwards

Last edited by Charlton; Mar 20, 2017 at 4:32pm. Reason: Clarification
Charlton is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Similar Threads
Thread Thread Starter Forum Replies Last Post
TS2000i - No data available for the selected data range !! after import manichauhan Trading Software 10 Jan 30, 2015 3:12pm
AMIBROKER historical Futures data import error sadzic Trading Software 1 Feb 2, 2013 3:36am
** Import Live Forex data into Excel ** TOPMONKEY Trading Software 2 Jun 30, 2011 9:01pm
Amibroker intraday CSV import mdiamant Trading Software 2 Dec 30, 2010 11:01am
Using Excel to Import Data? The Oz Trading Software 0 Sep 1, 2010 5:04pm

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)