----------------------------------------------------- --------------------Content Guide-------------------- ----------------------------------------------------- *** Company lists *********************************** We have downloaded some basic data types for several lists of companies. Progressively we will be adding more company lists according to the needs of researchers. Please give us your suggestions, if you think that some data types and/or groups of companies (or instruments) are important and should be added in these folders. You can contact us at: dataroom@safe-frankfurt.de --- A. Folders -------------------------------------- Each of the folders contains data that refer to companies contained in the corresponding constituent list. The names correspond to the following groups of companies: Singapore Straits Times LSNGPORI DAX Index LDAXINDX Dow Jones Industrial LDJINDUS IBEX 35 Index LIBEX35I CAC 40 LFRCAC40 Hang Seng Index LHNGKNGI FTSE 100 LFTSE100 S&P/TSX Composite Index LTTOCOMP S&P 500 LS&PCOMP STOXX 600 LDJSTOXX Korea South East Asia Composite LKORCOMP Shanghai Stock Exchange LCHSASHR Nasdaq Composite LNASCOMP ----Content of each folder -------------------------- ----------------------------------------------------- ----1. CSV Files ------------------------------------ Each constitutent list folder contains two kinds of .zip files. ----------------------------------------------------- A file contains "xxx.x0.zip" in the name and it stores static variables for the firms included in the corresponding constituent list. This file is unique. The variables that are included are: WC06092 : Business Description - Extended (Key Item) WC06091 : Business Description (Key Item) WC06001 : Company Name (Security) WC00000 : Company Status (Key Item) WC06100 : Entity Type (Key Item) WC06010 : General Industry Classification (Key Item) WC07015 : Inactive Date (Security) WC11501 : Indicator - Currently A Mult-Share Company (Key Item) WC11519 : Indicator - Limited Data Set Company (Key Item) WC06030 : Internet Address WC07016 : Latest Annual Updated (Key Item) WC07035 : Latest Interim Date (Key Item) WC06026 : Nation (Security) WC06027 : Nation Code (Security) WC06035 : Worldscope Identifier WC06105 : Worldscope Permanent ID WC07013 : Year Of Fast Update (Key Item) ----------------------------------------------------- The second includes all the others files and it stores 129 variables in a time series format for the firms included in the corresponding constituent list. There are several files of this kind, which together span a period from 1980 to the present (almost) and contain the following data types: WC07531 : Accounting Method For Long Term Investment >50% WC07536 : Accounting Standards Followed WC03040 : Accounts Payable WC08131 : Accounts Receivables Days WC18224 : Amortization & Impairment Of Goodwill WC01150 : Amortization Of Deferred Charges WC04050 : Amortization Of Intangible Assets WC01149 : Amortization Of Intangibles WC05491 : Book Value Outstanding Shares Fiscal WC05476 : Book Value Per Share WC04601 : Capital Expenditures (Additions To Fixed Assets) WC02003 : Cash WC02004 : Cash & Due From Banks WC02005 : Cash & Equivalents Generic WC02001 : Cash & Short Term Investments WC04551 : Cash Dividends Paid Total WC05501 : Cash Flow Per Share (Security) WC05502 : Cash Flow Per Share Fiscal WC08311 : Cash Flow/Sales WC05376 : Common Dividends (Cash) WC03501 : Common Equity WC05301 : Common Shares Outstanding WC05192 : Common Shares Used To Calculate Basic EPS WC05191 : Common Shares Used To Calculate EPS WC05194 : Common Shares Used To Calculate Fully Diluted EPS WC03480 : Common Stock WC01051 : Cost Of Goods Sold (Excl Depreciation) WC06099 : Currency Of Document WC02201 : Current Assets Total WC03101 : Current Liabilities Total WC08106 : Current Ratio WC07034 : Data Update Indicator WC05350 : Date Of Fiscal Year End WC03263 : Deferred Taxes WC03019 : Deposits Total WC04049 : Depreciation And Depletion WC01151 : Depreciation, Depletion And Amortization WC09504 : Dividend Payout Per Share WC05101 : Dividends Per Share WC05110 : Dividends Per Share Fiscal WC18192 : Dividends Provided For Or Paid Common WC05240 : DVFA Earnings Per Share WC18191 : Earnings Before Interest And Taxes (EBIT) WC18198 : Earnings Before Interest, Taxes & Depreciation (EBITDA) WC05201 : Earnings Per Share WC18193 : Earnings Per Share As Reported WC10010 : Earnings Per Share Basic Fiscal WC05210 : Earnings Per Share Basic Year WC05202 : Earnings Per Share Fiscal Year End WC10030 : Earnings Per Share Fully Diluted Fiscal WC18209 : Earnings Per Share Including Extraordinary Items Fiscal WC07011 : Employees WC18100 : Enterprise Value WC18214 : Exchange Rate Used In Translating Balance Sheet WC18215 : Exchange Rate Used In Translating Income Statement/Cash Flow WC01601 : Extra Items & Gain/Loss Sale Of Assets WC01254 : Extraordinary Charge Pretax WC01253 : Extraordinary Credit Pretax WC07033 : Full/Limited Coverage Indicator WC05290 : Fully Diluted Earnings Per Share Year WC04201 : Funds From Operations WC01100 : Gross Income WC18225 : Impairment Of Goodwill WC18226 : Impairment Of Other Intangibles WC01451 : Income Taxes WC04851 : Increase/Decrease In Cash & Short Term Investments WC11556 : Indicator Restated Data Exists WC03030 : Insurance Reserves Total WC01255 : Interest Capitalized WC01251 : Interest Expense On Debt WC01075 : Interest Expense Total WC01016 : Interest Income Total WC08126 : Inventories Days Held WC02101 : Inventories Total WC02255 : Investments Total WC05351 : Length Of Fiscal Year WC02276 : Loans Net WC03251 : Long Term Debt WC08001 : Market Capitalization WC03426 : Minority Interest Balance Sheet WC01501 : Minority Interest Income Statement WC04890 : Net Cash Flow Financing WC04870 : Net Cash Flow Investing WC04860 : Net Cash Flow Operating Activities WC18199 : Net Debt WC01706 : Net Income After Preferred Dividends (Basic EPS) WC01751 : Net Income Available To Common WC01551 : Net Income Before Extra Items/Preferred Dividends WC01651 : Net Income Before Preferred Dividends WC01705 : Net Income Used To Calculate Fully Diluted EPS WC01076 : Net Interest Income WC08366 : Net Margin WC04251 : Net Proceeds From Sale/Issue Of Common & Preferred WC01001 : Net Sales Or Revenues WC01266 : Non-Operating Interest Income WC01249 : Operating Expenses Total WC01250 : Operating Income WC08316 : Operating Profit Margin WC02250 : Other Investments WC05203 : OVFA Earnings Per Share WC05309 : Par Value WC01701 : Preferred Dividend Requirements WC03451 : Preferred Stock WC01002 : Premiums Earned WC01401 : Pretax Income WC08321 : Pretax Margin WC02501 : Property, Plant And Equipment Net WC01271 : Provision For Loan Losses WC08101 : Quick Ratio WC02051 : Receivables (Net) WC01201 : Research & Development WC08301 : Return On Equity Total % WC08376 : Return On Invested Capital WC01084 : Salaries And Benefits Expenses WC05508 : Sales Per Share WC01101 : Selling, General & Administrative Expenses WC03051 : Short Term Debt & Current Portion Of Long Term Debt WC05576 : Stock Split/Dividend Ratio WC05575 : Stock Split/Dividend Ratio Fiscal WC02999 : Total Assets WC03998 : Total Capital WC03255 : Total Debt WC08231 : Total Debt % Common Equity WC08221 : Total Debt % Total Capital WC02649 : Total Intangible Other Assets Net WC03351 : Total Liabilities WC03999 : Total Liabilities & Shareholders' Equity WC03995 : Total Shareholders Equity WC03151 : Working Capital ----------------------------------------------------- ----2. ZIP Files ------------------------------------ Each of the .zip files described above contains a corresponding .csv file.