[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[amibroker] Re: Importing Intraday data



PureBytes Links

Trading Reference Links

Graham,

I imported the following format succesfully.

AEX,20021216,09:07,321.99,322.25,321.99,322.19
AEX,20021216,09:08,322.12,322.12,321.95,322.11
AEX,20021216,09:09,322.01,322.25,322.01,322.12


Don't forget to adjust the database settings to the Base time 
interval corresponding with your data.

File-Database Settings-Base time interval: 5 minute.


good luck,

Frans.

--- In amibroker@xxxxxxxxxxxxxxx, "Graham" <gkavanag@xxxx> wrote:
> I have vreated a spreadsheet to compress the raw intraday history 
data I
> have into 5 minute time spans giving OHLCV for each 5 minutes.
> 
> However I have yet to work out what format the date/time should be 
in to
> get the import to work, I have tried all sorts of formats, but 
notdata
> imports, and in the quote editor it shows Invalid Date_time in the 
first
> (and only) data line which is the last line in the text file.
> 
> Here is the latest data in csv I created, can someone advise me 
what I
> should do to get it to work
> 
> test,20030128,10:00:00 AM,1.37,1.37,1.37,1.37,0
> 
> test,20030128,10:05:00 AM,1.37,1.37,1.37,1.37,0
> 
> test,20030128,10:10:00 AM,1.37,1.37,1.37,1.37,4103
> 
> test,20030128,10:15:00 AM,1.37,1.37,1.37,1.37,2356
> 
> test,20030128,10:20:00 AM,1.37,1.37,1.36,1.37,21933
> 
>  
> 
> Cheers,
> Graham


Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx 
(Web page: http://groups.yahoo.com/group/amiquote/messages/)

Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/