Stratix → Excel

Flat JSON endpoints designed for Excel's WEBSERVICE() function and Power Query. No envelope, no auth on read, predictable shapes, ready to drop into a portfolio model.

Connect in 30 seconds — Excel WEBSERVICE()

# A single cell:
=WEBSERVICE("https://finance.northflow.no/api/v1/excel/quote/EQNR")

# Parse the JSON value you need:
=FILTERXML(WEBSERVICE(URL), "//price")

# For multiple values + a table, prefer Power Query (instructions below).

Power Query · live table

Open Excel → Data → Get Data → From Other Sources → From Web.
Paste the endpoint URL, e.g. https://finance.northflow.no/api/v1/excel/comply.
Power Query Editor opens. Click Into Table → expand columns → Close & Load.
The data refreshes on demand or at intervals you configure (Data → Queries & Connections → Properties).

Endpoint reference

GET/api/v1/excel/risk?region=NORDIC

Risk score · AEGIS composite risk for any of the 12 regions

Sample response

{
  "region": "NORDIC",
  "riskScore": 0.42,
  "trend": "flat",
  "systemAlignment": "Western"
}

Excel formula

=WEBSERVICE(
  "https://finance.northflow.no/api/v1/excel/risk?region=NORDIC"
)

GET/api/v1/excel/quote/EQNR

Live quote · NORSE entity price + AEGIS exposure + COMPLY article

Sample response

{
  "ticker": "EQNR",
  "price": 318.5,
  "changePct": 0.44,
  "aegisExposure": 0.41,
  "complyArticle": "ARTICLE_6"
}

Excel formula

=WEBSERVICE(
  "https://finance.northflow.no/api/v1/excel/quote/EQNR"
)

GET/api/v1/excel/hypothesis/H-0847

Hypothesis · ARGUS hypothesis status, confidence, days remaining

Sample response

{
  "id": "H-0847",
  "confidence": 0.73,
  "status": "ACTIVE",
  "daysRemaining": 18
}

Excel formula

=WEBSERVICE(
  "https://finance.northflow.no/api/v1/excel/hypothesis/H-0847"
)

GET/api/v1/excel/comply?portfolio=pf_001&metric=taxonomyAlignment

Portfolio metric · COMPLY single-metric pull (or full portfolio if metric omitted)

Sample response

{
  "portfolio": "pf_001",
  "metric": "taxonomyAlignment",
  "value": 0.78
}

Excel formula

=WEBSERVICE(
  "https://finance.northflow.no/api/v1/excel/comply?portfolio=pf_001&metric=taxonomyAlignment"
)

GET/api/v1/excel/signal-trust?domain=geopolitical

Signal trust · Darwinian average weight + top signal per domain

Sample response

{
  "domain": "geopolitical",
  "avgWeight": 1.97,
  "topSignal": "UCDP Conflict Events",
  "topWeight": 2.31
}

Excel formula

=WEBSERVICE(
  "https://finance.northflow.no/api/v1/excel/signal-trust?domain=geopolitical"
)

Rate limits

Excel endpoints cache at the edge (60–600 s depending on data volatility) and are subject to your subscription tier's rate limit. Explorer: 60 req/min. Professional: 600 req/min. Intelligence: 6,000 req/min.

Pre-built workbook

A starter Excel workbook with three connected sheets — Portfolio Risk Dashboard, Hypothesis Watch, Compliance Snapshot — is available on request. Email tdp@northflow.no and we'll send it.