|
PureBytes Links
Trading Reference Links
|
Hello,
One comment on this method - unfortunatelly it will produce incorrect results
if your database is not aligned and has data holes. The worst case
example is trying to run this code on ticker that has no quotes at all.
Becuase of the fact that Foreign will align data from other symbols
to data of current symbol, in mentioned worst case the code presented
will produce no output at all.
Much easier, faster method is just to use Exploration as described in the user's guide.
Filter = 1;
AddColumn(Open,"Open");
AddColumn(High,"High");
AddColumn(Low,"Low");
AddColumn(Close,"Close");
AddColumn(Volume,"Volume");
It guarantees that ALL quotes will be exported correctly.
Best regards,
Tomasz Janeczko
amibroker.com
----- Original Message -----
From: <uenal.mutlu@xxxxxxxxxxx>
To: <amibroker@xxxxxxxxxxxxxxx>
Sent: Saturday, May 17, 2003 4:41 AM
Subject: Re: [amibroker] converting amibroker quotes into ascii format
> The following is for exporting the last quotes
> of all tickers in a watchlist using the ABtool plugin.
> UM
>
> /* export the last quote of all tickers
> in a watchlist using ABtool plugin
>
> Run in AA Explore by first setting
> AppyTo=current stock,
> Range=n last quotes,
> and n=1
> */
> Filter = 1;
> AddColumn(C, "dummy");
>
> WL = 60; // set your watchlist# here
>
> filename = "LastQuotes.csv";
> fh = xxFileOpen(filename, "wt");
> ticker = xxWLtickerFirst(WL);
> while (ticker != "")
> {
> tO = foreign(ticker, "O");
> tH = foreign(ticker, "H");
> tL = foreign(ticker, "L");
> tC = foreign(ticker, "C");
> tV = foreign(ticker, "V");
> tI = foreign(ticker, "I");
> line = ticker + "," + tO + "," + tH + "," + tL
> + "," + tC + "," + tV + "," + tI + "\n";
> xxFileWriteStr(line, fh);
> ticker = xxWLtickerNext(WL);
> }
> xxFileClose(fh);
> xxMsgBox("See " + filename, "Finished");
>
>
> /* The result will look like this:
>
> ^NDX,1109.92,1137.45,1109.66,1136.51,0,0
> AAPL,14.46,14.59,14.34,14.45,5.75275e+006,0
> ADBE,36.24,38.14,36.15,37.92,5.78614e+006,0
> ADCT,2.37,2.52,2.36,2.5,6.16774e+006,0
> ALTR,15.79,16.56,15.7,16.51,1.10336e+007,0
> AMAT,14.95,15.31,14.79,15.15,2.7393e+007,0
> AMGN,62.27,63.62,62.01,63.27,9.42019e+006,0
> ...
>
> */
>
>
> ----- Original Message -----
> From: "alex14612" <alex14612@xxxxxxxxx>
> To: <amibroker@xxxxxxxxxxxxxxx>
> Sent: Saturday, May 17, 2003 4:12 AM
> Subject: [amibroker] converting amibroker quotes into ascii format
>
>
> > anyone know a free software or method to convert amibroker quotes
> > into ascii format without serious brain surgery involved ,i dont see
> > much on this subject ,
> >
> > thanks in advance
> > tibor
>
>
>
>
> 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
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Get A Free Psychic Reading! Your Online Answer To Life's Important Questions.
http://us.click.yahoo.com/Lj3uPC/Me7FAA/uetFAA/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
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
|