|
PureBytes Links
Trading Reference Links
|
Hello,
You should change the definition to:
$SEPARATOR ,
$FORMAT Ticker,Date_MDY,Open,High,Low,Close,Volume
Best regards,
Tomasz Janeczko
amibroker.com
----- Original Message -----
From: "ronbo" <ronbo@xxxxxxxxxxxxxx>
To: <amibroker@xxxxxxxxxxxxxxx>
Sent: Monday, March 15, 2004 8:50 PM
Subject: [amibroker] I have a problem with Export .csv and Import Wizard
> I want to edit a quote file, so i used the Tool/Export, used either Excel or
> Notepad to edit 1 incorrect Low price, saved the file and used File/Import
> Wizard. The date format on Export is D/M/YYYY. When i Import i get this
> error:
>
> Logging started for 'C:\Program Files\AmiBroker\TIVO.csv' file, using format
> definition file 'Formats\wizard.format'
> Error in line TIVO,1/2/2003,5.29,5.47,5.11,5.35,438300
> Invalid date format/value
> Error in line TIVO,1/3/2003,5.39,5.68,5.17,5.65,571200
> Invalid date format/value
> Error in line TIVO,1/6/2003,5.7,6,5.64,5.93,863700
> Invalid date format/value
>
> I changed the Wizard.Format file to be the same date format as the Export
> (MDY) , AND the Define Fields window in the Wizard to be the M/D/Y format.
> Funny thing though, the sample of the file, has these lines at the top
> before the data:
> $SEPARATOR ,,,,,,
> $FORMAT Ticker,Date_YMD,Open,High,Low,Close,Volume
>
> i think it is not getting the correct Date format, no matter what i do.
>
> this is my wizard.format file:
> # Format definition file generated automatically
> # by AmiBroker's ASCII Import Wizard
> $FORMAT Ticker, Date_DMY, Open, High, Low, Close, Volume
> $SKIPLINES 0
> $SEPARATOR ,
> $CONT 1
> $GROUP 255
> $AUTOADD 1
> $DEBUG 1
>
> and i created an exact copy of the wizard.format file to csv.format. it
> made no difference.
>
>
> Virtually every day's data is in error.
>
> what am i doing wrong?? i know AB has a Quote Editor, which i use, but i
> thought this should work also...
>
> ron
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.619 / Virus Database: 398 - Release Date: 3/10/2004
>
>
>
> Send BUG REPORTS to bugs@xxxxxxxxxxxxx
> Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
> -----------------------------------------
> 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
> Yahoo! Groups Links
>
>
>
>
>
>
Send BUG REPORTS to bugs@xxxxxxxxxxxxx
Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
-----------------------------------------
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
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/amibroker/
<*> To unsubscribe from this group, send an email to:
amibroker-unsubscribe@xxxxxxxxxxxxxxx
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
|