CapIQ Screening Excel Formulas

Common Formulas

=@CIQ($A2, “IQ_COMPANY_NAME”)

=@CIQ($A2, “IQ_BUSINESS_DESCRIPTION”)

=@CIQ($A2, “IQ_CLOSEPRICE_ADJ”)

=@CIQ($A2, “IQ_MARKETCAP”)

=@CIQ($A2, “IQ_PE_EXCL_FWD”)

More Formulas

Source: http://larryschrenk.com/Capital%20IQ/Excel%20Plug-in%20Shorts%20Guide.pdf