gicsID(0) but for two digits

yonsi72 · May 17, 2024, 10:09am

Hello, how are you?

I'm trying to make an indicator to calculate the Mansfield RSC of the GICS Sector of the shares (then I will try it for the Industrial Groups, the Industries and finally the Sub-Industries). I use the Norgate Data database (the trial version).

This is the code I have been able to do so far and it doesn't work (it doesn't draw anything):

// [...] Inicio modulo de calculo del RSC Mansfield del Sector GICS del valor

_SECTION_BEGIN("RSC Mansfield Sector GICS");

// Buscamos el Sector GICS y utilizaremos Índices para representarlo

switch (gicsID(0))
{
case"10":sector="$IXE"; break;//Sector GICS Energy
case"15":sector="$IXB"; break;//Sector GICS Materials
case"20":sector="$SPXI"; break;//Sector GICS Industrials
case"25":sector="$IXY"; break;//Sector GICS Consumer Discretionary
case"30":sector="$IXR"; break;//Sector GICS Consumer Staples
case"35":sector="$IXV"; break;//Sector GICS Health Care
case"40":sector="$SPXF"; break;//Sector GICS Financials
case"45":sector="$SPXT"; break;//Sector GICS Information Technology
case"50":sector="$IXCPR"; break;//Sector GICS Communication Services
case"55":sector="$IXU"; break;//Sector GICS Utilities
case"60":sector="$IXRE"; break;//Sector GICS Real Estate

//Cuando no haya sector GICS tomará el índice S&P500
default:sector = "$SPX";
} 

SetForeign(sector);//sintonizamos el Sector GICS al que pertenece el actual valor 

// RSC Mansfield del Sector GICS
period = Param("Periodo", 52, 1, 500, 1);
rsSymbol = ParamStr( "Base Index Symbol", "$SPX" );

//Comienza el calculo del RSC Mansfield del Sector GICS 
Cociente = C / Foreign(rsSymbol, "C"); //Comparamos el precio Cierre del activo con respecto al precio Cierre del S&P500 
CountR = Sum(Cociente,period); //Acumulamos los cocientes de las últimas 52 semanas
Baseprice = CountR/period; //Media de los cocientes
RSC = ((Cociente / Baseprice ) - 1)*10; //Comparamos el cociente actual con respecto a su media

RestorePriceArrays(); // volvemos al actual valor


// [...] Fin modulo de calculo del RSC Mansfield del Sector GICS del valor

//mostramos en pantalla la variable RSC que contiene el RSC de Mansfield de Sector GICS

//escogemos la forma de representacion y estilos
SetGradientFill(colorGreen/*top*/,colorRed/*bottom*/,0/*baseline level*/,GetChartBkColor()/*baseline color*/);

//mostramos en pantalla la variable RSC que contiene el RSC de Mansfield
Plot(RSC, "RSC Sector GICS"+ "-" + GicsID(2)+ " vs S&P500", colorBrown, styleLine | styleGradient);

_SECTION_END();

Something I've noticed so far is that the gicsID(0) gets the 8 digit code from the actions and then case "10" has two digits and since they don't match, it doesn't matter.

How can I make the gicsID(0) only take the first two digits of the GICS code of the actions?

Thank you so much

beppe · May 17, 2024, 10:34am

@yonsi72 gicsID(0) (see the documentation) returns a string.

So you can simply use the StrLeft() function to get the first 2 chars.

Amibroker has a good number of functions to work with strings: please, take a look at the section named String manipulation in this page that lists all the AB function by category (scroll 3/4 down).

yonsi72 · May 17, 2024, 11:10am

Thank you very much beppe,

I have been able to solve it with this:
switch (StrLeft(gicsID(0),2))

Now I'm trying to get the GICS level 1 name instead of level 4 and for the RSC Mansfield values to only have 2 digits.

Any help?

Thanks a lot

TrendSurfer · May 17, 2024, 11:36am

See document @beppe advised.

GraphLabelDecimals = 2;

yonsi72 · May 17, 2024, 11:44am

Thank you very much TrendSurfer,

I think I have finally achieved what I was looking for, being able to see the Mansfield RSC of the value and its GICS Sector.

I am very happy, every step with AmiBroker is important!

I attach the code for RSC Mansfield for Sector in case someone wants to tell me how to optimize it.

/ [...] Inicio modulo de calculo del RSC Mansfield del Sector GICS del valor

_SECTION_BEGIN("RSC Mansfield Sector GICS");

// Buscamos el Sector GICS y utilizaremos Índices para representarlo

gics = GicsID( 0 );

level1 = StrToNum( StrLeft( gics, 2 ) );
level2 = StrToNum( StrLeft( gics, 4 ) );
level3 = StrToNum( StrLeft( gics, 6 ) );

//printf("Level 1 %s\n", CategoryGetName( categoryGICS, level1 ) );
//printf("Level 2 %s\n", CategoryGetName( categoryGICS, level2 ) );
//printf("Level 3 %s\n", CategoryGetName( categoryGICS, level3 ) );
//printf("Level 4 %s\n", GicsID( 1 ) );


switch (StrLeft(gicsID(0),2))


{
case"10":sector="$IXE"; break;//Sector GICS Energy
case"15":sector="$IXB"; break;//Sector GICS Materials
case"20":sector="$SPXI"; break;//Sector GICS Industrials
case"25":sector="$IXY"; break;//Sector GICS Consumer Discretionary
case"30":sector="$IXR"; break;//Sector GICS Consumer Staples
case"35":sector="$IXV"; break;//Sector GICS Health Care
case"40":sector="$SPXF"; break;//Sector GICS Financials
case"45":sector="$SPXT"; break;//Sector GICS Information Technology
case"50":sector="$IXCPR"; break;//Sector GICS Communication Services
case"55":sector="$IXU"; break;//Sector GICS Utilities
case"60":sector="$IXRE"; break;//Sector GICS Real Estate

//Cuando no haya sector GICS tomará el índice S&P500
default:sector = "$SPX"; break;
} 

SetForeign(sector);//sintonizamos el Sector GICS al que pertenece el actual valor 

// RSC Mansfield del Sector GICS
period = Param("Periodo", 52, 1, 500, 1);
rsSymbol = ParamStr( "Base Index Symbol", "$SPX" );

//Comienza el calculo del RSC Mansfield del Sector GICS 
Cociente = C / Foreign(rsSymbol, "C"); //Comparamos el precio Cierre del activo con respecto al precio Cierre del S&P500 
CountR = Sum(Cociente,period); //Acumulamos los cocientes de las últimas 52 semanas
Baseprice = CountR/period; //Media de los cocientes
RSC = ((Cociente / Baseprice ) - 1)*10; //Comparamos el cociente actual con respecto a su media

RestorePriceArrays(); // volvemos al actual valor


// [...] Fin modulo de calculo del RSC Mansfield del Sector GICS del valor

//mostramos en pantalla la variable RSC que contiene el RSC de Mansfield de Sector GICS

//escogemos la forma de representacion y estilos
SetGradientFill(colorGreen/*top*/,colorRed/*bottom*/,0/*baseline level*/,GetChartBkColor()/*baseline color*/);

//mostramos en pantalla la variable RSC que contiene el RSC de Mansfield
Plot(RSC, "RSC Sector GICS"+ " "+"-"+" " + StrLeft(gicsID(0),2)+ " " + CategoryGetName(categoryGICS, Level1) + " vs S&P500", colorBrown, styleLine | styleGradient);
GraphLabelDecimals = 2;

_SECTION_END();

Thank you very much to those who help newbies like me.

system · August 25, 2024, 11:44am

This topic was automatically closed 100 days after the last reply. New replies are no longer allowed.