Getting Started
- Introduction
- Download
- Installation & Activation
- Troubleshooting
- Data Refresh/Updates
- Software Updates
- Manage Your Subscription
- Example Spreadsheets
General Formulas
Technical Analysis Toolkit
- Introduction
- Simple Moving Average (SMA)
- Exponential Moving Average (EMA)
- Volume Weighted Average Price (VWAP)
- Average True Range (ATR)
- Bollinger Bands
- Aroon
Yahoo Finance
IG Index / IG Markets
- Account Setup
- Formula Reference
- VBA Functions Reference
- Historical Price Data Download To Excel
- Historical Price Data Download To File
- Historical Client Sentiment Data Download
- Watchlists
- Live Positions, Transactions & Activity History
EODHistoricalData.com
Nasdaq Data Link
Excel Formula Reference: News
The Add-in provides Excel formulas for retrieving news headlines and news articles from Yahoo Finance.
All of the news formulas require a ticker/symbol, which can be a ticker for any instrument covered by Yahoo Finance, for example stock indices, commodities etc.
EPF.Yahoo.News.Headlines
This formula populates your spreadsheet with the news headlines for the specified ticker:
=EPF.Yahoo.News.Headlines(ticker)
For example here are the top 3 news headlines for Apple stock today:
And here are the news headlines for Apple in Excel using the Excel Price Feed formula:
EPF.Yahoo.News
This formula populates your spreadsheet with the news articles for the specified ticker:
=EPF.Yahoo.News(ticker)
EPF.Yahoo.News.Headline
This formula populates your spreadsheet with the news headline for the specified ticker and index:
=EPF.Yahoo.News.Headline(ticker, index)