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
| +131 | New Article: Dramatic Slide as UBS #22 (US) & New Leadership Desperately Needed | 25 | 18h |
| +121 | Americas M&A League Table Q2 Updated | 55 | 2h |
| +76 | Wealthy Parents / Jaded | 24 | 1d |
| +61 | A COMPLETE GUIDE TO SUMMER INTERNSHIP RECRUITING | 11 | 1d |
| +59 | How are hours rn for SA (interns) | 31 | 1d |
| +44 | Boutique firm wants access to my LinkedIn? | 38 | 4h |
| +33 | Investment Banking in Mexico | 9 | 1d |
| +30 | Investment Banking is Hard | 13 | 6h |
| +27 | Restructuring: Anti-climactic Experience | 3 | 9h |
| +21 | Excel macros for QOL formatting | 0 | 4d |
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!
Aut nulla in debitis vel error. Id repudiandae quia voluptates consequatur aut sed. Aut sunt reiciendis atque et.
Nemo similique quos quos labore voluptate eos. Porro nesciunt similique earum neque unde sed sunt.
Commodi ipsam mollitia nostrum voluptates et. Rem nostrum reprehenderit ad vel et. Necessitatibus molestiae voluptatem incidunt accusamus qui et nostrum dicta. Id blanditiis ea necessitatibus qui.
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...