General Site Issues : Help on database structure (IEOD) for importing into Amibroker

[fjl24]

Ticket ID: DTM24

Priority: Low

Dear Prashanth\r\n\r\nDid subscribe to the yahoo group as recommended by you.\r\n\r\nReceived instructions on setting up the import wizard for EOD data in Amibroker.\r\n\r\nDid not understand the instructions given for File->Import Metastock Data - I presume this is not relevant to me.\r\n\r\nBut i did follow the instructions given for File->Import Wizard\r\n\r\nAs there is no instructions for setting up the import wizard for IEOD data would request you to kindly let me know the same (more from database structure point of view).\r\n\r\nFrom what i could interpret it is:\r\n\r\nTicker, MDY, Time, Open, High, Low, Close & Volume\r\n\r\nKindly correct me if i am wrong.\r\n\r\nAlso, this data is in text format unlike the csv format for EOD data - can i follow the same routine for the import wizard in Amibroker as done for EOD data.\r\n\r\nThanks in advance\r\nRegards\r\nFloyd

[Prashanth]

Ticket ID: DTM24

Priority: Low

Dear Prashanth\r\n\r\nDid subscribe to the yahoo group as recommended by you.\r\n\r\nReceived instructions on setting up the import wizard for EOD data in Amibroker.\r\n\r\nDid not understand the instructions given for File->Import Metastock Data - I presume this is not relevant to me.\r\n\r\nBut i did follow the instructions given for File->Import Wizard\r\n\r\nAs there is no instructions for setting up the import wizard for IEOD data would request you to kindly let me know the same (more from database structure point of view).\r\n\r\nFrom what i could interpret it is:\r\n\r\nTicker, MDY, Time, Open, High, Low, Close & Volume\r\n\r\nKindly correct me if i am wrong.\r\n\r\nAlso, this data is in text format unlike the csv format for EOD data - can i follow the same routine for the import wizard in Amibroker as done for EOD data.\r\n\r\nThanks in advance\r\nRegards\r\nFloyd

Following is the format for IEOD Data.

# Format definition file generated automatically
# by AmiBroker's ASCII Import Wizard
$FORMAT Ticker, Date_MDY, Time, Open, High, Low, Close, Volume
$SKIPLINES 0
$SEPARATOR ,
$CONT 1
$GROUP 255
$AUTOADD 1
$DEBUG 1
$NOQUOTES 1
$ALLOWNEG 0

You may get Errors since sometimes, our Future data contains lines with only -999.99. Just ignore the error since rest of the data will be correctly imported.

[fjl24]

Following is the format for IEOD Data.

# Format definition file generated automatically
# by AmiBroker's ASCII Import Wizard
$FORMAT Ticker, Date_MDY, Time, Open, High, Low, Close, Volume
$SKIPLINES 0
$SEPARATOR ,
$CONT 1
$GROUP 255
$AUTOADD 1
$DEBUG 1
$NOQUOTES 1
$ALLOWNEG 0

You may get Errors since sometimes, our Future data contains lines with only -999.99. Just ignore the error since rest of the data will be correctly imported.


Dear Prashanth

Just some clarifications based on your post above. Just confirming as not have too much of a programming background.


Did you mean by Date_MDY = MDY (In Amibroker)

Did you mean by value 1 = checked and 0 = unchecked in define fields

what does $CONT 1 refer to in Amibroker - Where should i incorporate this

what does $DEBUG 1 refer to in Amibroker - Where should i incorporate this

I presume the calculate composites field be left blank i.e. 0

Thanks in advance
Regards
Floyd:):):)