You could export a .csv to Excel.
I fail to see the purpose of that cause AB can do your studies.
Anyway, this is a code made by Fxshrat, meant to be used as an exploration (Analysis windows).
//
// Choose Save as .csv
//
if ( Status( "actionex" ) == actionExplore )
{
format = 1.6;
width = 60;
Colfont = colorblack;
Colcell = colorwhite;
SetOption( "NoDefaultColumns", True );
SetSortColumns( 1 );
AddTextColumn( Name(), "Ticker", 1.0, Colfont, Colcell, width );
// AddTextColumn( FullName(), "FullName", format, Colfont, Colcell);
AddColumn( DateTime(), "Date/Time", formatDateTime, Colfont, Colcell, 120 );
AddColumn( O, "Open", format, Colfont, Colcell, width );
AddColumn( H, "High", format, Colfont, Colcell, width );
AddColumn( L, "Low", format, Colfont, Colcell, width );
AddColumn( C, "Close", format, Colfont, Colcell, width );
AddColumn( V, "Volume", 1, Colfont, Colcell, width );
AddColumn( OI, "OI", 1, Colfont, Colcell, width );
/*
AddTextColumn( GetFnData("Alias"), "Alias", 1, Colfont, Colcell );
AddTextColumn( GetFnData("Country"), "Country", 1, Colfont, Colcell );
AddTextColumn( GetFnData("Currency"), "Currency", 1, Colfont, Colcell );
AddTextColumn( SectorID(1), "Sector", 1, Colfont, Colcell );
AddTextColumn( IndustryID(1), "Industry", 1, Colfont, Colcell );
AddColumn( MarketID(), "MarketID", 1, Colfont, Colcell );
AddColumn( GroupID(), "GroupID", 1, Colfont, Colcell );
AddColumn( Ticksize, "Ticksize", 1.4, Colfont, Colcell );
AddColumn( Roundlotsize, "RoundLotsize", 1, Colfont, Colcell );
AddColumn( MarginDeposit, "MarginDeposit", 1, Colfont, Colcell );
AddColumn( PointValue, "Pointvalue", 1.1, Colfont, Colcell );
*/
Filter = Volume > 0; // 1; // Status( "lastbarinrange" ); etc...
}
2016-04-15 12:19 GMT-03:00 jeremy_c_perater@yahoo.com.ph [amibroker] <amibroker@yahoogroups.com>:
Hi,
Does anybody know what's the best way to export dat from amibroker to excel? I wanted to make an excel file which gets data from amibroker (such as volume,high,open,low,close etc) when I input the stock symbol in excel and then program excel to create graphs, volume buzzes, etc.
Agradeço antecipadamente,
----------------------------------------------------------
João Flávio Machado Derzi
+55 (31) 9 9731-4469
__._,_.___
Posted by: =?UTF-8?Q?Jo=C3=A3o_Fl=C3=A1vio_Machado_Derzi?= <joaoderzi@gmail.com>
Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
**** IMPORTANT PLEASE READ ****
This group is for the discussion between users only.
This is *NOT* technical support channel.
TO GET TECHNICAL SUPPORT send an e-mail directly to
SUPPORT {at} amibroker.com
TO SUBMIT SUGGESTIONS please use FEEDBACK CENTER at
http://www.amibroker.com/feedback/
(submissions sent via other channels won't be considered)
For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/
This group is for the discussion between users only.
This is *NOT* technical support channel.
TO GET TECHNICAL SUPPORT send an e-mail directly to
SUPPORT {at} amibroker.com
TO SUBMIT SUGGESTIONS please use FEEDBACK CENTER at
http://www.amibroker.com/feedback/
(submissions sent via other channels won't be considered)
For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/
.
__,_._,___
EmoticonEmoticon