You are here

SFU Library blog, BUEC Buzz, with colourful banner showing students

A current awareness resource for students & faculty members in Business & Economics

S&P Capital IQ: Save time with an Excel template!

Published July 31, 2018 by Mark Bodnar

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.  

Screen capture showing the many categories of templates available in CapIQ's excel add-in.

Screen capture showing the top-left corner of the web interface of CapIQ with highlights on the places to click to download the excel plug-inIntriqued? Excited?  Great!  Here's what you need to do... 

  1. Register (on campus) for your S&P Capital IQ account (as discussed above)
  2. Sign into your new account on your own computer  (must be Windows-based to install the Excel Add-In, sorry!)
  3. Click on My Capital IQ in the top left corner of the CapIQ screen, then on Downloads
  4. 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.  

Enjoy!

-- Mark

* Note (Apr. 27, 2020): During the COVID-19 disruption, S&P has altered the account registration procedure to allow off-campus account registration. 
~~~~~~~~~~~~~
Mark Bodnar
mbodnar@sfu.ca
Business & Economics Information Specialist

Blog Categories

Blog Tags