At my firm we don't use any tools to update models automatically, nor do I know of any that exist. We currently have around 50+ tickers that need to be updated each quarter. I've built a tool for my personal use that can pull the financial statements via an API, and fill them in automatically to my model. It can also do so from PDFs.
Curious if anyone has used any tools to pull financials automatically into excel, or parse from PDFs. Happy to let others try it out if interested, but it's definitely something i've found lacking with CapIQ, and the tools we have.
Based on the most helpful WSO content, here are some insights and suggestions for automating quarterly updates for 3-statement and DCF models:
Python for Automation:
PDF to Excel Conversion:
Outsourcing:
Existing Tools and Gaps:
Community Collaboration:
By leveraging these strategies, you can streamline the process of updating your financial models and reduce the manual workload each quarter.
Sources: Help me overcome this nightmare: PDF to Excel, What kind of tools / apps do you wish existed in the industry?, Screen shot to excel converter, Learning to automate financial analysis tools with Python, Using Python to Automate tasks in ER/IB
I don’t get why all these startups are trying to automate modeling as if bankers / pe investors want to abstract the one part of their job that requires critical thought. Like if you’re going to do a DCF you want to flex the puts and takes yourself to get to YOUR view of valuation, not something a computer spits out. The only thing I could see being useful is automating spreading TEV of companies, or maybe something very simple like an AVP - but please dear God stop trying to fucking automate LBOs and DCFs. That’s literally what the humans doing M&A get paid to think through.
Can there not be an automation that allows you to insert some inputs, and then have the computer build a model around these inputs?
Hey, I would use BBG excel functions to pull GAAP (as reported) Financials into an excel. Then you can build your own model/financial summary above it by referencing the GAAP statements or KPIs below. Think that's the most simple solution. In case it's helpful go to BBG, put in the ticker --> FAA --> Select GAAP As Reported --> Pull the cells you want into your excel. Or, you can just use "Export as Excel" and it'll download an excel with all the formulas prewired.
You have CapIQ and yet you can't figure out how to build a model that can auto update itself? Here, Boss.
Sounds like you didn’t read the post
Your post that said you haven't found a tool to update financials automatically and that it can't be done in CapIQ?
if only you spent a bit more time reading through the post you would have saved yourself the time of typing a useless comment and reply
Omnis dolores molestiae voluptatum asperiores tenetur est velit. Est eius aspernatur sint quia. Cupiditate est et aut cum. Asperiores magnam in delectus dignissimos ducimus ipsam. Veniam non mollitia hic temporibus.
Autem et unde voluptates ad omnis sed. Dignissimos nostrum laborum voluptatibus aliquam excepturi molestiae. Est vero aperiam sed debitis debitis quia dolores. Quibusdam neque illo voluptatibus provident animi consectetur. Mollitia vel et eaque sapiente voluptatem.
Excepturi debitis et corrupti dolor. Doloremque sed et rerum dolorum laborum vitae earum. Ut quam voluptatem a labore sint voluptatum tempora reiciendis. Modi qui debitis debitis iusto saepe porro praesentium. Suscipit et corrupti quia eum.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...