Claude Code reads a trade log, writes and runs Python, pulls live Yahoo Finance data and exports Robinhood trade history to build an Excel portfolio tracker.
Claude Code reads a trade log, writes and runs Python, pulls live Yahoo Finance data and exports Robinhood trade history to build an Excel portfolio tracker.
The author gives Claude Code the path to an Excel Trade_Log, the starting capital and the start date. He tells it to use Excel formulas rather than hardcoded values. Claude reads the log, pulls prices and company data through yfinance, and builds the workbook sheets. The user then checks that the formulas recalculate. Broker pulls (including Robinhood via robin_stocks) and a daily update script are follow-up prompts.
The guide describes a workbook with a dashboard, positions, equity curve, risk metrics and stress tests. It gives no measured results. It admits Claude will sometimes hardcode values or misunderstand, and the user then has to tell it to fix them.
Claude Pro is $20/month, and heavy builds may hit usage limits (Max is $100). Write the output to a new file, and change a price to confirm the formulas update.
I have a trade log at [file path, e.g. a CSV exported from my broker]. Write and run Python that reads it, pulls current prices from Yahoo Finance, and builds an Excel portfolio tracker showing each position's cost basis, current value, gain/loss, and allocation. Save it as [filename].xlsx in this folder and tell me how to refresh it. Don't log into any account or change anything; work only from the exported file.
An app built with Claude Code extracts vendor, date, total, tax and line items from receipts, including foreign-currency ones at historical exchange rates, for freelancers and small businesses.
A tenant used ChatGPT and Gemini to review a landlord's apartment deposit dispute, identify legal violations, and avoid losing $4,200.
The poster used an AI assistant to summarize a denial PDF to draft an appeal, but it invented an appeal deadline.