Log daily closing prices for your tickers

from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from datetime import date
from clickruntime import on_trigger, credentials, http, ai, notify

SHEET_ID = "your-spreadsheet-id"

@on_trigger
def run(event):
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets()
    tickers = [r[0] for r in sheets.values().get(spreadsheetId=SHEET_ID, range="Watchlist!A2:A").execute().get("values", []) if r]
    key = credentials.secret("FINNHUB_API_KEY")
    rows, movers = [], []
    for t in tickers:
        q = http.get("https://finnhub.io/api/v1/quote", params={"symbol": t, "token": key}).json()
        rows.append([date.today().isoformat(), t, q["c"], q["dp"]])
        if abs(q["dp"]) > 3:
            movers.append(f"{t}: {q['c']:.2f} ({q['dp']:+.1f}%)")
    sheets.values().append(spreadsheetId=SHEET_ID, range="Prices!A:D", valueInputOption="USER_ENTERED",
                           body={"values": rows}).execute()
    if movers:
        note = ai.generate("Write two or three sentences on today's big moves:\n" + "\n".join(movers), max_output_tokens=200).text
        notify.email_me(f"{len(movers)} big movers today", note + "\n\n" + "\n".join(movers))
    return {"logged": len(rows), "movers": len(movers)}