{"id":1162,"date":"2024-10-25T12:16:19","date_gmt":"2024-10-25T10:16:19","guid":{"rendered":"https:\/\/blog.iese.edu\/newsletter-library\/?p=1162"},"modified":"2024-10-25T12:12:40","modified_gmt":"2024-10-25T10:12:40","slug":"106-resources-tip","status":"publish","type":"post","link":"https:\/\/blog.iese.edu\/newsletter-library\/106-resources-tip\/","title":{"rendered":"S&P Capital IQ Excel Plug-in"},"content":{"rendered":"

\u00a0<\/span>Return to the #106 Newsletter<\/span><\/span><\/a><\/em><\/strong><\/p>\n

The S&P Capital IQ Excel Plug-in<\/strong> is a tool that will allow you to populate and update your spreadsheets with financial, market, transaction, macroeconomic and company data using unique S&P Capital IQ formulas.<\/p>\n

Building financial models typically entails hours of basic research and tedious data entry. Now, with the S&P Capital IQ Excel Plug-In, you can complete your work in a fraction of the time it would take to do so manually.<\/p>\n

1. Go to Capital IQ<\/span><\/a><\/strong><\/p>\n

2. To download the Excel Plug-In, hover over the ‘My Capital IQ<\/strong>‘ tab and click on ‘Downloads<\/strong>‘. Open the installer and follow the prompts to complete the setup. Ensure all Excel, Word and PowerPoint instances are closed.<\/p>\n

3. Open a blank Notepad.<\/p>\n

4. Paste the following snippet on the blank Notepad.<\/p>\n

<\/div>\n

\"Library<\/p>\n

<\/div>\n

5. Save the file as \u201cCIQSAML.reg\u201d<\/p>\n

6. Change ‘Save as type’ to \u201cAll files (*.*)\u201d and save it anywhere on your PC or device.<\/p>\n

7. Navigate to the file location, right-click on the file, and open it with \u201cRegistry Editor<\/strong>.\u201d<\/p>\n

<\/div>\n
\"Library<\/div>\n
<\/div>\n

8. In the pop-up window click on Yes<\/strong>.<\/p>\n

\"Library<\/div>\n
<\/div>\n

9. Launch Excel and login to CIQ Excel via your IESE credentials.<\/p>\n","protected":false},"excerpt":{"rendered":"

\u00a0Return to the #106 Newsletter The S&P Capital IQ Excel Plug-in is a tool that will allow you to populate and update your spreadsheets with financial, market, transaction, macroeconomic and company data using unique S&P Capital IQ formulas. Building financial models typically entails hours of basic research and tedious data entry. Now, with the S&P Capital IQ Excel Plug-In, you can complete your work in a fraction of the time… <\/p>\n

Read More<\/a><\/div>\n","protected":false},"author":168,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[95017,94970],"tags":[],"class_list":["post-1162","post","type-post","status-publish","format-standard","hentry","category-106-october-2024","category-resources-tip"],"_links":{"self":[{"href":"https:\/\/blog.iese.edu\/newsletter-library\/wp-json\/wp\/v2\/posts\/1162","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.iese.edu\/newsletter-library\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.iese.edu\/newsletter-library\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.iese.edu\/newsletter-library\/wp-json\/wp\/v2\/users\/168"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.iese.edu\/newsletter-library\/wp-json\/wp\/v2\/comments?post=1162"}],"version-history":[{"count":17,"href":"https:\/\/blog.iese.edu\/newsletter-library\/wp-json\/wp\/v2\/posts\/1162\/revisions"}],"predecessor-version":[{"id":1191,"href":"https:\/\/blog.iese.edu\/newsletter-library\/wp-json\/wp\/v2\/posts\/1162\/revisions\/1191"}],"wp:attachment":[{"href":"https:\/\/blog.iese.edu\/newsletter-library\/wp-json\/wp\/v2\/media?parent=1162"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.iese.edu\/newsletter-library\/wp-json\/wp\/v2\/categories?post=1162"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.iese.edu\/newsletter-library\/wp-json\/wp\/v2\/tags?post=1162"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}