PureBytes Links
Trading Reference Links
|
Thanks for the replies--
Before i do an Import, my Wizard.Format, and Default.Format files now looks
like this, as Tomasz suggested:
$SEPARATOR ,
$FORMAT Ticker,Date_MDY,Open,High,Low,Close,Volume
The first couple of lines on the Import Wizard Define Fields, Data File
Sample looks like this:
$SEPARATOR ,,,,,,
$FORMAT Ticker,Date_YMD,Open,High,Low,Close,Volume
TIVO,1/2/2003,5.29,5.47,5.11,5.35,438300
TIVO,1/3/2003,5.39,5.68,5.17,5.65,571200
TIVO,1/6/2003,5.7,6,5.64,5.93,863700
I must change the Column 2 format to be MDY, it always comes up YMD.
I still get the same errors:
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
AND the Wizard.Format file is now changed by AB to:
# Format definition file generated automatically
# by AmiBroker's ASCII Import Wizard
$FORMAT Ticker, Date_MDY, Open, High, Low, Close, Volume
$SKIPLINES 0
$SEPARATOR ,
$CONT 1
$GROUP 255
$AUTOADD 1
$DEBUG 1
Is there something in a setup menu somewhere i did not set up correctly???
Salil, thanks for the offer, but i don't think there is anything wrong with
my quote file. i have NEVER had a problem with downloading data from Yahoo,
except some stocks/Index like ^DJI has no history available for the last
couple of days... the file i am using is a file which AB generated via the
Tools/Export. this should insure complete compatibility.
ron
-----Original Message-----
From: Tomasz Janeczko [mailto:amibroker@xxxxxx]
Sent: Monday, March 15, 2004 1:44 PM
To: amibroker@xxxxxxxxxxxxxxx
Subject: Re: [amibroker] I have a problem with Export .csv and Import Wizard
Hello,
You should change the definition to:
$SEPARATOR ,
$FORMAT Ticker,Date_MDY,Open,High,Low,Close,Volume
Best regards,
Tomasz Janeczko
amibroker.com
snip
---
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
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Buy Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark
Printer at MyInks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/GHeqlB/TM
---------------------------------------------------------------------~->
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/
|