Capital IQ: Excel plug-in
To use the Excel plug-in's Formula Builder after having gotten desired data on Capital IQ web platform
Answer
One of the most effective ways of using Capital IQ (see the link below) is through its Excel plug-in Formula Builder. Below are steps for using Formula Builder after having gotten desired data on Capital IQ web platform:
- After getting to your desired data page from Capital IQ web platform; e.g.: typing: S&P 500 or ^SPX in the top search box to get a list of S&P 500 “Constituents” on Capital IQ webpage.
- First click "Company Screening" (located in the 2nd box titled "Constituents"), and then click the sub-tab with a Disk icon - "Save as New Screen" (now this tab is located just under Tab "View Criteria" on the top of the page).
- Now you can give a name for this screen so that the named screen as a file - containing data, in this case a list of S&P 500 companies - to be used as a basis for coding in order to generate more substantial data within Excel program. (after saving, you will see a message: "Your screen has been Saved. You can access this screen by clicking the "Saved Screens" link."
- Open Excel program > click “S&P Capital IQ” Ribbon > click "Screening" button > then “Download Screens” window popups > select the saved screen/file in the list > after the saved CIQ screen opens, click button “Formula Builder” which is located by "Screening" button.
- In the “Formula Builder” popup window, try to insert and create CIQ formula of your desire into any Excel cells, so you can pull out financial data from CIQ databases into Excel.
- This is a more effective and efficient way to get larger amounts of data than from Capital IQ web platform. Instead of getting a list of S&P 500 “Constituents”, you can use the same process to get data on Dow Jones Industrial Average (^DJI) > Constituents or data on NASDAQ Composite Index (^COMP) Constituents.
- For detailed instruction on how to use and build CIQ formula in Excel plug-in, please refer to the following two documents: