Hi Mike, Many thanks for your suggestions. I made the changes and it worked out great.
best regards Anthony --- In [email protected], "Mike" <[EMAIL PROTECTED]> wrote: > > After running your initial scan, you could run a separate exploration > to output the values calculated during the scan. > > First, if there's no particular reason for specifically storing your > composite values separately in "H", "L", "O", then change your code > to store the value in all fields (i.e. "X"), else always in the same > field (e.g. "C"). It does not appear that you are using any more than > a single field for any of these composites. Always using the same > field makes the exploration easier. > > e.g. change: > > AddToComposite( Advanced, "~I " + Industry + " U" + " Adv", "H" ); > > to: > > AddToComposite( Advanced, "~I " + Industry + " U" + " Adv", "X" ); > > Then run an exploration like the following, with a filter set to > Market 253 (i.e. composites): > > Buy = 0; > > Prefix = StrLeft(Name(), 2); > Suffix = StrRight(Name(), 6); > > switch (Prefix) { > case "~I": > case "~S": > case "~M": > PrefixMatch = True; > break; > > default: > PrefixMatch = False; > } > > switch (Suffix) { > case " U Adv": > case " U Dec": > case " U Unc": > SuffixMatch = True; > break; > > default: > SuffixMatch = False; > } > > Filter = (PrefixMatch && SuffixMatch); > AddColumn(Close, "Count"); > > Mike > > --- In [email protected], "tiger_energy" <kuantau@> wrote: > > > > 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" ); > > >
