|
PureBytes Links
Trading Reference Links
|
Hello,
Exporting to CSV is very easy and described in the user's guide.
As written in the User's Guide: Tutorial: How to create your own exploration:
Example 2:
List all OHLCV of all symbols:
Filter = 1;
AddColumn(Open,"Open");
AddColumn(High,"High");
AddColumn(Low,"Low");
AddColumn(Close,"Close");
AddColumn(Volume,"Volume");
Click on "Explore"
Now you can click "Export" and your exploration will be saved to CSV (comma separated values) file that could be easily loaded to
any other program including Excel for further analysis.
Best regards,
Tomasz Janeczko
amibroker.com
----- Original Message -----
From: "DIMITRIS TSOKAKIS" <TSOKAKIS@xxxxxxxxx>
To: <amibroker@xxxxxxxxxxxxxxx>
Sent: Saturday, May 17, 2003 8:48 AM
Subject: [amibroker] Re: converting amibroker quotes into ascii format
> UM,
> Do you really consider this "simple" way to export data in ASCII
> format ?
> In other words, an average amibroker user needs to
> a. use a 3rd party plugin
> b. use a while loop
> c. move his tickers to a WL
> d. save somewhere this code you suggest
> e. read all tickers as "foreign"
> and all this stuff in order to have an ASCII csv file without dates ?
> [Perhaps he will need another code to insert dates and if, like
> myself, he does not understand your magnificent code ask for help
> again and again...]
> There is no reason to rediscover America, Colombus & co did the job
> many years ago.
> On the other side, amibroker would be quite miserable if it could not
> export data before while looping+ABtool+so complicated coding. And it
> isnt, as far as I know.
> Is this the tool you want to certify, as I read somewhere else ?
> Will you also certify this kind of "logic" to solve a problem like
> exporting data in ASCII format ?
> If positive, I have lost the measure of common understanding.
> Dimitris Tsokakis
> PS Impressionism was not always the best trend in arts evolution, IMHO
>
> --- In amibroker@xxxxxxxxxxxxxxx, uenal.mutlu@xxxx wrote:
> > 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@xxxx>
> > 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/
|