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
| +160 | UBS Tech layoff | 52 | 1d |
| +157 | Analyst: Why is UBS IB doing worse than peers?, UBS CFO: No Comment | 26 | 4h |
| +146 | UBS’s M&A BANKERS ARE DOING TERRIBLY. $200M EXTRA IS BEING CUT | 31 | 21h |
| +92 | Leaked Interview Questions to Recruiting Services | 44 | 1m |
| +59 | Are target prospects getting dumber? | 27 | 20h |
| +58 | How do YOU manage networking requests? | 17 | 1d |
| +37 | Quitting After First 4 months | 12 | 2d |
| +34 | MBB Pay Raises | 26 | 2d |
| +23 | My new boss told me they have no idea what I was doing? | 2 | 7m |
| +19 | Rothschild UK - Mining & Healthcare 2026 | 5 | 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!
Id pariatur accusantium fuga dolore sunt et facere. Earum qui ut voluptatem et qui tenetur. Ex ut maxime natus assumenda sapiente et hic voluptates. Blanditiis officia repellendus laborum dolore voluptate labore eligendi. Provident quia rerum quos qui error vel maxime labore.
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...