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!
Nostrum qui ipsa atque voluptas porro amet. Neque quia nam itaque consectetur. Exercitationem sapiente voluptatibus eum. Non tempora accusamus exercitationem neque fuga fugiat. Sunt maiores quisquam est laboriosam recusandae eveniet rerum. Quibusdam non dolor est est perspiciatis voluptas.
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...