← All guides

Guide

Keep a stock watchlist in Google Sheets without IMPORTXML

November 2026 · 3 minute read

The usual way to get Yahoo Finance prices into a spreadsheet is an IMPORTXML formula, and it keeps breaking: Yahoo changes its page layout, the formula returns #N/A, and funds or foreign tickers never worked in the first place. GOOGLEFINANCE covers fewer exchanges and has no company profiles. This guide fills a sheet with one row per ticker every weekday: price, change, valuation figures and the company’s sector and industry, for any exchange Yahoo Finance covers.

This guide uses our Yahoo Finance Scraper on the Apify Store. Every step works with a free Apify account.

What you’ll end up with

A sheet that gains one row per ticker each day:

scrapedAtsymbolnamepricechangePercentpriceTimemarketCaptrailingPEdividendYieldPercentsector
2026-11-20AAPLApple Inc.………………Technology
2026-11-20VOD.LVodafone Group………………Communication Services

Prices are at least 15 minutes old, and priceTime says exactly when each one is from. It’s for watchlists and research, not for trading.

1. Write your tickers the way Yahoo Finance does

2. Set up the run

  1. Open Yahoo Finance Scraper on Apify (its Apify Store page) and click Try for free. A free Apify account comes with monthly credit.
  2. Paste your tickers into Tickers, one per line. Leave Include company profile on: it’s included in the price.
  3. Click Start. A 50-ticker run takes under a minute. Open the Delayed quotes view to check it.
  4. Click Save as a new task and name it, for example “Watchlist”.

Cost: one row per ticker with a price. A 200-ticker watchlist every weekday is about 4,400 rows a month. The Actor’s Pricing tab has the price per row; tickers that aren’t found are free.

3. Run it on a schedule

In Apify Console, open Schedules → Create new and add your task:

4. Send the rows to Google Sheets or Excel

5. Useful formulas

Going further

The Actor reads the public Yahoo Finance quote pages only, never real-time data, and collects company facts, not people: officers, executives and their pay are never read.

Need data from another public source, or a different setup? Get in touch.