Spiral gives your agent every tool with one account. Browse the tools →

opencode · Finance

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.

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

Copy an example into opencode, or ask in your own words.

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.

Fiscal.ai daily financial ratiosopencode
Try asking
  • 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.

    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.

    opencode mcp auth spiral
  3. Check it

    Spiral shows as connected.

    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.

    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.

    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.

Fiscal.ai daily financial ratios providers and prices

Spiral runs Fiscal.ai daily financial ratios through Alexandria. Open a card for today's price, with every fee included.

AlexandriaFinance
Fiscal.ai · Daily ratio series
fiscal-ai/ratios/daily

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.

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.

Get started

Start using Fiscal.ai daily financial ratios in opencode

One Spiral account for every tool your agent needs. No subscription; you pay per run.

Paste this into opencode:

Set up opencode

set up https://spiral.ai/SKILL.md
Are you an AI agent? See setup options