News Feeds
The SF_NEWS() function hooks your spreadsheet into the latest news feeds for stocks, crypto, and FOREX/commodities. The function allows you to pull the latest news articles for a given symbol or collection of symbols (see News Feed Batch). Additionally you can filter the feed by a combination of providers and instantly access the URL links to each article.
=SF_NEWS(symbol(s), type, limit, metrics, site, startDate, endDate, options)symbol(s)is the ticker symbol of the financial asset (e.g.,"AAPL"). You can use our Symbol Search to find the correct ticker symbol. You can also use a range of cells e.g.A1:A10to pull news for multiple symbols, see News Feed Batch.typeselects the type of news feed to pull. The options are"stocks","crypto"or"forexAndCommodities". Defaults to"stocks".limitsets the number of news articles to pull. Defaults to10. Limits are plan dependent check our pricing page for more information.metricsselects what metrics to display (see options below), display all metrics by leaving blank or using"all". Chain together as many metrics as you'd like using&, e.g.,"publishedDate&url".siteOPTIONAL filters the news feed by specific source sites (e.g."barrons.com"), you can chain together multiple sites using&, e.g.,"barrons.com&cnbc.com".startDateOPTIONAL sets the starting date of the news feed, written in iso format YYY-MM-DD, e.g."2022-01-01". Only applicable for"stocks"type.endDateOPTIONAL sets the ending date of the news feed, written in iso format YYY-MM-DD, e.g."2022-01-10". Only applicable for"stocks"type.optionsOPTIONAL adjusts the formatting of the output. Available options are"NH"for no header row and"-"for descending order. You can chain together multiple options using&, e.g.,"NH&-".
Important:
Data is sourced prior to filtering, so the number of articles returned may be less than the limit set if the filter criteria are too restrictive. Additionally, when accessing multiple symbols the limit is applied to the total number of articles returned, not per symbol, therefore if certain symbols do not have any recent articles in the returned feed then they will not be displayed.
Stocks/equity data is currently only available for US stocks.
Metrics
The news metrics options are:
All (
"all")Published Date (
"publishedDate")Publisher (
"publisher")Site (
"site")Title (
"title")Text (
"text")URL (
"url")
Examples
Example 1 - Display latest 10 articles for AAPL
=SF_NEWS("AAPL")
Example 2 - Display latest 10 articles for BTC
=SF_NEWS("BTCUSD", "crypto")
Example 3 - Display latest 20 articles for AAPL with selected metrics
=SF_NEWS("AAPL", "stocks", 20, "publishedDate&site&title&url")
Example 4 - Display latest 10 articles, then filter by sites
=SF_NEWS("AAPL", "stocks", 20, "all", "barrons.com&seekingalpha.com&reuters.com&marketwatch.com")
Example 5 - Display latest 10 articles for AAPL between specific dates (only available for stocks)
=SF_NEWS("AAPL", "stocks", 10, "all", "", "2022-01-01", "2022-01-10")