Prompt file imported from GoatWang/oysterun-ccstock-workenv-en (.codex/prompts/gen_report.md). Copyright stays with the author.

Generate Oysterun Report

Generate a mobile-friendly research report and publish it through Oysterun Website.

Usage

/gen_report <type> [args]

Supported types:

• single <ticker> [market]
• comparison <ticker1> <ticker2> [ticker3...] [market]
• cn_3yr_low

Instructions

1. Ensure the DB exists:

   cd tool_scripts/db_ops && uv run python db_manager.py --ensure

2. Collect data using the cache-first workflow from root CLAUDE.md.

3. Generate the report into Oysterun Website:

   cd tool_scripts/report_gen && uv run python cn_3yr_low_report.py --format html
   cd tool_scripts/report_gen && uv run python markdown_report.py --type single --ticker <TICKER> --market <MARKET>
   cd tool_scripts/report_gen && uv run python markdown_report.py --type comparison --tickers <A,B> --market <MARKET>

4. Verify that the printed path is under:

   .oysterun/site/reports/<slug>/index.html

5. Confirm that single-stock and comparison reports include the generated candlestick chart in the report page.

6. Reply with the printed Oysterun URL as a full absolute plain URL, not as a Markdown label link, not as a code block, and not wrapped in backticks. This keeps the Oysterun chat link clickable while also preserving the real URL in Telegram messages.

   If the printed URL begins with /sites/, build the final URL from the live Host origin:

   REPORT_URL="${OYSTERUN_HOST_ORIGIN%/}/sites/oysterun-ccstock-workenv-en/reports/<slug>/"

   Final reply format:

   Report link: https:///sites/oysterun-ccstock-workenv-en/reports//

   If OYSTERUN_HOST_ORIGIN is unavailable, use the plain relative /sites/oysterun-ccstock-workenv-en/reports/<slug>/ URL as a fallback. Do not use [Open report](...).

Do not start Django, do not use localhost:8800, do not write primary output to output/, and do not call direct Telegram/Mailgun scripts.