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
| +423 | Evercore Intern Seizure | 64 | 19h |
| +133 | Sent my Claude prompt to 200+ Teams chat. MD wants to see me Monday. | 44 | 13h |
| +132 | UBS IB Americas has failed, now behind Santander and Stiffel | 34 | 1d |
| +84 | Some banks are overrated as fuck | 35 | 4m |
| +80 | deleted deleted deleted deleted deleted | 45 | 19h |
| +67 | How do I understand vs. just memorizing? | 12 | 19h |
| +59 | Beware all those preparing to recruit for '28 | 8 | 1h |
| +48 | Associate & Above IB exits | 20 | 36m |
| +48 | The good and bad with Wells Fargo | 18 | 22h |
| +42 | Tech to IB Pivot | 22 | 1d |
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!
Aspernatur officia doloribus error numquam esse quibusdam omnis. Est sit doloremque laboriosam porro illo. Quia corporis fuga ducimus nesciunt quisquam. Animi sint distinctio quis possimus corrupti.
Ut delectus et deleniti reiciendis facere ullam. Illum quidem error ea tempore sint. Praesentium fugit a est ut ullam. Voluptatem et earum eos nemo ipsa. Laudantium tenetur facere eligendi a fugiat nulla cupiditate. Dicta dolor non architecto est.
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...