WallStreetOasis.com » Forums » Industry Specific » I-Banking Bullpen

comparable companies excel model?

(Chimp, 7

Points) on 4/29/08 at 9:32pm

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!

Login or register to post comments
Email this Forum topic

Tags:

I-Banking Bullpen

check out docstoc.com

by wallstreetguy25

(Baboon, 135

Points) on 4/30/08 at 1:47pm

might have it

Login or register to post comments
Email this comment

Just spits out tickers and

by PublicEquity1

(Senior Monkey, 81

Points) on 4/30/08 at 2:32pm

Just spits out tickers and financial data huh? That is one hell of a free macro you're looking for

Login or register to post comments
Email this comment

bloomberg

by ragnathor

(Chimp, 11

Points) on 4/30/08 at 10:52pm

I think Bloomberg can do at least part of the spitting out financial data.

Login or register to post comments
Email this comment

You can even try to create

by lynnventures

(Senior Monkey, 79

Points) on 4/30/08 at 11:18pm

You can even try to create one yourself...It's actually not hard to do.

http://www.vertex42.com/News/excel-web-query.html

Login or register to post comments
Email this comment

If you're decent with VBA

by Revsly

(Monkey, 51

Points) on 4/30/08 at 11:24pm

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 :-)

Login or register to post comments
Email this comment

I know that Yahoo's numbers

by oversold

(Baboon, 138

Points) on 5/1/08 at 7:54am

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...