[amibroker] Referencing composite values in an Exploration

[tiger_energy]

Hello,

Can anyone suggest a way to reference this code in an exploration
using the addcolumn function? I'd like to be able
to reference the sector and industry data to see the advances,
declines and unchanged values for export from exploration to excel.

thanks
Anthony


Buy = 0; // required for scan
YestClose = Ref( Close, -1 );
Advanced = Close > YestClose;
Declined = Close < YestClose;
Unchanged = Close == YestClose;
Industry = GetBaseIndex();
Sector = StrLeft( Industry, 4 ) + "0";
Market = MarketID( 1 );
AddToComposite( Advanced, "~I " + Industry + " U" + " Adv", "H" );
AddToComposite( Declined, "~I " + Industry + " U" + " Dec", "L" );
AddToComposite( Unchanged, "~I " + Industry + " U" + " Unc", "O" );
AddToComposite( Advanced, "~S " + Sector + " U" + " Adv", "H" );
AddToComposite( Declined, "~S " + Sector + " U" + " Dec", "L" );
AddToComposite( Unchanged, "~S " + Sector + " U" + " Unc", "O" );
AddToComposite( Advanced, "~M " + Market + " U" + " Adv", "H" );
AddToComposite( Declined, "~M " + Market + " U" + " Dec", "L" );
AddToComposite( Unchanged, "~M " + Market + " U" + " Unc", "O" );