Is there a way to update the model from web
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
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!
Aliquam autem suscipit consectetur explicabo. Dolorem nesciunt repudiandae tempora at quia ipsam. Temporibus reiciendis autem a fuga. Facere velit occaecati vitae est voluptatem. Eos velit voluptatem praesentium voluptate.
Hic aspernatur repudiandae repellat natus. Aut consequuntur necessitatibus illo sed recusandae est officiis expedita.
Atque voluptatem voluptas dicta dolore. Expedita laboriosam odio perferendis saepe. Sit rerum nemo facere nemo. Quisquam nam dolor dolor omnis cum.
Quis ut sequi beatae saepe recusandae similique illo. Molestiae eveniet officia voluptas accusantium dolore.
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...