I'm sure that many of you have already registered your personal account in our newest financial database: S&P Capital IQ. (If you haven't, follow the instructions in the Public Note part of the CapIQ database record --
while you are on campus * -- after which you will be all set to access this database remotely.)
And if you've registered, then you've probably started exploring the web interface to see what sorts of data you can find and export... and you might have even watched some of these videos to be sure you are getting the most out of the database...
But have you installed the Excel Add-in part of the database yet?
In my experience, many people delay using the Excel Add-In... sometimes forever! The logic seems to be that the web interface is adequate for most needs, and some people think that the Excel Add-In is just for power users who want to build complex formulas.
Well, the ability to create your own formulas and pull large amounts of data into a spreadsheet is, indeed, one of the features of the add-in, but there is another feature that will save you time and effort from Day One: Templates!
Check out this screenshot showing the categories of templates available to you... from Alpha Factors all the way down to Valuation and Workflow.
Intriqued? Excited? Great! Here's what you need to do...
- Register (on campus) for your S&P Capital IQ account (as discussed above)
- Sign into your new account on your own computer (must be Windows-based to install the Excel Add-In, sorry!)
- Click on My Capital IQ in the top left corner of the CapIQ screen, then on Downloads
- Click on the "Download Office Plug-in (New Installer)" link and follow the instructions
Within minutes, you'll be creating professional-looking workbooks full of powerful data about companies, securities, and markets.
* Note (Apr. 27, 2020): During the COVID-19 disruption, S&P has altered the account registration procedure to allow off-campus account registration.
Business & Economics Information Specialist