roic-ai

roic-ai Excel API

The Excel API from roic-ai — 2 operation(s) for excel.

GitHub OpenAPI

Operations 2

GET /v2/excel/metrics Get V2Excel metrics #
POST /v2/excel/data Post V2Excel data #

Specifications

⚙
OpenAPI
https://artifacts.apis.io/roic-ai/openapi/roic-ai-excel-api-openapi.yml

Schemas & Data

📊
JSONSchema
https://artifacts.apis.io/roic-ai/json-schema/roic-ai-v3-balance-sheet-financial-period-list-schema.json
📊
JSONSchema
https://artifacts.apis.io/roic-ai/json-schema/roic-ai-v3-cash-flow-financial-period-list-schema.json
📊
JSONSchema
https://artifacts.apis.io/roic-ai/json-schema/roic-ai-v3-company-event-list-schema.json
📊
JSONSchema
https://artifacts.apis.io/roic-ai/json-schema/roic-ai-v3-valuation-multiples-financial-period-list-schema.json
📊
JSONSchema
https://artifacts.apis.io/roic-ai/json-schema/roic-ai-v3-income-statement-financial-period-list-schema.json
📊
JSONSchema
https://artifacts.apis.io/roic-ai/json-schema/roic-ai-v3-company-profile-schema.json

Work with this as data

Every API here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for apis

7 MCP tools reach this
  • find_apisBrowse and filter every API in the catalog.
  • get_api_artifactsOne API's artifacts, grouped by type.
  • get_openapiThe primary OpenAPI for this API.
  • find_similar_apisAPIs that look like this one.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This API 
curl "https://apis.io/api/v1/apis/roic-ai:roic-ai-excel-api"
All apis 
curl "https://apis.io/api/v1/apis?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.

OpenAPI Specification

roic-ai-excel-api-openapi.yml Raw ↑ 
openapi: 3.2.0
info:
  title: ROIC Excel API
  description: The ROIC API reference for v3 (`/v3.0.0`) and legacy v2 (`/v2`). In v3, Bearer authentication is recommended because it keeps credentials out of URLs. For browser testing, you may instead pass your key as the `apikey` query parameter. Use exactly one authentication method per request, never both. v2 takes the key only as the `apikey` query parameter.
  version: 3.0.0
servers:
- url: https://api.roic.ai
tags:
- name: Excel
paths:
  /v2/excel/metrics:
    get:
      parameters:
      - name: apikey
        in: query
        required: false
        schema:
          type: string
      operationId: getV2ExcelMetrics
      tags:
      - Excel
      summary: Get V2Excel metrics
      x-summary-source: derived
  /v2/excel/data:
    post:
      parameters:
      - name: apikey
        in: query
        required: false
        schema:
          type: string
      requestBody:
        required: true
        content:
          application/json:
            schema:
              type: object
              properties:
                tickers:
                  minItems: 1
                  maxItems: 25
                  type: array
                  items:
                    type: string
                metrics:
                  minItems: 1
                  maxItems: 100
                  type: array
                  items:
                    type: string
                period:
                  description: annual | quarterly | ttm | Q1 | Q2 | Q3 | Q4
                  type: string
                fiscal_year_start:
                  description: Start fiscal year (e.g. 2015)
                  type: number
                fiscal_year_end:
                  description: End fiscal year (e.g. 2024)
                  type: number
                order:
                  description: asc | desc
                  type: string
              required:
              - tickers
              - metrics
          application/x-www-form-urlencoded:
            schema:
              type: object
              properties:
                tickers:
                  minItems: 1
                  maxItems: 25
                  type: array
                  items:
                    type: string
                metrics:
                  minItems: 1
                  maxItems: 100
                  type: array
                  items:
                    type: string
                period:
                  description: annual | quarterly | ttm | Q1 | Q2 | Q3 | Q4
                  type: string
                fiscal_year_start:
                  description: Start fiscal year (e.g. 2015)
                  type: number
                fiscal_year_end:
                  description: End fiscal year (e.g. 2024)
                  type: number
                order:
                  description: asc | desc
                  type: string
              required:
              - tickers
              - metrics
          multipart/form-data:
            schema:
              type: object
              properties:
                tickers:
                  minItems: 1
                  maxItems: 25
                  type: array
                  items:
                    type: string
                metrics:
                  minItems: 1
                  maxItems: 100
                  type: array
                  items:
                    type: string
                period:
                  description: annual | quarterly | ttm | Q1 | Q2 | Q3 | Q4
                  type: string
                fiscal_year_start:
                  description: Start fiscal year (e.g. 2015)
                  type: number
                fiscal_year_end:
                  description: End fiscal year (e.g. 2024)
                  type: number
                order:
                  description: asc | desc
                  type: string
              required:
              - tickers
              - metrics
      operationId: postV2ExcelData
      tags:
      - Excel
      summary: Post V2Excel data
      x-summary-source: derived
components:
  securitySchemes:
    bearerAuth:
      type: http
      scheme: bearer
      description: Recommended. Send your ROIC API key as a Bearer token.
    apiKeyAuth:
      type: apiKey
      in: query
      name: apikey
      description: Browser-friendly alternative. Do not combine this query parameter with the Authorization header.