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.
This formula populates your spreadsheet with the news headlines for the specified 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:
This formula populates your spreadsheet with the news articles for the specified ticker:
This formula populates your spreadsheet with the news headline for the specified ticker and index: