|
PureBytes Links
Trading Reference Links
|
Graham, Please send me the format file you are using to perform this task. Thanks, Bill PS=> Thomasz, The Export didn't actually work correctly. I changed the Perridocity to In1Minute, but the Explorer put the same High, Low, Close, etc. in every minute record for the day. Here's an example: EURCHF,11/5/2006 5:00:00 PM,1.59,1.59,1.59,1.59,0,0
EURCHF,11/5/2006 5:03:00 PM,1.59,1.59,1.59,1.59,0,0 =================================================== you need to use an format file for intraday importing that contains the time
Why not run the import wizard and create your own -- Cheers Graham AB-Write >< Professional AFL Writing Service Yes, I write AFL code to your requirements http://www.aflwriting.com
On 13/03/07, Bill Halliday <halliday_mo@xxx> wrote:
Hi Thomasz,
I followed the instructions on the link you provided and got a report.
It worked once I re-read the instructions carefully and changed the Settings Peridocity to in1Minute!
The data in the .csv file looks fine. However, I got this error message when trying an IMPORT:
Logging started for 'C:\Program Files\AmiBroker\ForexIntraday\Pre-March 2007 Intraday data.csv' file, using format definition file 'Formats\default.format'
Error in line EURCHF,11/5/2006 5:00:00 PM,1.59,1.59,1.59,1.59,0,0
Invalid date format/value
I haven't changed the DEFAULT.FORMAT file:
$FORMAT Date_DMY,Open,High,Low,Close,Volume
$SKIPLINES 1
$SEPARATOR ,
$DEBUG 1
$BREAKONERR 1
$AUTOADD 1
I also tried the Import wizard, with the same
results:
Error in line EURCHF,11/5/2006 5:00:00 PM,1.59,1.59,1.59,1.59,0,0
Invalid date format/value.
This is the format file I used with the Wizard:
# Format definition file generated automatically
# by AmiBroker's ASCII Import Wizard
$FORMAT Ticker, Date_YMD, Open, High, Low, Close, Volume
$SKIPLINES 0
$SEPARATOR ,
$CONT 1
$GROUP 255
$AUTOADD 1
$DEBUG 1
Do I need to re-format the date/time in the database,if not, how do I tell the Importer that the time is in the input line?
Bill
Sucker-punch spam with award-winning protection.
Try the free Yahoo! Mail Beta.
__._,_.___
Please note that this group is for discussion between users only.
To get support from AmiBroker please send an e-mail directly to
SUPPORT {at} amibroker.com
For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/
For other support material please check also:
http://www.amibroker.com/support.html
![]()
SPONSORED LINKS
__,_._,___
|