[Integrations](https://spiral.ai/integrations) › [opencode](https://spiral.ai/integrations/opencode) › [Fiscal.ai daily financial ratios](https://spiral.ai/integrations/opencode/fiscal-ai-daily-financial-ratios)

# How to Use Fiscal.ai daily financial ratios in opencode

Returns daily ratio history using trading-day closes and the latest fundamentals available on each date. Use it to examine valuation changes between earnings reports.

|  |  |
| --- | --- |
| Model | Fiscal.ai daily financial ratios |
| Available through | Alexandria |
| Category | Finance |
| Price | $0.026189 per call. |
| Returns | json |
| Runs | In the background |
| Setup | About 2 minutes, no API key |

## Prompts to try with Fiscal.ai daily financial ratios in opencode

- Use Fiscal.ai daily financial ratios for Microsoft, MSFT on NASDAQ, and add a chart of the returned ratio history to this project's internal research view.
- Use Fiscal.ai daily financial ratios for Costco, COST on NASDAQ, and add a selector for viewing the last year or all returned history in the existing chart.
- Use Fiscal.ai daily financial ratios to look this up and give me the result as a table. Save the result in ./assets.
- Pull the latest numbers from Fiscal.ai daily financial ratios and tell me what changed since last week.
- Check Fiscal.ai daily financial ratios and summarize what you find in three bullet points.

## How to set up Fiscal.ai daily financial ratios in opencode

Pick the way that suits you. Each takes about two minutes.

### Use Spiral's MCP server

1. **Add the server**: Leave out `--global` to add Spiral to the current project only. No header and no client ID or secret: opencode registers itself with Spiral.

```bash
opencode mcp add spiral --global --url https://api.spiral.ai/mcp
```

2. **Sign in**: Your browser opens. Sign in to Spiral, pick the organization and click Authorize, then return to the terminal. No API key. Inside opencode, `/mcps` starts the same sign-in.

```bash
opencode mcp auth spiral
```

3. **Check it**: Spiral shows as connected.

```bash
opencode mcp list
```

### Use the Spiral skill

1. **Send opencode this message**: Your agent reads Spiral's skill and sets itself up.

```
set up https://spiral.ai/SKILL.md
```

2. **Sign in or paste a key**: Approve Spiral in the browser, or give the agent a key from the console.

### Use the Spiral CLI

1. **Install and sign in**: Installs the Spiral CLI, signs you in and adds its skill to your coding agents.

```bash
npx -y spiral-cli@latest init
```

### Call the Spiral API

1. **Create an API key**: In the console, under API keys.

2. **Run Fiscal.ai daily financial ratios**: One request; the result comes back by polling or a webhook.

```bash
curl https://api.spiral.ai/v1/runs \
  -H "Authorization: Bearer $SPIRAL_API_KEY" \
  -H "Content-Type: application/json" \
  -H "Idempotency-Key: $(uuidgen)" \
  -d '{
    "provider": "alexandria",
    "model": "fiscal-ai/ratios/daily",
    "input": {
      "ratioId": "<ratioId>",
      "fscl": "<fscl>"
    }
  }'
```

Then paste one of the prompts above: opencode finds Fiscal.ai daily financial ratios on Spiral, shows the price and runs it.

Setup guide in the docs: https://spiral.ai/docs/quickstarts/opencode

## Fiscal.ai daily financial ratios tools and prices

- [Fiscal.ai · Daily ratio series](https://spiral.ai/tools/alexandria/fiscal-ai/ratios/daily) (Alexandria): $0.026189 per call.

## Settings you can ask for

| Setting | Allowed values | Default | Description |
| --- | --- | --- | --- |
| cik |  | — | SEC Central Index Key. Use when a company has no ticker, or after a rename. |
| figi |  | — | OpenFIGI identifier of the security. Licensed identifier. |
| fscl |  | — | Fiscal.ai's stable company identifier, the `companyFiscalIdentifier` field. The only identifier that survives a ticker change or a relisting, so prefer it when carrying a company between calls. |
| isin |  | — | ISIN of the security. Licensed identifier. |
| cusip |  | — | CUSIP of the security. Licensed identifier. |
| ticker |  | — | Ticker symbol, for example MSFT. Only unique within an exchange, so pass `exchange` with it. |

## What can you do with Fiscal.ai daily financial ratios in opencode?

Build an internal chart that compares Microsoft's returned ratios across dates or reporting periods. A coding agent can add the data to your project's analysis view and label the observation frequency clearly.

### Compare company valuations

Compare Microsoft's and Apple's returned valuation ratios. Use matching reporting periods for a financial comparison or matching trading dates for a daily comparison.

### Put a valuation in historical context

Calculate where a company's latest returned valuation ratio sits within its available history. Keep daily observations and reporting-period observations in separate comparisons.

### Review valuation changes around earnings

Examine returned ratios before and after a company's earnings announcement. Use daily history to inspect the surrounding trading dates and period history to compare reported results.

### Prepare an internal watchlist brief

Summarize the latest returned ratios for a short list of public companies and compare them with earlier observations. Highlight the largest changes for further research.

### Check valuation thresholds

Check whether a returned valuation ratio crosses an analyst's chosen threshold. Use daily observations for trading-date checks or reported periods for a financial review.

### Build an internal ratio chart

Chart a public company's returned ratio history with its dates and metric labels. Choose a daily chart for changes between reports or a period chart for reported comparisons.

## Overview

- [Alexandria](https://spiral.ai/providers/alexandria)
- [All opencode guides](https://spiral.ai/integrations/opencode)

## Fiscal.ai daily financial ratios in other agents

- [Amp](https://spiral.ai/integrations/amp/fiscal-ai-daily-financial-ratios)
- [ChatGPT](https://spiral.ai/integrations/chatgpt/fiscal-ai-daily-financial-ratios)
- [Claude](https://spiral.ai/integrations/claude-desktop/fiscal-ai-daily-financial-ratios)
- [Claude Code](https://spiral.ai/integrations/claude-code/fiscal-ai-daily-financial-ratios)
- [Cline](https://spiral.ai/integrations/cline/fiscal-ai-daily-financial-ratios)
- [Codex](https://spiral.ai/integrations/codex/fiscal-ai-daily-financial-ratios)
- [Cursor](https://spiral.ai/integrations/cursor/fiscal-ai-daily-financial-ratios)
- [Devin](https://spiral.ai/integrations/devin/fiscal-ai-daily-financial-ratios)
- [dots](https://spiral.ai/integrations/dots/fiscal-ai-daily-financial-ratios)
- [Factory Droid](https://spiral.ai/integrations/factory-droid/fiscal-ai-daily-financial-ratios)
- [Gemini](https://spiral.ai/integrations/gemini/fiscal-ai-daily-financial-ratios)
- [Gemini CLI](https://spiral.ai/integrations/gemini-cli/fiscal-ai-daily-financial-ratios)
- [Google Antigravity](https://spiral.ai/integrations/antigravity/fiscal-ai-daily-financial-ratios)
- [goose](https://spiral.ai/integrations/goose/fiscal-ai-daily-financial-ratios)
- [Grok](https://spiral.ai/integrations/grok/fiscal-ai-daily-financial-ratios)
- [Grok Build](https://spiral.ai/integrations/grok-build/fiscal-ai-daily-financial-ratios)
- [Hermes](https://spiral.ai/integrations/hermes/fiscal-ai-daily-financial-ratios)
- [Instinct](https://spiral.ai/integrations/instinct/fiscal-ai-daily-financial-ratios)
- [Manus](https://spiral.ai/integrations/manus/fiscal-ai-daily-financial-ratios)
- [Muse](https://spiral.ai/integrations/muse/fiscal-ai-daily-financial-ratios)
- [Muse Code](https://spiral.ai/integrations/muse-code/fiscal-ai-daily-financial-ratios)
- [n8n](https://spiral.ai/integrations/n8n/fiscal-ai-daily-financial-ratios)
- [Notion](https://spiral.ai/integrations/notion/fiscal-ai-daily-financial-ratios)
- [OpenClaw](https://spiral.ai/integrations/openclaw/fiscal-ai-daily-financial-ratios)
- [Perplexity](https://spiral.ai/integrations/perplexity/fiscal-ai-daily-financial-ratios)
- [Raycast](https://spiral.ai/integrations/raycast/fiscal-ai-daily-financial-ratios)
- [VS Code](https://spiral.ai/integrations/vscode/fiscal-ai-daily-financial-ratios)
- [Windsurf](https://spiral.ai/integrations/windsurf/fiscal-ai-daily-financial-ratios)
- [Zapier](https://spiral.ai/integrations/zapier/fiscal-ai-daily-financial-ratios)

## More opencode guides

- [Fiscal.ai company profile](https://spiral.ai/integrations/opencode/fiscal-ai-company-profile)
- [Fiscal.ai daily stock prices](https://spiral.ai/integrations/opencode/fiscal-ai-daily-stock-prices)
- [Fiscal.ai company investment theses](https://spiral.ai/integrations/opencode/fiscal-ai-company-investment-theses)
- [Fiscal.ai earnings calendar](https://spiral.ai/integrations/opencode/fiscal-ai-earnings-calendar)
- [Fiscal.ai company filings](https://spiral.ai/integrations/opencode/fiscal-ai-company-filings)
- [Fiscal.ai earnings call transcript](https://spiral.ai/integrations/opencode/fiscal-ai-earnings-call-transcript)

## Questions about Fiscal.ai daily financial ratios in opencode

**Can opencode use Fiscal.ai daily financial ratios?**

Yes. Add Spiral to opencode as an MCP server, and opencode can find and run Fiscal.ai daily financial ratios like any built-in tool.

**How much does Fiscal.ai daily financial ratios cost in opencode?**

$0.026189 per call. You pay from your Spiral balance as you go, with no subscription, and a failed run is not charged. Your opencode plan is separate.

**Do I need an Alexandria account to use Fiscal.ai daily financial ratios in opencode?**

No. Spiral runs Fiscal.ai daily financial ratios on its own Alexandria account. You sign in to Spiral once and never paste a key.

**How long does it take to set up Fiscal.ai daily financial ratios in opencode?**

About two minutes: add the server, then sign in, then check it.

**Does opencode wait while Fiscal.ai daily financial ratios runs?**

Fiscal.ai daily financial ratios runs in the background. opencode starts the run, checks on it and gives you the json when it's ready.

**Which markets does Fiscal.ai's data API cover?**

Fiscal.ai advertises more than 13,000 public companies across the US, Canada, ADRs, UK, and Europe. That is the API coverage figure, rather than a guarantee that every ratio exists for every company.

**Where do Fiscal.ai's financial ratios come from?**

Fiscal.ai says it produces its own fundamentals and ratios for US, Canadian, ADR, UK, and EU companies.

**How soon do new earnings reach the underlying data?**

Fiscal.ai says fundamental financial data for US, Canadian, EU, UK, and ADR companies typically updates three to seven minutes after earnings are reported. This describes the underlying fundamentals, rather than a separate refresh guarantee for every calculated ratio.

**How much reporting history does Fiscal.ai advertise?**

The Financials & Ratios package advertises more than 20 annual periods and 40 quarterly periods. Those figures describe reporting history, rather than the number of daily observations.

**Which earnings figure does Fiscal.ai use for P/E?**

Fiscal.ai's ratio reference defines P/E as share price divided by diluted EPS. It also marks P/E as available with daily history.

