IdiotQuant API 문서

curl "https://idiotquant-backend.tofu89223.workers.dev/scan/daily/dates"

// 응답
{
  "success": true,
  "data": [
    {
      "scan_date": "20260601",
      "total_cnt": 1847,
      "ncav_cnt": 42,
      "low_pbr_cnt": 312,
      "low_per_cnt": 198,
      "s_rim_cnt": 87
    }
  ],
  "meta": { "total": 14 }
}

curl "https://idiotquant-backend.tofu89223.workers.dev/scan/daily/ticker/004830?limit=14"

# 덕성(004830) 월별 24개월 추이
curl "https://idiotquant-backend.tofu89223.workers.dev/scan/archive/ticker/004830?period_type=monthly&limit=24"

// 응답
{
  "data": [{ "period_label": "2026-06", "ncav_ratio": 2.34, "roe": 0.043, "per": 9.8, "pbr": 0.42, "days_scanned": 18 }, ...]
}

curl "https://idiotquant-backend.tofu89223.workers.dev/scan/status"

// 응답
{
  "data": {
    "scan": { "lastIndex": 350, "scanDate": "20260601", "totalStocks": 2000, "progressPct": 18, "done": false },
    "archive": { "weekLabel": "20260526", "weekDone": false, "weekProgressPct": 42,
                 "monthLabel": "2026-06", "monthDone": false, "monthProgressPct": 12 },
    "stockDataDaily":   { "total_rows": 25858, "scan_days": 14, "unique_tickers": 1847, "latest_date": "20260601" },
    "stockDataArchive": [
      { "period_type": "monthly", "periods": 2, "total_rows": 3694 },
      { "period_type": "weekly",  "periods": 4, "total_rows": 7388 }
    ]
  }
}

# KR 계정 등록
npx wrangler d1 execute idiotquant_main --remote --command="
  INSERT INTO trading_accounts
    (user_id, country, appkey, appsecret, account_number, monthly_budget_krw)
  VALUES ('USER_ID', 'KR', 'APPKEY', 'APPSECRET', 'ACCOUNT_NO', 2000000)"

# US 계정 등록
npx wrangler d1 execute idiotquant_main --remote --command="
  INSERT INTO trading_accounts
    (user_id, country, appkey, appsecret, account_number, monthly_budget_krw)
  VALUES ('USER_ID', 'US', 'APPKEY', 'APPSECRET', 'ACCOUNT_NO', 1000000)"

# per-user 투자 룰 지정 (NULL이면 전역 룰 사용)
npx wrangler d1 execute idiotquant_main --remote --command="
  UPDATE trading_accounts
  SET quant_rule_json='{"ncav_ratio":1.5,"active_count":10}'
  WHERE user_id='USER_ID' AND country='KR'"

curl "https://idiotquant-backend.tofu89223.workers.dev/kr/capital" -H "X-User-Id: ADMIN_ID"

// 응답 (발췌)
{
  "stock_list": [
    { "symbol": "005930", "name": "삼성전자", "token": 45200, "action": "active", "ncavRatio": "1.42" }
  ],
  "charge_info": { "capital_charge_rate": 164 },
  "action": "buy"
}

curl "https://idiotquant-backend.tofu89223.workers.dev/us/capital" -H "X-User-Id: ADMIN_ID"

# 전체 active 종목에 3만원 추가
curl -X POST "https://idiotquant-backend.tofu89223.workers.dev/kr/capital/token/plus/30000/all" -H "X-User-Id: ADMIN_ID"

# 특정 종목에만 추가
curl -X POST "https://idiotquant-backend.tofu89223.workers.dev/kr/capital/token/plus/30000/ticker/005930" -H "X-User-Id: ADMIN_ID"

# 차감
curl -X POST "https://idiotquant-backend.tofu89223.workers.dev/kr/capital/token/minus/30000/all" -H "X-User-Id: ADMIN_ID"
curl -X POST "https://idiotquant-backend.tofu89223.workers.dev/us/capital/token/plus/50000/all"  -H "X-User-Id: ADMIN_ID"

https://idiotquant-backend.tofu89223.workers.dev/kakao/login  ← 브라우저에서 직접 접근

curl -X POST "https://idiotquant-backend.tofu89223.workers.dev/kakao/logout" --cookie "cf_token=YOUR_TOKEN"

curl "https://idiotquant-backend.tofu89223.workers.dev/user/info" -H "X-User-Id: YOUR_USER_ID"

curl "https://idiotquant-backend.tofu89223.workers.dev/ncav/daily?date=latest&min_ratio=1.5&limit=20"

curl "https://idiotquant-backend.tofu89223.workers.dev/ncav/archive"
curl "https://idiotquant-backend.tofu89223.workers.dev/ncav/archive?period=2026-06&min_ratio=1.0"

curl -X POST "https://idiotquant-backend.tofu89223.workers.dev/ncav/scan/run" -H "X-User-Id: ADMIN_ID"

# 2025년 백테스트 시작
curl "https://idiotquant-backend.tofu89223.workers.dev/backtest/kr/year/2025" -H "X-User-Id: ADMIN_ID"

# 100번 종목부터 재개
curl "https://idiotquant-backend.tofu89223.workers.dev/backtest/kr/year/2025/index/100" -H "X-User-Id: ADMIN_ID"

curl "https://idiotquant-backend.tofu89223.workers.dev/backtest/us/year/2025" -H "X-User-Id: ADMIN_ID"

curl "https://idiotquant-backend.tofu89223.workers.dev/strategy/kr/ncav/date/latest"
curl "https://idiotquant-backend.tofu89223.workers.dev/strategy/all/ncav/list"

curl "https://idiotquant-backend.tofu89223.workers.dev/fmp/AAPL"

curl "https://idiotquant-backend.tofu89223.workers.dev/finnhub/AAPL"

curl -X POST "https://idiotquant-backend.tofu89223.workers.dev/laboratory/llm" \
  -H "Content-Type: application/json" \
  -d '{"prompt": "삼성전자의 NCAV를 설명해줘"}'

curl "https://idiotquant-backend.tofu89223.workers.dev/algorithm/trade" -H "X-User-Id: YOUR_ID"

curl "https://idiotquant-backend.tofu89223.workers.dev/timestamp" -H "X-User-Id: YOUR_ID"

// 성공
{ "success": true,  "data": [...], "meta": { "total": 50, "scanDate": "20260601", ... } }

// 오류 (400 / 403 / 500)
{ "success": false, "error": "오류 메시지" }

- 2026-06-04: D1 읽기 최적화 — /scan/daily·dates Cloudflare Cache API 5분 엣지 캐시, users 조회 in-memory 캐시(60s), SELECT * → 필요 컬럼만 조회
- 2026-06-04: /scan/daily limit 최대값 500 → 2000으로 상향 (전체 종목 조회 지원)
- 2026-06-03: /dashboard/scan 개선 - 다음/직전 스캔 배치 종목명·티커, 예상 완료 시각, 최근 스캔 결과 테이블 추가
- 2026-06-03: ROE 계산식 수정 - NCAV(유동자산-부채)를 분모로 쓰던 버그를 EPS/BPS(자본총계 기반)로 교정, s_rim 전략 태깅 동일 수정; migration 0005로 기존 stock_data_daily/archive 일괄 교정
- 2026-06-03: docs 페이지 개편 - /scan/* 섹션 신설, 섹션 우선순위 재정렬, 레거시 배지 추가
- 2026-06-02: ncav_daily double-write 제거, 전체를 stock_data_daily 기반으로 통합
  - ncavScanKr: ncav_daily 쓰기 제거, stock_data_daily만 사용
  - /ncav/daily, /ncav/archive: stock_data_daily/archive 기반으로 전환 (ncav 전략 필터 기본)
  - /stock/:ticker: stock_data_daily 기반으로 전환, strategies·roe 필드 추가
- 2026-06-02: /scan/* API 신규 추가 (stock_data_daily · stock_data_archive 기반)
  - GET /scan/daily, /scan/daily/dates, /scan/daily/ticker/:ticker
  - GET /scan/archive, /scan/archive/ticker/:ticker
  - GET /scan/status
  - ?strategy=ncav|low_pbr|low_per|s_rim|all, ?period_type=monthly|weekly 지원
- 2026-06-02: 다중 전략 종목 데이터 누적 (stock_data_daily · stock_data_archive)
  - 지원 전략: NCAV · 저PBR · 저PER · S-RIM (roe > 0.08 && pbr < 1.0)
  - 모든 스캔 종목 저장 (기존 ncav_daily는 NCAV 종목만 저장하던 것을 확장)
  - 3단 아카이브: 일별 14일 보관 → 주별(26주) → 월별(무기한)
  - 롤링 아카이브: min%5===3 tick마다 50종목씩 처리 (10ms CPU 제약 대응)