Re: [amibroker] Amibroker to excel

 

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


.

__,_._,___

Related Posts


EmoticonEmoticon

:)
:(
=(
^_^
:D
=D
=)D
|o|
@@,
;)
:-bd
:-d
:p
:ng
:lv