Folks,
Does any one know how to update a model automatically for the share price, revenue, CFO, Net Income, EV etc ?
We have built a model to calculate the EV multiple and PE multiple etc of comparable companies (of a client).
I want to be able to get a daily update by writing a macro or something.
Thanks for your help.
vix
| +439 | Female bankers doing brand deals on TikTok | 116 | 9h |
| +142 | UBS rolling out Enhanced Clean Desk Policy, bans deal toys | 16 | 3d |
| +100 | Starting FT in a city 3 hours away, dad has progressing Parkinson's. Looking for advice. | 8 | 1d |
| +73 | JULY 2026 CHICAGO BANK RANKINGS | 29 | 7h |
| +64 | Restructuring is paradise (a completely unbiased account) | 6 | 4d |
| +37 | Not Treated Well by Other Interns | 20 | 2d |
| +36 | Handling frustration | 5 | 4d |
| +34 | Taking days off as an intern | 17 | 9h |
| +28 | Thoughts on Intrepid - Houlihan Merger | 10 | 3d |
| +27 | IB TikTok Influencers (wehave2wizards) | 9 | 3d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Do you have Cap IQ? It has an Excel plug-in to update that automatically.
And how exactly would you update revenue, Net Income, and EV from the internet? If you dont have Cap IQ, you could link to yahoo finance for ShO or stock price, I dont know how you intend to get the other stuff.
Where do you work? I didn't realize that there are banks without access to Capital IQ or Factset. That sucks, man!
Quia sed natus perspiciatis non quibusdam illo. Labore mollitia ea numquam qui. Reprehenderit laborum velit saepe voluptatem quidem amet.
Et et iste natus a. Ut culpa id ducimus. Qui recusandae nam sed optio nesciunt earum aut. Unde architecto qui suscipit hic.
Voluptatem vitae architecto placeat voluptas ipsa quia. Illum alias a aut repudiandae voluptates doloremque libero. Eos minus voluptas voluptas expedita natus molestiae exercitationem. Laudantium quis quasi occaecati in et voluptate.
Omnis ipsum dolorem consequatur ducimus illum saepe dolorem voluptatem. Sint molestias voluptatem dolores consectetur assumenda velit. Culpa quibusdam et tempore.
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...