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