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

Justin Pauley

買這商品的人也買了...

商品描述

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

商品描述(中文翻譯)

投資者認識到科技是一個強大的工具,可以獲取和解讀金融數據,這可能給他們在華爾街上所追求的一個優勢。然而,許多人並不意識到,你不需要成為一名程式設計師就能夠從彭博社、IHS Markit或其他大多數銀行和投資公司的系統中獲取幕後的金融信息。

這本實用指南教導分析師一個有用的Excel技能子集,使他們能夠在沒有任何編程經驗的情況下訪問和解讀金融信息。本書將逐步向分析師展示如何快速製作專業報告,將他們的觀點與彭博社或Markit的數據相結合,包括歷史財務數據、比較分析和相對價值。對於投資組合經理來說,本書演示了如何創建包含投資組合績效、增長、風險調整回報和組成的高層次摘要報告。如果你是一名程式設計師,本書還包含了使用C#進行相同主題的平行路徑。

主題包括:

- 獲取在彭博社屏幕上看不到的其他數據
- 創建包含公司數據的表格,使得可以對比多家公司、債券或貸款
- 為個別公司建立一頁分析報告(“Tear Sheet”),包括重要財務數據、自定義註釋、與同行公司的相對價值比較以及研究分析師的價格趨勢目標
- 創建包含投資組合績效、增長、風險調整回報和組成的兩頁投資組合摘要報告
- 探索可交易公司債券和貸款市場的每日價格和設施信息
- 使用相關性和回歸來確定兩個證券(或指數)之間的關係
- 將每個證券的表現與具有相似風險和回報特徵的證券組合進行比較
- 通過計算變異數、標準差和夏普比率來衡量投資組合的風險調整回報
- 使用Markit數據識別價格、新發行價差和再融資方面的有意義的趨勢