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
get_stock_infoReturns a comprehensive snapshot of a stock: price, valuation metrics, and company details.
notion-create-pagesCreates one or more Notion pages with specified properties and content.
Step by step
- 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.
- 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.
- 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.
- 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.