[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 More issues!



PureBytes Links

Trading Reference Links

sorry did not look closely anough at the data you were trying to import
another problem can be that I do not believe AB recognises PM and AM times, they need to be in 24 hour clock
so ,5:00:00 PM, should be ,17:00:00,

--
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:
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
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

__,_._,___