|
PureBytes Links
Trading Reference Links
|
I have tried every combination of formats but I can not get the
ascii importer to accept a date in this format, yyyymmdd. How do you
import this date format?
What I have tried so far:
There seemed to be an example of this in Help and I tried it but it
did not work either:
>> start of excerpt from help text
Omega SuperCharts ASCII
The data in Omega SC ASCII format looks as follows:
ticker,date,open,high,low,close,vol
AAP,20000117,5333.01,5483.33,5332.01,5362.3,3433450
This format is similar to previous ones, however the date is in
YYYYMMDD format without separators between year, month and day part.
AmiBroker, however, can handle such dates with ease. Appropriate
format definition file would look like this:
$FORMAT Name,Date_Int,Open,High,Low,Close,Volume
$SEPARATOR ,
$DEBUG 1
$SKIPLINES 1
$AUTOADD 1
$BREAKONERR 1
<< end of help excerpt
The above example shows a date of 20000117 and they use a date
format of Date_int. I tried that and got an error. I am using
quattro pro to create the data and put it in a comma delimited txt
file.
The following are in cell 1 only of the quattro file. I have tried
using separate cells since saving puts a comma in the text line but
that made no difference.
The formats I have tried are:
1st. ticker,date,volume,openint,open,high,low,close,vol
2nd. $format name,date_int,volume,openint,open,high,low,close
The 2nd format I tried also uses $allowneg and $debug in the first
three lines in quattro pro as follows:
Cell a1 = $format name,date_int,volume,openint,open,high,low,close
Cell a2 = $ALLOWNEG 1
Cell a3 = $DEBUG 1
Cell a4-h4 = ~CumAD,19800102,442,1148,-706,-706,-706,-706
This does not work either. But, the only error is the date format.
Where do I go from here? I can write a c program to reformat the
data and that is what I will do if AB can not import this date
format.
So, can I import this date format into AB? If si, how?
Barry
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 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
---------------------------------------------------------------------~->
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/
|