[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [amibroker] converting amibroker quotes into ascii format



PureBytes Links

Trading Reference Links

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



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