The Scenario
You trade 20 names actively and your morning process involves checking news before the market opens. The workbook with your watchlist is already open. The problem is that your current process is: open Benzinga, search ticker 1, skim headlines, open ticker 2 in a new tab, skim headlines, repeat — and by the time you've gone through all 20 you've spent 25 minutes on something that should take five.
The third time you did this last week you missed a pre-market earnings surprise on a name you were holding because you ran out of time before the open.
The bad version:
- Open Benzinga's news feed, filter to your first ticker, copy the headline, date, and URL for the top 5 articles into a staging area.
- Do the same for all 20 tickers, maintaining a separate copy buffer for each one.
- Paste into the workbook, realize the URLs didn't carry over because you copied from the rendered text instead of the actual link, and go back to get them.
The open is in 45 minutes. There is no clean version of this that fits in the time you have.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your watchlist and, through its built-in Benzinga integration, fetches recent news articles for every ticker in one shot — headlines, dates, channels, and URLs, all written directly into the workbook.
Pull the most recent Benzinga news items for tickers listed in column A of my Excel sheet and write article title, date, and URL into columns B, C, and D — one row per article
What You Get
- For each ticker: up to 5 rows of news, with article title in column B, publication date in column C, and full article URL in column D
- A blank row separating each ticker's block for readability
- Tickers with no recent news get a single row noting "No recent articles found"
What If the Data Is Not Quite Ready
What if some tickers in column A are ETFs that generate hundreds of articles and I want to limit to the last 48 hours only?
Pull Benzinga news articles published in the last 48 hours for each ticker in column A of my Excel sheet — limit to 5 articles per ticker — and write article title, publication date, and URL into columns B, C, and D
What if I want articles from specific Benzinga channels only (e.g., "Earnings" and "Markets")?
Pull the latest 5 Benzinga news articles for each ticker in column A of my Excel sheet, filtered to the "Earnings" and "Markets" channels only, and write article title, publication date, channel, and URL into columns B through E
What if my watchlist spans two worksheets — "Core" and "Speculative" — and I want news for all of them combined in one output worksheet?
Pull the latest 5 Benzinga news articles for each ticker in column A of my "Core" worksheet and column A of my "Speculative" worksheet. Combine all results into a new worksheet called "Morning Brief" with columns for ticker, article title, publication date, channel, and URL — sorted newest article first overall
What if I want the headlines plus each ticker's current analyst consensus rating in the same briefing table?
For each ticker in column A of my Excel sheet, pull the latest 3 Benzinga news headlines and the current Benzinga consensus rating and price target average. Write ticker, article title, date, URL, consensus rating, and target average into columns A through F — one row per article, with consensus data repeated on each row for that ticker
Running the news pull and the consensus lookup in a single prompt means you get the full morning briefing in one shot.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with your trading watchlist in column A, then ask it to pull your pre-market news digest before the next open. The article on pulling earnings calendar data covers the other pre-market data feed that rounds out the daily brief.