Yahoo FinanceNotion

Log a daily stock snapshot to Notion

A Yahoo Finance + Notion agent flow

An analyst or a finance-curious team keeps a watchlist and wants a dated record of where each name stood, not just whatever the live ticker shows now. Pulling it by hand into a doc each day doesn't happen. The agent reads a snapshot for each ticker with get_stock_info, price and the valuation metrics that come with it, and writes a Notion page per ticker per day with notion-create-pages. Yahoo Finance answers the agent's call, so this runs on a schedule, once at market close, and each run leaves a fresh dated row in your Notion database to look back on.

The flow

Yahoo Financeget_stock_info

Returns a comprehensive snapshot of a stock: price, valuation metrics, and company details.

Notionnotion-create-pages

Creates one or more Notion pages with specified properties and content.

Step by step

  1. Set the watchlist and the database

    List the tickers the agent reads and point it at a Notion database with properties for ticker, date, price, and the metrics you track. Decide when it runs, typically after the close.

  2. Read each snapshot

    For each ticker the agent calls get_stock_info, reading the current price along with valuation metrics like market cap and P/E and the company details the snapshot includes.

  3. Write a Notion page per ticker

    The agent calls notion-create-pages with one page per ticker, setting the ticker, the date, the price, and the metrics as properties, so each day's read is its own dated record.

  4. Key each entry to the day

    Tag each page with ticker plus date so a re-run doesn't overwrite or duplicate the day's snapshot. The agent skips a ticker it already logged for today.

Tell your agent

Every weekday at 4:30pm Eastern, read a snapshot for AAPL, MSFT, and NVDA from Yahoo Finance. For each, create a Notion page in the Watchlist database with the ticker, today's date, the price, market cap, and P/E. Don't create a second page for a ticker already logged today.

Setup

This flow needs both servers connected to your agent. Follow each install guide:

Worth knowing

  • get_stock_info returns a point-in-time snapshot at the moment of the call, so the value depends on when the agent runs. Pin it to a consistent time, like the close, if you want comparable daily rows.
  • Some metrics are missing or null for certain tickers, ETFs and ADRs in particular. Have the agent write what's present rather than failing the page when a field like P/E is absent.
  • notion-create-pages writes into a database whose properties must match the values the agent sets. Confirm the property names and types once so price lands in a number column, not as text.

Questions

Does this give me intraday prices?
No. It logs one snapshot per run at the time the agent reads get_stock_info. For an intraday series you'd schedule more frequent runs or use the historical-price tool instead.
Can it cover a long watchlist?
Yes. The agent loops the tickers and reads each with get_stock_info, then writes the pages. notion-create-pages can take several pages at once, so a watchlist of twenty is a handful of calls per run.