ASX sector ID

This topic is empty.

Viewing 3 posts - 1 through 3 (of 3 total)

Author

Posts
March 12, 2017 at 5:20 am #101622

LeeDanello
Participant

I’ve coded something up to find the sector of a particular stock for further testing on a MR system. I’m not sure how correct it is, but would appreciate some feedback if someone else has gone down this road and come up with more elegant code.

Code:

_SECTION_BEGIN(“Sector ID”);
if (SectorID(1) ==”Energy”) SectorIndex = Foreign(“$XEJ.au”,”C”);
else if (SectorID(1)==”Basic Materials”) SectorIndex = Foreign(“$XMJ.au”,”C”);
else if (SectorID(1)==”Industrials”) SectorIndex = Foreign(“$XNJ.au”,”C”);
else if (SectorID(1)==”Consumer Discretionary”) SectorIndex = Foreign(“XDJ”,”C”);
else if (SectorID(1)==”Consumer Staples”) SectorIndex = Foreign(“$XSJ.au”,”C”);
else if (SectorID(1)==”Health Care”) SectorIndex = Foreign(“$XHJ.au”,”C”);
else if (SectorID(1)==”Financials”) SectorIndex = Foreign(“$XFJ.au”,”C”);
else if (SectorID(1)==”Information Technology”) SectorIndex = Foreign(“$XIJ.au”,”C”);
else if (SectorID(1)==”Telecommunication Services”) SectorIndex = Foreign(“$XTJ.au”,”C”);
else if (SectorID(1)==”Technology”) SectorIndex = Foreign(“$XTJ.au”,”C”);
else if (SectorID(1)==”Utilities”) SectorIndex = Foreign(“$XUJ.au”,”C”);
else if (SectorID(1)==”Real Estate”) SectorIndex = Foreign(“$XRJ.au”,”C”);
else if (SectorID(1)==”Unassigned or n/a”) SectorIndex = Foreign(“$XAO.au”,”C”);
else if (SectorID(1)==”Consumer Cyclicals”) SectorIndex = Foreign(“$XDJ.au”,”C”);
else if (SectorID(1)==”Consumer non-Cyclicals”) SectorIndex = Foreign(“$XDJ.au”,”C”);
_SECTION_END();

I find the Amibroker documentation as clear as mud sometimes.

March 12, 2017 at 10:42 am #106378

SaidBitar
Member

Code:

SectorIndexUS = IIf(InGics(“10”),Foreign(“$SPXE”,”C”),
IIf(InGics(“15”),Foreign(“$SPXM”,”C”),
IIf(InGics(“20”),Foreign(“$SPXI”,”C”),
IIf(InGics(“25”),Foreign(“$SPXD”,”C”),
IIf(InGics(“30”),Foreign(“$SPXS”,”C”),
IIf(InGics(“35”),Foreign(“$SPXA”,”C”),
IIf(InGics(“40”),Foreign(“$SPXF”,”C”),
IIf(InGics(“45”),Foreign(“$SPXT”,”C”),
IIf(InGics(“50”),Foreign(“$SPXL”,”C”),
IIf(InGics(“55”),Foreign(“$SPXU”,”C”),Foreign(“$SPXR”,”C”)))))))))));
SectorIndexAUS = IIf(InGics(“10”),Foreign(“$XEJ.au”,”C”),
IIf(InGics(“15”),Foreign(“$XMJ.au”,”C”),
IIf(InGics(“20”),Foreign(“$XNJ.au”,”C”),
IIf(InGics(“25”),Foreign(“$XDJ.au”,”C”),
IIf(InGics(“30”),Foreign(“$XSJ.au”,”C”),
IIf(InGics(“35”),Foreign(“$XHJ.au”,”C”),
IIf(InGics(“40”),Foreign(“$XFJ.au”,”C”),
IIf(InGics(“45”),Foreign(“$XIJ.au”,”C”),
IIf(InGics(“50”),Foreign(“$XTJ.au”,”C”),
IIf(InGics(“55”),Foreign(“$XUJ.au”,”C”),Foreign(“$XPJ.au”,”C”)))))))))));

March 12, 2017 at 11:34 am #106381

LeeDanello
Participant

Thanks Said. You make it look easy
Author

Posts

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.

What We Offer

Resources

Members

The Chartist