- Find Information
- Research Guides
- Finance & Investment
Finance & Investment
• Selected resources on finance and investment
Links to Useful Tools
- Money and Finance tools from wolframalpha.comUtilize the computational power of Wolfram|Alpha to track monetary trends, check up-to-date stock quotes and even access historical market data.
- ExcelMojoLearn and Master Microsoft Excel with 200+ free articles, step by step guides, all about formulas & functions, self-study resources and excel templates.
Security Identifiers / Key Market Identifiers & Industry Standard Classifications
- CIK - Central Index KeyEDGAR Company Filings | CIK Lookup
- GVKEY - The Global Company KeyIssued by S&P Capital IQ Compustat. E.g.: GVKEY of IBM and Microsoft https://wrds-web.wharton.upenn.edu/wrds/demo/results_compustat.html
- ISIN - International Securities Identification NumberIts structure is defined in ISO 6166. The ISIN code is a 12-character alphanumeric code.
CRSP/Compustat Merged Database - Linking CRSP and Compustat
Why CCM (CRSP/Compustat Merged Database)?
CRSP and Compustat have been the two most widely used database for research in finance and accounting research. As a CRSP product CCM provides a link between CRSP stock data and Compustat fundamental data since two of them do not share common security and company identifiers, while TICKERs and CUSIPs can change over time.
Company Identifiers & Conversion
S&P Capital IQ Excel Plug in: Installation & Application
- Video: 7 Minutes Simple Guide | Download Data Using S&P Capital IQ Plug-in In Excelhow to save (as new screen) within CIQ's Company Screening, then pull out and access that saved screen from Excel CIQ plug-in and further manipulate or add new data