The truth is that I like this product more and more and I am evaluating it very positively. This way I will end the big headache of the Database and I will be able to focus on learning AmiBroker and all its potential uses.
I have one question related to the classification, for example, the GICS. If I'm not mistaken, this classification has 11 sectors, 25 industrial groups, 74 industries and 163 sub-industries.
In the Norgate Data database, do indices (or ETFs that replicate them) exist for these sectors/industrial groups/industries and sub-industries? That is, are the 11 indices that represent the 11 GICS sectors, the indices that represent the 25 industrial groups, etc. included?
I don't know if I'm explaining myself well...I intend to make a comparison of the realtive strength (RSC Mansfield) of each of these sectors/industries versus, for example, the SP500 index and obtain which are the strongest or weakest.
We cover the level 1-4 GICS S&P 1500 industry indices.
Note that the indices only exist where there are active constituents. The deeper you go in to the classifications, there's a chance that there won't be any companies present in the S&P 1500 with that classification.
For example, the Level 4 GICS sub-industry "Precious Metals & Minerals" has no constituents. Clearl yoyu can't calculate an index with zero constituents!
Indeed, many of the S&P 1500 Level 4 indices only have a limited number of constituents, so you might want to restrict your modelling to Levels 1-3.
We have added functions to AmiBroker that allow you to determine, for any stock, the index symbol for a corresponding index, whether or not it is actually part of the index: https://norgatedata.com/amibroker-usage.php#industryindex
Thank you very much for your reply. The truth is that I really like what I see in Norgate Data, it's a shame it doesn't include Europe
I would like to ask you something else:
If, for example, we look at the GICS classification for Sector 10 Energy, we see that there are 5 options "to represent it", that is, there is the $IXE Energy Select Sector Index, the $SP1500E, the $SP1500ETR, the $SPXE AND THE $SPXETR . Which of them would be appropriate to represent Sector 10?
The same thing happens if I go down a level, for example at the next level 1010 Energy, I find three options, $SP1500EN, $SPXEN and $SP1500ENTR. Which of them best represents the IndGrp Index 1010?
They all represent the GICS Sector 10. The stocks contained with them are all in GICS Sector 10. There are other conditions relating to the membership criteria for each index, with the Select Sector being the most restrictive in terms of market cap and total number of securities through to the S&P 1500 being the least restrictive. You can learn more about this by looking at the various S&P methodology documents - there are various complexities here. In addition, some indices are free-float market-cap weighted and others are equal-weighted (well, to be more precise, equal-weighted at a particular point in time then reweighted at some time period thereafter). Again, this is detailed in the index methodology documents.
None of them is the "best" - they each represent that Industry Group but with variations as to the market cap ranges and weighting.