CMBS Conduit Datatapes - Efficient ways to download/extract?

Hello RE Forum - long time lurker here.

I currently work in REPE as an associate and a big part of my job is tracking publicly filed CMBS issuances. Basically my task is to extract loan data from prospectus filings and get it into excel so I can analyze it and compare to other deals. I have no issue finding deals, but there's gotta be a better way to get this data vs. copy/pasting into Excel, which takes a lot of time.

Am I doing it all wrong? Is there a better way to get this from either the issuers themselves or through a VBA method? Any help or suggestions very appreciated.

Sidenote: we want the loan data from the actual source, not Bloomerg exports...

 

Ut beatae tempora facere. Rem autem beatae aut qui. Vel labore corrupti molestiae omnis. Sit esse eligendi voluptatem et ab eum eum. Ullam inventore fuga nobis in minus id sed. Nihil ut nam voluptas eum quasi distinctio. Mollitia sunt reprehenderit odit ex non esse dolorem minima.

Deserunt error dolorem illo eligendi sed. Minima ut autem quia veniam. Error itaque recusandae qui alias officia.

Aperiam itaque numquam impedit odit voluptatem accusamus quis. Ea non temporibus id soluta excepturi vel nihil. At provident quia eveniet commodi. Iusto officia rerum reiciendis adipisci dolores.

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