comparable companies excel model?
does anyone have a comparable companies excel template? specifically, one with macros that looks up the ticker and spits out financial data? any help would be greatly appreciated
thanks!
Trending Content
| +162 | The "Not So Obvious" things that get you a return offer? | 19 | 34m | |
| +91 | Is my life over after not getting GS? | 20 | 1h | |
| +62 | Best IB group on the Street | 26 | 1h | |
| +52 | BIG FOUR ARE PARADISE | 13 | 13h | |
| +46 | Thoughts and tips on how to speak like an investment banker. | 24 | 2h | |
| +41 | Tell me one good reason why Jefferies isn’t going to be a top bank in the next 5 years | 22 | 1h | |
| +36 | UBS Outlook | 28 | 1d | |
| +35 | Georgetown Placement for 2024 and 2025 | 21 | 6d | |
| +31 | Highest Paid Bankers in Toronto? | 50 | 1d | |
| +30 | How to deal with egotistical team? | 6 | 2d |
Career Resources
might have it
Just spits out tickers and financial data huh? That is one hell of a free macro you're looking for
I think Bloomberg can do at least part of the spitting out financial data.
You can even try to create one yourself...It's actually not hard to do.
http://www.vertex42.com/News/excel-web-query.html
If you're decent with VBA coding it wouldn't be too difficult at all. I would give it a shot but I have exams to study for :-)
I know that Yahoo's numbers can be diff than a lot of other people, but you can use their industry comparisons...they export to excel, but then again you can't pick spec. companies.
http://biz.yahoo.com/p/sum_conameu.html
Are you using a computer that is connected to a bloomberg terminal for this? You can actually use a lookup if you are...
Consequatur illo tempore rerum tenetur qui rerum maiores. Doloribus porro eius distinctio aut cumque qui et assumenda. Doloribus molestias accusantium nesciunt maxime. Ut eveniet qui aut.
Deleniti ipsa alias soluta aliquam non ipsam. Rerum et delectus rerum ratione dolores aut quod. Consequuntur consequuntur harum doloribus. Fuga quia ducimus porro molestias sequi. Rerum quia alias eum perspiciatis. Eos harum excepturi saepe vel ipsum minima. Nisi ratione blanditiis sapiente qui dicta similique placeat aut.
Eligendi atque ullam nihil. Ut enim asperiores voluptatem voluptate provident. Dolor sit deserunt sequi ullam.
Accusamus et assumenda debitis. Reprehenderit non atque blanditiis. Aut aut temporibus qui placeat eius ut molestias. Minima delectus qui nam rerum.
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...