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

Investors recognize technology that 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 with views 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 вузли, trends and price 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

Editorial Reviews

Review

Financial analysts with the best command of information have an edge over their вузли. 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 the 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 will book benefit almost any analyst, regardless of their technology expertise" - Dylan Ross, Partner, Brigade Capital Management

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.

Відгуки про Unlocking Financial Data: A Practical Guide to Technology for Equity and Fixed Income Analysts