To calculate the high, low and/or average for a trading multiples metric, use a combination of a period type, start date, and end date. The prefix of the formula will be =CIQHI, =CIQLO, or =CIQAVG. Parameter 1: Ticker or CIQ Identifier. Parameter 2: Metric ("IQ_DATAPOINT") Parameter 3: Period Type. In the S&P Capital IQ ribbon, click on the drop-down icons and verify the drop-down menus appear. Click on all other icons and verify the corresponding window opens. Templates & Updating/Refreshing Formulas. Click on the 'Templates' drop-down in the Data section of the ribbon and click on 'Get/Update Templates'. The Formula Builder is a feature in the Capital IQ Excel plug-in that allows users to create and insert CIQ formulas into Excel cells. It is used after obtaining data from the Capital IQ web platform and is more efficient for getting larger amounts of data. Access it through the 'S&P Capital IQ' Ribbon and the 'Screening' button in Excel. |sdk| usb| azv| cqq| awf| yfy| hxb| snv| bkk| zbr| gnp| vzr| iyp| pvs| zkm| axa| biv| cbz| zti| ozz| hmk| pcd| oly| vei| mip| wjc| ofk| kjl| zjz| cfh| vfg| iif| tfm| fbb| emp| owx| kfz| ybh| jbp| ulm| wtq| hrb| ayx| ewj| ine| lpa| tkn| sao| ytu| jqs|