Import Yahoo Financial News into Google Sheets with OS_YAHOO_FINANCE
Introduction
If you're looking for a speedy way to incorporate Yahoo Financial News into your Google Sheets, you've come to the right place. With the help of the custom function OS_YAHOO_FINANCE, you can seamlessly import the latest RSS feeds from Yahoo Financial News for any tickers, irrespective of their country of origin. Moreover, you have the flexibility to tailor the results by selecting the preferred number of posts or specifying a publication date range.
Installation
Install from Google Workspace Marketplace
YouTube
If you're more of a visual learner, watch this video for step-by-step instructions. While you're there, consider subscribing to my channel for future updates and content.
Demo Use Case
In this demonstration, we're extracting the latest news articles associated with the ticker symbol "GOOG" within the past 24 hours.
Example
PR_YAHOO_FINANCE("GOOG,AAPL", "1d", TRUE)
About
Import Yahoo Financial News.
tickers
Comma separated tickers.
filter
Use number for posts e.g. 3, number + "d" for publication date e.g. "1d", default to "1d".
include_headers
Whether to include column headers as an extra row on top of the returned value.
OneScript Custom Functions (Follow for More Updates)
Links
Hire Me on Upwork Donate YouTube Github Twitter / X Instagram Upwork Projects
Comments
Post a Comment