Skip to main content
Glama
Johnhyeon

StockLens

by Johnhyeon

export_us_to_excel

Export unlimited US stock history to Excel for backtesting or AI uploads, avoiding truncation from chart endpoints.

Instructions

US Excel export — 미국 주식 장기 데이터를 Excel 파일로 저장 (토큰 소비 없음). "AAPL 10년치 CSV 저장", "TSLA 5년 일봉 엑셀" 같은 질문에 사용. get_us_chart는 500행 상한이라 장기 데이터는 잘림 — 백테스트·CSV·다른 AI 업로드용이면 이 도구로(행 수 무제한).

Args: ticker: US 티커 (예: "AAPL", "SPY", "BRK.B") period: "1d","5d","1mo","3mo","6mo","1y","2y","5y","10y","ytd","max" (기본 10y) interval: "1d","1wk","1mo" (기본 1d) filename: 파일명 (비우면 자동)

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
periodNo
tickerYes
filenameNo
intervalNo

Output Schema

TableJSON Schema
NameRequiredDescriptionDefault
resultYes

Schema Changelog

Changes observed during successful MCP inspections.

  1. Changed3 schema fields changedv1.1.3
    • removedInput schema / properties / filename / default
      Removed value: -""
    • removedInput schema / properties / interval / default
      Removed value: -"1d"
    • removedInput schema / properties / period / default
      Removed value: -"10y"
  2. First observedv0.4.0

TDQS

A4.5/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Annotations indicate readOnlyHint=false, destructiveHint=false, idempotentHint=false, openWorldHint=true. The description adds that the tool consumes no tokens ('토큰 소비 없음') and has no row limit, which is useful behavioral context. It doesn't fully describe file output details, but the annotations already cover the safety profile, and the description adds meaningful context beyond them.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is compact and front-loaded with the core purpose, then examples, then usage guidance, then parameter details. It is slightly dense with mixed Korean/English but every sentence earns its place. The parameter list is clear and scannable.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the tool has an output schema and annotations, the description covers the key context: what it does, when to use it, parameter semantics, and a key differentiator (no token consumption, no row limit). It doesn't mention file format details or where the file is saved, but the output schema likely covers return values, and the description is sufficient for an agent to select and invoke it correctly.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 0%, so the description must compensate. It does: it explains ticker with examples, period with allowed values and default, interval with allowed values and default, and filename with auto-generation behavior. This is strong compensation for the bare schema.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the tool's purpose: exporting US stock long-term data to an Excel file, with examples ('AAPL 10년치 CSV 저장', 'TSLA 5년 일봉 엑셀'). It distinguishes itself from get_us_chart by noting the 500-row limit and positioning this tool for unlimited rows, backtesting, CSV, and AI uploads.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines5/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description explicitly says when to use this tool vs get_us_chart: when long-term data is needed and get_us_chart would truncate at 500 rows. It also gives use cases (backtesting, CSV, other AI uploads). This is strong routing guidance.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.