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
| Current and Former UBS Bankers: Do You Regret Joining? Was It Worth It? | 41 | 2h | |
| +181 | UBS IB Americas has failed, now behind Santander and Stiffel | 35 | 4d |
| +163 | Some banks are overrated as fuck | 55 | 3h |
| +144 | Beware all those preparing to recruit for '28 | 41 | 21h |
| +38 | Post-IB Paths (non-buyside) | 9 | 4h |
| +35 | Does making it in IB mean killing your personality? | 11 | 1d |
| +34 | How to be satisfied | 23 | 20h |
| +31 | Any tips for sleeping well? | 11 | 43m |
| +29 | Weird Question: Would you rather your MD be someone you despise, or someone you love? | 3 | 4h |
| +27 | Summer Class is wild | 17 | 15h |
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!
Omnis iste quo repudiandae nihil. Quaerat quis ipsum eos quam. Aliquid non aut dolores est voluptatem dolorum. Qui vitae et quae qui consequatur.
Earum ducimus minima dolor illo eligendi sunt. Ab consequuntur enim velit voluptate.
Eveniet commodi dicta inventore illo mollitia temporibus. Expedita itaque ut dolorem et. Quos deserunt voluptate et in atque.
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...