O'Reilly logo

Unlocking Financial Data by Justin Pauley

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required


If you’re opening this book at a bookstore and trying to determine if it’s for you, let me help:

  • This book will help you combine your views with financial data from Bloomberg—you don’t need access to Bloomberg, but it is highly recommended—and IHS Markit, analyze the results, and generate professional reports using Microsoft Excel without any programming or assistance from your IT department.

  • This book will show you, step by step, how to quickly produce professional reports that enhance your views with market data including historical financials, comparative analysis, and relative value.

  • For portfolio managers, this book demonstrates how to generate a professional portfolio summary report that contains a high-level view of a portfolio’s performance, growth, risk-adjusted return, and composition.

  • If you are a programmer, or potential programmer, this book contains a parallel path that covers the same topics using C#.

  • I am not an academic, and there is a reason “Practical” is in the subtitle of the book. All you need is a basic understanding of finance and Excel. You don’t need to know any programing, VBA, or advanced math.

To understand why I am writing this book, it helps to understand my background. I’ve always loved computer science, and it was no surprise that my first job was programming for Wachovia (now Wells Fargo). However, very early in my career, I realized something important that would lead me down a very different career path. I realized that my ability to use technology for accessing and analyzing data is more valuable in other fields, particularly finance, than as a programmer in the IT department.

After spending three years as a programmer, I moved over to the bank’s research group and used my computer science skills to tap into the vast wealth of market and internal information that would be otherwise inaccessible. These skills gave me a big advantage over other analysts, and I left my research role as a director at the Royal Bank of Scotland to become a senior structured credit analyst at Brigade Capital Management, an asset manager based in New York. At Brigade, I still use my technical skills to get an advantage in valuing investments.

Over the course of my career, I have taught many colleagues a useful subset of these technical skills. In teaching them, I’ve learned that you can do a lot of useful analysis that goes above and beyond Bloomberg screens, all without knowing how to program. All you need is something most people who are employed in the finance sector already have: analytical minds and Excel experience (and this book, of course).

For my fellow programmers, this book has you covered as well. Instead of trying to track down API documentation and reinventing the wheel, this book contains a lot of useful C# examples on how to access market data from Bloomberg and IHS Markit, perform financial analysis using Math.Net open source libraries, and use SQL Server Reporting Services (SSRS) to automate professional reports.

I wanted to write a book to teach these skills to a broader audience and help people use technology to move their resume to the top of the stack.

Conventions Used in This Book


Many of the code lines in this book have been broken across multiple lines because of the display limits of the page. These breaks are not needed if you are running the code on your system.

The following typographical conventions are used in this book:


Indicates new terms, URLs, email addresses, filenames, and file extensions.

Constant width

Used for program listings, as well as within paragraphs to refer to program elements such as variable or function names, databases, data types, environment variables, statements, and keywords.

Constant width bold

Shows commands or other text that should be typed literally by the user.

Constant width italic

Shows text that should be replaced with user-supplied values or by values determined by context.


This element signifies a general note.


This element indicates a warning or caution.

Using Code Examples

Supplemental material (code examples, exercises, etc.) is available for download at http://bit.ly/unlockFD_examples.

This book is here to help you get your job done. In general, if example code is offered with this book, you may use it in your programs and documentation. You do not need to contact us for permission unless you’re reproducing a significant portion of the code. For example, writing a program that uses several chunks of code from this book does not require permission. Selling or distributing a CD-ROM of examples from O’Reilly books does require permission. Answering a question by citing this book and quoting example code does not require permission. Incorporating a significant amount of example code from this book into your product’s documentation does require permission.

We appreciate, but do not require, attribution. An attribution usually includes the title, author, publisher, and ISBN. For example: “Unlocking Financial Data by Justin Pauley (O’Reilly). Copyright 2018 Justin Pauley, 978-1-491-97325-7.”

If you feel your use of code examples falls outside fair use or the permission given above, feel free to contact us at .

O’Reilly Safari


Safari (formerly Safari Books Online) is a membership-based training and reference platform for enterprise, government, educators, and individuals.

Members have access to thousands of books, training videos, Learning Paths, interactive tutorials, and curated playlists from over 250 publishers, including O’Reilly Media, Harvard Business Review, Prentice Hall Professional, Addison-Wesley Professional, Microsoft Press, Sams, Que, Peachpit Press, Adobe, Focal Press, Cisco Press, John Wiley & Sons, Syngress, Morgan Kaufmann, IBM Redbooks, Packt, Adobe Press, FT Press, Apress, Manning, New Riders, McGraw-Hill, Jones & Bartlett, and Course Technology, among others.

For more information, please visit http://oreilly.com/safari.

How to Contact Us

Please address comments and questions concerning this book to the publisher:

  • O’Reilly Media, Inc.
  • 1005 Gravenstein Highway North
  • Sebastopol, CA 95472
  • 800-998-9938 (in the United States or Canada)
  • 707-829-0515 (international or local)
  • 707-829-0104 (fax)

We have a web page for this book, where we list errata, examples, and any additional information. You can access this page at http://bit.ly/unlockingFinancialData_1e.

To comment or ask technical questions about this book, send email to .

For more information about our books, courses, conferences, and news, see our website at http://www.oreilly.com.

Find us on Facebook: http://facebook.com/oreilly

Follow us on Twitter: http://twitter.com/oreillymedia

Watch us on YouTube: http://www.youtube.com/oreillymedia


This book is dedicated to my incredibly supportive and amazing wife, Emily Pauley. Very special thanks to those of you who have been especially generous with your time and support; I couldn’t have done this without you (in no particular order): Alex Belgrade, Scott Moore, Jeana Curro, Dan Bleicher, Matt Perkal, Sumit Sablok, and Tom O’Shea.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required