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

Re: [amibroker] The Time is off in my Forex Intraday data! - ATTN: Thomasz Thank You!



PureBytes Links

Trading Reference Links

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@xxxxxxxxx> 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


Get your own web address.
Have a HUGE year through Yahoo! Small Business.




__._,_.___

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
Investment management software Investment property software Investment software
Investment tracking software Return on investment software

Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___