Important Update: AAII Transition to S&P Data and GICS Classifications

I want to inform you about an important upcoming change in our data services. As part of our ongoing efforts to provide you with the highest-quality data, we are transitioning from LSEG Data & Analytics as-reported financial data and earnings estimates for stocks to S&P Global Market Intelligence standardized financial data and earnings estimates. This change is intended to enhance the comparability, reliability and overall consistency of the financial data available to you.

The transition will be completed on Tuesday, October 1, after a year of programming and testing. During and after the transition, there could be data delays or disruptions. We will make every effort to minimize the impact, and we thank you in advance for your patience and understanding.

Key Impacts of the Transition:

  • Standardization: S&P Global’s standardized financial data for stocks is adjusted for various accounting and reporting differences across companies, making it easier to compare companies within the same industry and across different regions.
  • Enhanced Consistency: Unlike as-reported data, which can vary significantly depending on company-specific accounting practices, S&P Global’s standardized data is uniformly adjusted to reflect the same accounting rules. This provides you with more consistent historical trends and peer comparisons.
  • Impact on Reporting: You may notice changes in specific financial metrics, as standardized data may differ from the as-reported figures.

Additionally, our sector and industry classifications will now follow the Global Industry Classification Standard (GICS), replacing The Reference data Business Classification (TRBC) system. This shift aims to enhance the consistency and depth of the data you access. GICS is a widely recognized system that will align our classifications with industry standards, providing better insights and comparability.

This change will impact the sector and industry median values we report, as the sectors and industries and their constituents will change. Our industry classifications took a broader view in the past, as we are moving from 154 industry classifications for TRBC to 74 for GICS. Under the old classifications, some industries only comprised a handful of companies. Industry median values will be more meaningful by taking a higher-level view of industry classifications. Click here to see how industry classifications are changing with the transition.

Lastly, you will notice a change in the stock universe tracked by our various model portfolios, stock screens and stock analysis tools. As before, our stock universe captures U.S.-listed companies with recent trading histories and financial filings, ensuring that our database tracks companies with current financial data that are actively traded. In addition, we have now instituted a minimum share price of $1.00 for stocks trading over the counter (OTC) to improve the quality of data, analysis and investment decisions.

We understand these changes may require workflow adjustments on your part, and we are here to support you through the transition. If you have any questions or need assistance, please do not hesitate to contact our support team at techsupport@aaii.com.

Also, while we are working hard to ensure a seamless transition to the new data source, there is the potential for data disruptions.

I appreciate your understanding and continued trust.

Discussion

STEVEN A from VA posted almost 2 years ago:

Wayne, Attempted to update SI Pro to Oct 1 data this morning and the format is all messed up; mostly the bulk of the stocks and their data do not appear. I plan to uninstall and reinstall the program; any other suggestions will be appreciated. Steve Arquiette


Wayne T from IL posted almost 2 years ago:

@Steven We have not received any indications of a problem. I ran the auto-updater this morning, and it downloaded and installed the new version of the program. I do not see any data issues within Stock Investor. Anyone experiencing issues should close the program and re-download and install it from the website: https://www.aaii.com/stock-investor-pro


BRUCE B from FL posted almost 2 years ago:

When I try to run the Multiscreen Selector I get numerous errors when selecting various screens.


Wayne T from IL posted almost 2 years ago:

If you run across issues, contact techsupport@aaii.com. This is not a support forum. Thanks!


KEVIN P from AZ posted almost 2 years ago:

There are 823 companies missing SIC (or have invalid SIC of less than 4 char). Last week almost all companies had valid SIC


Wayne T from IL posted almost 2 years ago:

@Kevin SIC code numbers, which can be up to four digits, were last updated in 1987 by the Office of Management and Budget (OMB), and in 1997, OMB assumed NAICS as its new industry classification system. While some organizations and government agencies still use SIC codes for non-statistical purposes, NAICS numbers are the standard for federal economic study applications. It's more than likely we will remove SIC from the database in the future.


KEVIN P from AZ posted almost 2 years ago:

SIC codes were assigned by your prior data provider for every company and it was an important and consistent way to have granular filters on industry components. You have never had NAICS in the database as far as I can tell. If NAICS is the replacement, why wasn't it included in SIPRO in 1997 and every year since? Removing SIC from the database will break thousands of your customers' filters.


Wayne T from IL posted almost 2 years ago:

@Kevin. Yes, you are correct that LSEG provided SIC codes for most of the companies previously in our database. However, as I noted, our database has undergone a significant change, removing a large number of penny stocks and adding a large number of foreign stocks trading on U.S. exchanges.


STEVEN B from NY posted almost 2 years ago:

When I use the search function (binoculars symbol) certain stocks like GM are found in the search list but when I hit ok or enter it does NOT link back to that stock on the viewing screen. Instead it links to the last stock in the database. Even if I move GM into a custom portfolio, the same thing happens. Many other of my stock holdings have the same bug .... including RITM, RIVN, TMHC, RMAX and CUBI. I am running windows 10 and the same bug is happening on both of my PCs. I have reinstalled SIP and re-indexed the files but that did NOT fix the bug. Is anyone else experiencing this problem ?


Wayne T from IL posted almost 2 years ago:

@Steven. Please contact techsupport@aaii.com if you are having data issues. This is not a support forum. You can also reinstall the program to address most issues: https://www.aaii.com/stock-investor-pro


S P from FL posted almost 2 years ago:

Some screens I have used in the past, such as Estimated Top 30 Revisions Up, are no longer supported by Stock Investor Pro. What gives? Moreover, your report on historical performance by screens is dated September 30, so is this report based on the screens of your previous system? If so, when will we see a report on screen performance based on your new system, especially a report which matches the screens that are actually available on SI Pro? Your transition to the new system has left a lot to be still explained.


Wayne T from IL posted almost 2 years ago:

@S P We removed several screens a few months ago that were based on screening strategies no longer supported by other organizations. The only changes we made to the screens online or in Stock Investor were to accommodate the new sector and industry classifications from S&P. The Estimated Top/Down 30 screens were never in Stock Investor. Historical performance is updated monthly. The September performance was based on stocks that passed the screens using LSEG data as the of August that were still in the LSEG database at the end of September. October performance will be based on stocks passing the screens using LSEG data at the end of September that are in the S&P database at the end of October.


Jerry N from CT posted over 1 year ago:

I see that you have removed all downloads prior to October 2024. I wish you let people know ahead of time that this was going to happen or pay your prior data supplier until end of the year of 2024 so people can archive these. Personally all I need is quarterly installations. I depend on these for back testing without old data I have no reason to renew my subscription. Are there any members here that have potential solution for historical data?


TOM W from WA posted over 1 year ago:

The number of "NA" values in my custom field values have exponentially grown since the data source change. I vote we go back to the old data provider.


Wayne T from IL posted over 1 year ago:

@Tom W Going back to our old data vendor is not an option. Feel free to contact techsupport@aaii.com with the formulas of your custom fields and we can assist you.


LEN M from PA posted over 1 year ago:

SiPro Utilities (si_util.exe) now includes a "Check Screens" function, described as "Checks user screens for sector and industry criteria. If found, a prompt will appear for users to print a report of the screen names to be printed, and also a comma-delimited file is created in the user directory. Users will need to edit screens to change the to the new GICS sector and industry data." Re "Users will need to edit screens" How is this done? When I bring up screen editor for a screen, it looks fine.


Wayne T from IL posted over 1 year ago:

@Len If you have a user-defined screen that contains sector or industry, run it to see if you get passing companies (check the line with the sector or industry filter). If you don't get any passing companies, you will need to change the screen. Our conversion app should have done that for you.


LEN M from PA posted over 1 year ago:

@Wayne The screen rule is "Sector Not Equal Financials" So the problem would not be no results, but rather, too many. I still don't know how to tell whether a screen is using LSEG or GICS. Backtesting presents another issue, where I need the old screen before October 1 and the new screen thereafter.


Wayne T from IL posted over 1 year ago:

@Len Please contact techsupport@aaii.com if you have specific issues. Assuming you aren't getting financial firms with your Sector Not Equal Financials filter, you are good.


DOUGLAS E from NY posted over 1 year ago:

STEVEN A from VA posted about 1 month ago: Wayne, Attempted to update SI Pro to Oct 1 data this morning and the format is all messed up; mostly the bulk of the stocks and their data do not appear. I plan to uninstall and reinstall the program; any other suggestions will be appreciated. Steve Arquiette ----- I had a similar issue, but it went away when I ran all the SI Pro utilities (look for the si_util.exe file in the main directory of the current download). In the past, when there has been a major update, this has often worked to fix it. To be specific, I ran them in the top-to-bottom order in the list that's presented. (The only problem I'm seeing now, is that the button to show the fields and their definitions doesn't seem to be doing anything for me. Does that go online now? It would be nice if it were self-contained in the program.)


Thomas T from NJ posted over 1 year ago:

I'm somewhat concerned about the new alert on the SI Pro "past updates" page indicating that historical data sets prior to 10/1/24 have been removed at the request of LSEG. The alert also indicates "we are exploring the possibility of restoring the archive". What's the chances of this occurring? Needless to say that this eliminates the ability to do any meaningful back testing until enough time has elapsed to accumulate enough S&P Global Market datasets to make this possible (many years). It would also be nice if you could have advised SIP subscribers via email of this development (prior notification would have been even better).


John C from MA posted over 1 year ago:

The new data set has created problems printing. Printing an active notebook crashes the program.


Wayne T from IL posted over 1 year ago:

@John C if you have specific issues you would like us to address, please contact Tech Support: techsupport@aaii.com


GREG S from CA posted over 1 year ago:

Is the archive going to be restored or not? Having access to past data is one of the most important features of Stock Investor Pro. By not being able to back test potential trading systems, SIP is a complete waste of money. This is beyond ridiculous and is extremely disappointing to this longtime SIP user.


Wayne T from IL posted over 1 year ago:

@Greg The archive will most likely not be restored. Our former data vendor made this decision, and we are honoring the terms of the contract termination. Additionally, Stock Investor Pro has never been marketed as a backtesting engine. As new versions of Windows are released, older Stock Investor versions may require advanced technical knowledge to run. We understand your frustration and appreciate your longtime support.


J B from TX posted over 1 year ago:

Mr Thorp, I have been trying for about ten days off and on to install the new program. I have called and emailed several times. - No one ever answers the phone or returns voice mails with a call. - I have had one or two snide email replies from support that really don't mean much to a non-IT person. - I have also filled out and sent back the support questionnaire with no results from AAII. - Can you get someone to help me? Or, will I need to continue posting here? Jacob from Dallas SIPro fan and AAII life member since 1982


Wayne T from IL posted over 1 year ago:

@Jacob This is not a support forum. Feel free to contact techsupport@aaii.com with any issues you are experiencing.


Jerry N from CT posted over 1 year ago:

This is to members not AAII. Is there another forum where SI Pro users can chat and connect to discuss tips, recommendations and alternate products? If not is anyone interested in one?


JEAN H from IL posted over 1 year ago:

Jerry, the AAII Community has a Stock Screening special interest group where you could start a thread dedicated to SI Pro. Go to community.aaii.com. Thanks for your interest!


RAVI S from NC posted 6 months ago:

Hi, As per the suggestion of Mr. Wayne Thorp above, I have sent an email to techsupport@aaii.com on an issue related to SI Pro. No response so far. I hope Mr. Thorp can reach out to them and help resolve this issue: Essentially, AXIA/AXIA.P is listed thrice with many data fields that do not match. They should have matched if it was just an issue in merging databases from different sources. It also made me wonder how reliable other data entries are. I have checked SI Pro entries against other sources for a few major US companies. They do match. So, it may not be a major issue. But, still, it would be nice to understand how the database is curated and validated. Also, thanks to Jean H for the suggestion to Jerry on starting a thread dedicated to SI Pro. I suppose I have to create a post in the Blogs section. I did not see any other way. Please comment. Thanks!


You need to log in as a registered AAII user before commenting.
Create an account

Log In

Get your free copy of our special report analyzing the tech stocks most likely to outperform the market.

Download the FREE Report Here: