如何从Bloomberg Terminal抓取指定搜索条件的新闻内容?
Got it, let's walk through practical ways to grab news headlines and content from Bloomberg Terminal since the standard API doesn't cover this use case—your existing terminal access opens up several workable paths:
Leverage Terminal's Native Export Tools
First, pull up your target news feed usingNI MICROSOFT(or your specific search terms) in the terminal. Most news interfaces have an export option (look for an "Export" menu item or use terminal-specific shortcuts) that lets you save results to CSV/Excel. You can usually include headlines, publication timestamps, content snippets, and in some cases full article text—just double-check your access permissions for full content exports. For bulk feeds, this is the quickest low-code option.Use the Bloomberg Excel Add-In
The Bloomberg Excel plugin (powered by BLPAPI) has underutilized functions for news data:- Use
BDS("NI MICROSOFT", "NEWS_HEADLINES")to pull a list of relevant news headlines along with unique story IDs. - Pair that with
BDP("<STORY_ID>", "NEWS_STORY")to fetch the full text of individual articles.
This method lets you automate bulk scraping directly in Excel, which is great if you need to structure data into spreadsheets for your project.
- Use
Automate Terminal UI with Scripting
If you need more control, you can script terminal interactions:- VBA: Bloomberg Terminal supports VBA macros. You can write code to open the
NIinterface, input your search terms, iterate through news entries, extract text, and save outputs. Check Bloomberg's internal documentation for VBA hooks specific to news modules. - Python: Use libraries like
pywin32to control the terminal window, simulate keyboard shortcuts, and scrape text from the UI. Note that this method depends on your terminal's UI layout (so it might break with updates) and requires strict adherence to Bloomberg's usage policies to avoid account restrictions.
- VBA: Bloomberg Terminal supports VBA macros. You can write code to open the
Inquire About Enterprise News API Access
While the standard BLPAPI doesn't include news, Bloomberg offers a dedicated Enterprise News API for enterprise clients. Reach out to your Bloomberg account manager or support team to ask if your organization has access to this API, or if you can request it for your project. This is the most scalable option if you need ongoing, programmatic access to news data.
Important note: Always ensure your usage complies with Bloomberg's Terms of Service—avoid overloading the terminal with automated requests or accessing content outside your authorized scope.
内容的提问来源于stack exchange,提问作者An Le




