Scan a watchlist and update it in a sheet
An investor used Perplexity Comet to review a stock watchlist, pull tariff-related names, and draft additions for a Google Sheet.
- What they did
- The investor opened Perplexity Comet and gave it plain-English tasks across several browser tabs. It checked the watchlist for Swiss companies affected by U.S. tariffs, then condensed commentary from Goehring and Rozencwajg plus a top Reddit thread. They also tried having it place new stock ideas into a Google Sheets watchlist.
- How it went
- Comet produced a short list of tariff-hit companies with brief explanations in a few minutes. The investor said the output was sometimes too shallow, and the Sheets update did not show a finished result.
- Tips
- This works best for quick screening and first-pass summaries, not deep research. If you want it to change a sheet, have it pause and ask for approval before making edits.
Try it yourself with Perplexity Comet
Open my watchlist in [Google Sheet link] and review each holding for recent news. Identify [target type of companies, e.g. Swiss firms affected by U.S. tariffs], then summarize what [Reddit communities] and recent market commentary say about them. Draft my top [number] additions in a new sheet tab with one short reason and one source link each, then stop and ask me to approve before you edit or save anything.
Fill in the [brackets]. Agents can make mistakes, so review anything before it is sent, paid or deleted.
Get 3 agent uses like this every morning
With the day's top AI news. Free, and one click to unsubscribe.
Related agent uses
Turn portfolio files into Comet trade instructions
A developer built a script that ranks portfolio holdings and writes browser-agent prompts for brokerage trades.
Draft a parking ticket appeal before you send it
They used ChatGPT to turn a street-sweeping ticket into a polite appeal that the city later dismissed.
Build one dashboard for investing, taxes, and credit checks
A developer used Claude Code to create a local finance system that organized account data, tax prep, and credit alerts.
Check state unclaimed-property databases for old names
Have an agent look for forgotten funds across official state databases using your current and past names.
Use an agent to clean up a year of finances
A CPA Bot organized statements, receipts, and tax records, then prepared amendment guidance.
Set up a morning market watch and summary feed
A Meta Muse agent checked investing chatter, followed watchlist names, and turned news and podcasts into a daily macro brief.