Captain's Update Skill

Process weekly commodity market commentary from Vince ("The Captain") for Go Farm Yourself.

Trigger Phrases

• "captain's update"
• "process captain"
• "vince's recording"
• "weekly commodity update"

Channels

Prerequisites

• HubSpot token at ~/.config/hubspot/token
• Whisper installed (pip install openai-whisper)
• DaVinci Resolve free version (manual video editing)

Workflow

Step 1: Collect Files from Desktop

The user saves raw images, named chart images, and the audio file to ~/Desktop. Move them to the week's folder.

1. Create the week's folder: Desktop/%/Work/GFY/Captain/weekly_script/[Year]/[Month abbrev]/[Month abbrev] [Date]/ Example: Desktop/%/Work/GFY/Captain/weekly_script/2026/Feb/Feb 13/

2. Find and move from Desktop:

   • Named chart images: [Commodity]* [date].png (e.g., Corn May Futs 2.13.png)
   • Raw images: IMG_XXXX.png or IMG_XXXX.PNG
   • Audio file: Laser Ave XX.m4a

3. Verify file counts with the user.

Step 2: Transcribe Audio

whisper "path/to/Laser Ave XX.m4a" --model base --output_format all --output_dir "path/to/weekly/folder" --language en

Step 3: Clean Transcript

Apply corrections:

• "go farm yourself/herself" → "Go Farm Yourself"
• "the captain" → "The Captain"
• "Gan death zone" → "Gann Death Zone" (W.D. Gann)
• "commitment trade/trader report" → "Commitment of Traders Report"
• "GAN/Gan" → "Gann"
• "Figomach" → "Fibonacci"
• "Patients" → "Patience"
• Moving averages → hyphenate (17-day, 37-day)
• "median line" → "Median Line"
• "reaction line" → "Reaction Line"
• Fix price decimals, punctuation, garbled sentences

Output as single block of text (no headers/sections) for HubSpot email.

Step 4: Generate Timestamps

Parse transcript to identify when each commodity is discussed. Map to images in typical order:

1. Corn December/March/May Futures
2. Corn Commitment of Traders
3. Beans March/May Futures
4. Beans Commitment of Traders
5. Wheat March Futures
6. Wheat Rolling Futures
7. Wheat Commitment of Traders

Gapless rule: Each chart stays up until the next chart begins. No blank gaps. Timestamps to the whole second. Last chart holds through sign-off to end of audio.

Output timestamp table for manual DaVinci placement.

Step 5: HubSpot — Update & Publish Email (API only)

All API — no Playwright needed. Footer fix persisted from Feb 27 session.

Scripts: ~/.claude/skills/captain-update/scripts/ Email ID: 169094657110 Transcript widget: module_17443987696331 From: Rupert Williams / rwilliams@mail.gfy.ag (already configured)

5a. Update transcript + publish in one step:

~/.claude/skills/captain-update/scripts/hubspot-template.sh update-file path/to/transcript.txt

This updates the draft AND publishes it live.

Or update transcript from inline text:

~/.claude/skills/captain-update/scripts/hubspot-template.sh update "Transcript text here..."

5b. Verify:

~/.claude/skills/captain-update/scripts/hubspot-template.sh get

Fallback (if API publish fails):

Use Playwright to navigate to email edit URL and click through "Review and update" → "Update".

https://app.hubspot.com/email/23710839/edit/169094657110/settings

Step 6: HubSpot — Activate Workflow (API)

Script: ~/.claude/skills/captain-update/scripts/hubspot-workflow.sh Workflow ID: 1780679724

~/.claude/skills/captain-update/scripts/hubspot-workflow.sh status
~/.claude/skills/captain-update/scripts/hubspot-workflow.sh on

The workflow sends email 169094657110 to lists 138 (Trialists) and 363. It checks marketability, waits 1 minute, then sends.

IMPORTANT: Turn workflow OFF after enrollment (~5 minutes):

~/.claude/skills/captain-update/scripts/hubspot-workflow.sh off

TIMING: Workflow schedule is Friday 6:00 PM UTC (12:00 PM CT / 1:00 PM ET). If turned on before that time on Friday, it'll fire at schedule. If after, it won't fire until next Friday.

Pre-day automation

LaunchAgent com.gfy.captain-precheck runs Thursday nights at 10 PM to ensure the workflow is OFF. Logs at ~/.local/log/hubspot-captain-precheck.log.

Step 7: DaVinci Resolve — Manual Video Assembly

DaVinci Resolve free version does NOT have an external scripting API. Video assembly is manual.

Provide the user with:

1. Cleaned transcript text
2. Timestamp table (commodity → start time → end time → image file)
3. Audio file path

The user imports audio + chart images into DaVinci, places images at timestamps, exports video.

Step 8: Save Outputs

• Cleaned transcript: Captains-Update-[date].md in weekly folder
• Timestamp table: included in the transcript file

Step 9: Post-Run Assessment (mandatory)

After every run:

1. Review errors, retries, wasted turns
2. Identify new platform quirks
3. Update this SKILL.md
4. Update "Last Run" section

Last Run

• Date: 2026-03-03
• Model: Opus 4.6
• Changes: Email from updated to Rupert Williams / rwilliams@mail.gfy.ag. API publish confirmed working (no more Playwright needed for HubSpot). Script updated with publish, update, and update-file commands.
• Previous run (2026-02-27): Full production run. Laser Ave 70, 10 charts, gapless timestamps. API draft + Playwright publish. Footer validation fix discovered.

Key Reference Data

Limitations

• DaVinci Resolve free version has NO scripting API — video assembly is always manual
• Cannot auto-upload video to any platform
• Whisper base model sometimes mangles rapid speech — manual review needed

Common Terminology

• Gann Death Zone - W.D. Gann trading concept
• Median Line - Andrews' Pitchfork median line
• Reaction Line - Support/resistance level
• Commitment of Traders (COT) - CFTC weekly report
• Front Month - Nearest futures contract month