I made a comps generator, thoughts?

https://compsmaker (dot) com

It's kind of a proof of concept. Basically you provide the tickers of your comps, multiples are computed in ~5 sec and you get a nice football field. It should work with all non-financial companies listed in the US, UK and some European countries. I put some examples (click on the logos) so you can see what it looks like without having to enter tickers by yourself.


What do you think about it? Works best on PCs since the screen is larger. If you get errors/bugs/weird behaviors please let me know what tickers you used so I can look into it.


[if you get a "Bad Gateway" or if the connection cuts abruptly, that's because I restarted the system as I'm working on the code]

 

Not the intention, just wanted to know if there were any differentiating features. Cool project nonetheless

 

Really great! 

How did you learn to code this? If you can share any resources that would be amazing. 

 

Well in terms of resources it's hard to say, since I started coding at quite a young age and just worked on projects over the years, and that's how I gained experience. It has basically been trial & error and a lot of googling.

Now I'd say the best way to learn is first to understand the basics of the language (https://www.codecademy (dot) com/learn/learn-python ) such as functions, operators, types of variables, object-oriented programming, etc. Once you have a good understanding of "how to write" Python code, you can start using external libraries to make fun projects. I've heard very good things about this book https://automatetheboringstuff (dot) com/ . It deals with file and image manipulation, web scraping, GUI automation and many other things.

Once you have enough experience in Python, you just need Google to look up the errors you sometimes meet and correct them. Again, the best way to learn is to be project-driven. For instance, if you want to get all the titles of the threads posted on the first page of the IB forum, you'd do

web scraping

If you're interested in advanced web scraping you'd need to learn HTML/CSS (relatively easy) and how HTTP requests work (everything's on Wikipedia). Then you can do really cool things and create complex software. At some point it's more about efficiency, so you learn about multithreading to send 50 requests per second, but then your IP gets banned by the website you're parsing, so you have to learn about proxies and find the rate at which your proxies don't get banned. Trial and error, again.

(I haven't talked about the webpage per se, but it's just regular HTML/CSS/Javascript. The Bootstrap framework is used to generate tables, and Chart.js to generate the football field)

 

This is really cool, do you think you can add something to the site that can let you download the results to excel? 

 

I thought about it, and it is indeed possible in theory. For instance the user clicks on a button and an XLSX file is generated. The thing is that the system would have to reproduce those tables cell by cell, which consumes a lot of RAM. If several users do that at the same time, the server would likely crash.

I'm working on an implementation in Javascript, so the user's web browser itself would take care of generating the file rather than the server.

 

Works great! What's the syntax for adding companies from other geographies (say Brazil/India/Japan) or emerging markets? Apologies in advance if you've already mentioned and I've missed it.

Seems like this'll be great to have on hand when that oh-so-dreaded question pops up in meetings - "Hey what's with the run up on [insert piddly penny stock no one's ever heard of]" and you've to make sure your MD doesn't get egg on their face.

 

Thanks for your feedback! You should be able to do so simply by submitting their ticker. The option to specify which stock exchange you'd like to use is most useful if the company you're interested in is listed on several stock exchanges such as GlaxoSmithKline (NYSE:GSK and LSE:GSK) for instance. However, the system chooses the U.S. one by default so I would recommend using a stock exchange prefix for non-US stocks just in case.

I changed the code to allow the user to enter tickers containing numbers. You can try for instance 

ABEV3 - AZUL4 - BTOW3 - CCRO3 - BRFS3 - GGBR4 - NTCO3 - Brazil

4503 - 4208 - 5108 - 5333 - 5714 - 7004 - 9301 - Japan

Stocks from India (GODREJCP, TATAMOTORS...) are also supported, although data is sometimes lacking which means that some metrics cannot be computed.

 

This is awesome! Would be great if there was an export to excel feature, though.

 

Yep, I had to pull the plug when I started working full-time as the project was quite time consuming - monitoring bugs, developing new features, etc. I preferred to turn the server off. The project might come back one day, we'll see.

 

Quos fugit ipsa doloremque ad. Rerum qui sint a aliquam et dolores repellendus. Reiciendis autem quia et placeat id aut.

Recusandae et qui soluta non error corrupti alias esse. Deserunt veniam sed et accusamus iusto pariatur voluptates distinctio. Quam expedita sed laboriosam voluptatem quam nesciunt. Dolor repellat facilis ipsum. Ipsa nihil dolores in.

Non doloremque quas consequatur aut sed fugit delectus repellendus. Commodi voluptas reprehenderit soluta magnam iure nihil. Totam eum necessitatibus eum ut explicabo.

Quo molestiae et corporis autem rerum laudantium voluptatem. Corporis adipisci voluptatem veritatis omnis natus ut quasi odit. Vitae quia error quis qui nulla. Libero laudantium architecto autem inventore. Cupiditate voluptate incidunt ea labore dignissimos. Corrupti dolorem minus id nostrum est et consequatur consequatur.

 

Voluptatem tempore est et nostrum velit vel sunt quidem. Unde accusantium eos quia voluptas. A incidunt voluptates minus similique. Est omnis facere eum qui ab sunt. Ipsum est unde quaerat.

Nobis provident sit rerum quibusdam debitis. Sed laborum veritatis est qui. Labore ut minima et esse. Aut id sed doloremque quas omnis illo quia. Suscipit voluptatem minima qui voluptatem.

Ipsum mollitia cupiditate fugit non voluptatem sunt. Incidunt eos voluptatem doloremque iure consequuntur et. Ut suscipit id incidunt recusandae qui aut distinctio. Velit dolorem consequatur fuga dicta. Enim harum est enim ut.

Vel repudiandae sunt dolore odit. Deserunt harum vero rerum voluptatem assumenda. Reprehenderit harum aliquam similique sint non ut consequatur nulla. Non aut ut est dolorum et dicta asperiores est. Ad aliquam nam inventore veniam velit.

Career Advancement Opportunities

April 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. New 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

April 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

April 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

April 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (87) $260
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (146) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”