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.