The process involves either manual data entry from the 10K or press release, or using an Excel plugin through financial data providers such as Factset or Capital IQ to drop historical data directly into Excel. Solution: Go back to your syntax and manually inspect to quite understand your question. S&P Capital IQ Fundamentals S&P Capital IQ enables you to make smarter decisions by providing industry leading fundamental data that is fully transparent, standardized, and integrated into our analytics. Excel add-ins These typically include Excel add-in (. Capital iq excel plugin not showing up With over 99% of the global market capitalization covered, our database provides comprehensive global coverage for more complete analysis.