September 2018
Beginner to intermediate
282 pages
6h 24m
Chinese
Content preview from 解密金融数据
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
22
第 3 章
彭博
Bloomberg Professional（也称为彭博终端）是金融分析师最有用的工具之一。然而，
尽管彭博终端本身有许多功能，但是其灵活程度和分析能力不及 Microsoft Excel 和
Access。在本章中，我们用彭博提供的金融数据结合 Excel、Access 的灵活性，创建一
个强大的分析工具。此外，彭博有 Excel Add-in 函数，还有完整的 .NET API，方便获取
其金融数据。
我们将探索 Excel Add-in 和 .NET API 的常用特性；对于其他特性请查阅 DAPI<GO> 上
的彭博文档。
从彭博获取的数据是供个人使用的。扩散这些数据可能违反服务使用规
则。此外，每天或每月能从彭博获取的有价证券和字段数量是有限制的。
想获得更多信息，请参见彭博文档（DAPI<GO>）或咨询彭博业务代表
（BREP<GO>）。
在开始前需要发出一点警告： 尽管彭博公司会甄别验证数据，但是仍然有些彭博信息可
能是不正确的。然而，这不能成为你的分析不正确的理由。在本书后面，我们将讨论从
大数据集合中识别和剔除不良数据的技术，但是只能手动审查数据以保证准确性，没有
别的办法。如果你认为一些彭博数据不正确，请联系 Bloomberg Help，以便该公司为你
和其他用户修补数据。尽管如此，不要让数据可能不正确的想法吓坏你，不正确数据是
小概率事件，而且在处理金融数据时，如果你想事事完美，那么可能一事无成。
3.1 确定字段
将彭博数据放入 Excel 或其 API 的第一步是，确定你想获取什么字段。幸运的是 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.