Capiq Formula Cheat Sheet

Right click the sheet tab and select.

Capiq formula cheat sheet. Can find key statistics income statement balance sheet and much more. Hedge fund business plan. S p capital iq is a powerful tool for market data especially when used with its excel plugin. Capiq excel plug in formula builder basics.

Double click the sheet tab enter a new name for the worksheet and press. When looking for a formula you can try their handy formula cheat sheet or ping other users here on wso. 86 10 6569 2745 australia. 6 estimates this page.

Client support hong kong. Right click the sheet tab and select. We would like to show you a description here but the site won t allow us. S p capital iq s excel plug in.

81 3 4550 8272 china. Here are various forms of contact if you don t have a direct contact already. Capiq client services in addition to the cheat sheet above the best resource may be the capiq client services team. Capiq short for capital iq is a market intelligence platform designed by standard poor s s p.

The button for download is below the top menu outlined in blue on the below diagram. Includes income statement balance sheet cash flow statement supplemental line items and ratios for a selected company with a dropdown to choose period type and order of periods most recent on the leftmost or rightmost column. The platform is widely used in many areas of corporate finance including investment banking equity research asset management and more. The capital iq platform provides research data and analysis on private public.

Frequently used formulas balance sheet income statement cash flow statement cash and equivalents iq cash equiv total revenues iq total rev net income iq ni cf short term investments iq st invest cost of revenues iq cost rev depreciation amort total iq da cf total cash st investments iq cash st invest cost of goods sold iq cogs asset. Users also have the option to download this information in an excel sheet for further analysis. Button next to the sheet tabs below the active sheet. 257157748 ciq excel cheat sheet june 2012.

Community members provide these tips for how to look up ciq id by referencing the company name. 65 6530 6546 japan. They are known for top notch customer service and actually answering questions sometimes walking you through how to build formulas if needed.