Tools of the Trade: Pro Tips

Starting this up to compile best-in-class list of banker tools and pro-tricks:

  1. Macabacus [dot] com -- best online resource for financial modeling (hands down). Most of it probably too advanced for banking, but sets the industry standard
  2. BamSEC [dot] com -- best way to browse filings -- even if you don't pay for it
  3. Mergers & Inquisitions -- good general investment banking guides and some good PE content as well
  4. StreetOfWalls [dot] com -- good LBO interviewing & practice materials
  5. LogoIntern [dot] com -- best online logo resource (finding and formatting logo slides automatically).

What else belongs on here?

Comments (35)

Feb 2, 2017

Definitely a big Bamsec fan, nice call.

    • 1
Feb 2, 2017

What else should be on here? Any other niche tools?

Feb 2, 2017

http://www.askivy.net/ very good for london bankers

got a nice headhunters list on there :-)

    • 1
Mar 26, 2019

Bamsec saves me hours each month - I hate edgar and Factset is much slower

Feb 9, 2017

For the folks at smaller shops without access to proprietary Excel modeling tools. The Turbo Training the Street (TTS) plugin is fairly good for Excel modelling hotkeys / formatting if your firm doesn't provide you with a similar add-in (I'm using it while I wrap up business school).

    • 2
Feb 9, 2017

@ConsultingQuant have you used any of the other tools above (logointern, bamsec, etc.) or the macabacus addins?

Feb 23, 2017

I haven't @babymonkey357 - honestly, should have used logo intern in the past but just didn't know about it. I've generally just used SEC EDGAR for filings, you can also get the same excel download there. The advantage of BAM SEC seems to be the ability to search across company filings, and I honestly just haven't needed that functionality in my prior roles. As far as macabacus add-ins, I think the TTS plugin is probably comparable.

For charts in PPT, I've used the thinkcell plugin as well. It's aggravating in that it seems to suck up processor speed (slow to move around), but relatively intuitive from a user interface perspective for formatting.

    • 3
Feb 23, 2017

What does Logo Intern's pricing look like? That would have been great to have in IB, but I doubt bankers would want to pay for it.

Feb 23, 2017

Its free dude. There doesn't seem to be a paid version yet like BamSEC

    • 1
Feb 23, 2017

Awesome. Almost, but not really, makes me wish I was back in banking so that I could use it.

    • 1
Feb 23, 2017

I am a big fan of the macabacus plug-in for Excel - convinced my shop to buy it for me when I first joined, it's relatively inexpensive and saves a ton of time. You can setup your own custom shortcuts and it has an awesome trace precedents/dependents tool (with ability to evaluate functions and groups, and even offsets).

I know two buddies whose shops have actually started buying macabacus pro for all of their associates now.

    • 1
Feb 23, 2017

You use any of the free tools / any free resources to add?

I'm a big fan of the macabacus modeling guides - best quality on the street and free.

Feb 23, 2017

Only free tool I use that could be of value to you guys is FINRA's bond price lookup tool. You can use this to lookup bond prices and yields without a Bloomberg terminal (although functionality is very limited). I use this a lot when I'm on the road.

http://finra-markets.morningstar.com/BondCenter/De...

Feb 23, 2017

asimplemodel.com is a pretty good start for the most basic modelling stuff... it's a fantastic starter before you dig into macabacus.

Feb 23, 2017

It doesn't look free :(

Feb 24, 2017

Most videos on the site are free (the only ones that aren't are the quizzes and a select few about deeper modelling stuff which is found on macabacus anyway). It's honestly a great start, I used it because I found macabus quite challenging at first and it worked pretty well in giving me a basic understanding of modelling

Mar 1, 2018

I am using FinPricing tool for trading, hedging and risk management. It is free now.

Best Response
Mar 1, 2018

Smh, apparently most analysts don't even do anal

    • 5
Mar 1, 2018

Alas, neither do most 8 year olds :(

    • 1
Aug 21, 2018

Any updates to this? Seems like banks are starting to get a little better about analyst efficiency stuff.

Aug 22, 2018

Logointern add-in has been a big help. We recently got that installed.

I've heard of groups looking at tombstone offerings, but haven't seen anything myself.

    • 1
Sep 11, 2018

Bump - JPM just announced some new digital banking group. Anyone know if this is a real thing?

Sep 11, 2018
    • 1
Nov 2, 2018

Heard they're building new tools internally

Nov 4, 2018

Logointern and Bamsec are $$$

SB for you

    • 1
Nov 5, 2018

You can't just download it, but DealSite. Major and long overdue timesaver.

    • 1
Nov 6, 2018

What about all these AI tools that always seem to be just around the corner. Do any actually exist, either inhouse/proprietary to a firm, or made by third parties? And are they any good?

Nov 6, 2018

Bump interested in this as well

Feb 8, 2019

My bank is partnering with some tech company to explore developing some new CRM system for bankers... basically our current CRM is crap and they got it set up ~18 months ago after a hefty review process and everyone hates it.

Feb 9, 2019

Hey send me a PM - would be curious to hear what you have in the works. We're on Salesforce but are looking to switch - we waste so much time navigating Salesforce, etc.

    • 1
Oct 17, 2019
Comment
Oct 30, 2019