FrenzyCap Public API
Programmatic access to your options-strategies portfolio metrics. Designed for Google Sheets, spreadsheets, and custom integrations.
Machine-readable OpenAPI 3.0 specification: /openapi.json
Authentication
All endpoints require an api_key query parameter tied to your Frenzy Capital account. Generate or view your key on the account settings page. Treat the key like a password — anyone holding it can read your portfolio metrics.
GET /api/options-strategies/data?api_key=YOUR_KEY
Base URL
https://www.frenzycap.com
Endpoints
Total portfolio liquidity
Sum of the net liquidity of every open strategy you own. Returns a single decimal number as text/plain — ideal for Google Sheets =IMPORTDATA(...).
| Parameter | In | Required | Description |
|---|---|---|---|
api_key | query | yes | Your personal API key |
Response (text/plain):
12345.67
Errors: 401 missing or invalid key, 500 server error.
Single-strategy liquidity
Net liquidity for one named strategy. Same plain-text response shape.
| Parameter | In | Required | Description |
|---|---|---|---|
strategy_id | path | yes | MongoDB ObjectId of the strategy |
api_key | query | yes | Your personal API key |
Errors: 401 missing or invalid key, 404 strategy not found.
All strategies with P&L
Structured JSON listing every strategy with liquidity, P&L, leg count, and timestamps — plus portfolio totals.
| Parameter | In | Required | Description |
|---|---|---|---|
api_key | query | yes | Your personal API key |
Response (application/json):
{
"success": true,
"total_strategies": 3,
"total_liquidity": 12345.67,
"total_pnl": 456.78,
"strategies": [
{
"strategy_id": "65f4a...",
"name": "AAPL bull put 180/175",
"underlying_symbol": "AAPL",
"net_liquidity": 4200.00,
"pnl": 145.00,
"leg_count": 2,
"created_at": "2026-03-14T15:12:00",
"updated_at": "2026-04-10T09:00:00"
}
]
}
Errors: 401 missing or invalid key, 500 server error.
Discovery
- API catalog (RFC 9727):
/.well-known/api-catalog
CORS
Both /api/options-strategies/liquidity* and /api/options-strategies/data respond with Access-Control-Allow-Origin: *, so they can be called from any origin.