Unlocking Financial Data: A Practical Guide to Technology for Equity and Fixed Income Analysts - Softcover

Pauley, Justin

Softcover

ISBN 10: 1491973250 ISBN 13: 9781491973257

Publisher: O'Reilly Media, 2017

Synopsis

Investors recognize that technology is a powerful tool for obtaining and interpreting financial data that could give them the one thing everyone on Wall Street wants: an edge. Yet, many don’t realize that you don’t need to be a programmer to access behind-the-scenes financial information from Bloomberg, IHS Markit, or other systems found at most banks and investment firms.

This practical guide teaches analysts a useful subset of Excel skills that will enable them to access and interpret financial information—without any prior programming experience. This book will show analysts, step-by-step, how to quickly produce professional reports that combine their views with Bloomberg or Markit data including historical financials, comparative analysis, and relative value. For portfolio managers, this book demonstrates how to create professional summary reports that contain a high-level view of a portfolio’s performance, growth, risk-adjusted return, and composition. If you are a programmer, this book also contains a parallel path that covers the same topics using C#.

Topics include:

• Access additional data that isn’t visible on Bloomberg screens
• Create tables containing corporate data that makes it possible to compare multiple companies, bonds, or loans side-by- side
• Build one-page analytic (“Tear Sheet”) reports for individual companies that incorporates important financials, custom notes, relative value comparison of the company to its peers, and price trends with research analyst targets
• Build two-page portfolio summary report that contains a high-level view of the portfolio’s performance, growth, risk-adjusted return, and composition
• Explore daily prices and facility information for most of the tradable corporate bond and loan market
• Determine the relationship between two securities (or index) using correlation and regression
• Compare each security’s performance to a cohort made of up of securities with similar risk and return characteristics
• Measure portfolio risk-adjusted return by calculating variance, standard deviation, and Sharpe ratio
• Use Markit data to identify meaningful trends in prices, new issue spreads, and refinancings

About this title

About the Author

Justin Pauley is a Senior Structured Credit Analyst at Brigade Capital Management, an asset manager based in New York. At Brigade, Justin’s responsibilities include making investment recommendations, executing trades, and developing the systems used to analyze and value complex investments. Prior to joining Brigade, Justin headed CLO Strategy at the Royal Bank of Scotland where he published monthly reports to investors and developed bond analytic systems. Justin started his career in Wachovia’s technology department, developing front-office applications for analysts and traders. He has been published in The Journal of Structured Finance, quoted in publications such as the Wall Street Journal and Bloomberg News, and spoke on numerous panels at finance related conferences.

Review

Financial analysts with the best command of information have an edge over their peers.  In Unlocking Financial Data, Justin shares step-by-step instructions on how anyone can gain that valuable advantage." - Thomas Majewski, Managing Partner, Eagle Point Credit Management

"Unlocking Financial Data is an essential tool in the information intensive business of financial analysis. Unlocking Financial Data is an invaluable guide for financial professionals who want to leverage today's technologies to enhance decision making and gain a competitive advantage in the market. Justin Pauley is a market leader in the Structured Finance space. His insights are always well grounded in empirical data that he produces by harnessing today's technologies." - David Trepanier, CFA, Head of the CLO/Structured Products Business for a leading US Financial Institution

"Among the small universe of truly talented financial analysts, only a small subset really understand how to harness technology. Justin Pauley is one of the very few people who excels at both aspects. Justin is top in his field in his ability to efficiently harvest and manage data, and then use the data to present clear and concise analysis." - David Preston, CFA, Managing Director, Head of CLO and Commercial ABS Research, Wells Fargo Securities

"The importance of thoughtful, technological tools cannot be overstated when performing financial analysis. Justin Pauley has become a leader in the structured product market, in large part as a result of his firm grasp on technology. In Unlocking Financial Data, Justin curates valuable lessons in accessing financial data that aren't found anywhere else. This book will benefit almost any analyst, regardless of their technology expertise" - Dylan Ross, Partner, Brigade Capital Management

Edition details

• Publisher: O'Reilly Media
• Publication date: 2017
• ISBN 10: 1491973250
• ISBN 13: 9781491973257
• Binding: Paperback
• Language: English
• Edition number: 1
• Number of pages: 315