 |
|
||||||||||||
|
DOUGLAS GERLACH'S
NAIC's new Online Premium Services now allow subscribers to download data on nearly 10,000 publicly-traded stocks in a format that's compatible with NAIC Investor's Toolkit, STB Stock Analyst or NAIC Classic software programs. The *.SSG datafile format has evolved over the years and now includes 537 separate data fields. However, only a portion of those are used by the SSG software programs, leaving much of the data "invisible" to users. This Excel spreadsheet allows you to import and view all of the available data in any *.SSG datafile downloaded from the NAIC web site. In addition, the spreadsheet creates graphs of various data, calculates multi-year growth rates and averages (simple and weighted) of various fields. You can also print a two-page report that contains all of the data and a price/PE Ratio chart of the stock. In order to use the spreadsheet, you first must download a *.SSG datafile to your computer. Then click the "Import New SSG Datafile" button at the top of the Company Report tab in the workbook. After selecting the SSG datafile that you've downloaded, the data will load into the spreadsheet. That's it! It was created in Excel 2000 for Windows; it may work on other platforms and version of Excel, but I can't say for sure. When you open the program, you should Enable Macros to allow the file import routine to work. I've also tried to anticipate the most common problem scenarios, but there are many instances where a cell might read #NUM!, #DIV, or #VALUE!. These are usually caused when the spreadsheet doesn't have enough data to make a calculation or because some of the numbers are negative. (If that's the case, that's generally indicator enough of a problem with the company you're studying.) If you have any questions or suggestions, please let me know. Right click here to download the Excel spreadsheet to your own computer.
|
