Stock Events for Google Sheets lets you pull your portfolio data directly into spreadsheets using custom functions. A Stock Events Pro account is required to use this add-on.

After signing in, you can use the following functions:

Market Data
- STOCKEVENTS_STOCK_PRICE(ticker) — Current market price
- STOCKEVENTS_STOCK_CHANGE(ticker) — 24h price change percentage
- STOCKEVENTS_STOCK_DIVIDEND_YIELD(ticker) — Annual dividend yield
- STOCKEVENTS_STOCK_NAME(ticker) — Company name

Dividends
- STOCKEVENTS_DIVIDENDS_INCOME(portfolio) — Projected annual dividend income
- STOCKEVENTS_DIVIDENDS_YIELD_ON_COST(portfolio) — Dividend yield on cost basis
- STOCKEVENTS_DIVIDENDS_YIELD(portfolio) — Current weighted dividend yield

Holdings
- STOCKEVENTS_HOLDINGS_VALUE(portfolio) — Total portfolio market value
- STOCKEVENTS_HOLDINGS_GAIN(portfolio) — Total unrealized gain/loss
- STOCKEVENTS_HOLDINGS_LIST(portfolio) — List of all ticker symbols

Positions
- STOCKEVENTS_POSITION_VALUE(ticker; portfolio) — Position market value
- STOCKEVENTS_POSITION_SHARES(ticker; portfolio) — Number of shares held
- STOCKEVENTS_POSITION_GAIN(ticker; portfolio) — Position unrealized gain/loss
- STOCKEVENTS_POSITION_AVG_COST(ticker; portfolio) — Average purchase price

All values update automatically every 10 seconds. Numbers are returned as raw values so you can apply your own formatting.