Google Sheets & Excel Live Integration

Real-time Web3 insurance formulas in your existing spreadsheets

Build financial models, track capital adequacy, and monitor parametric loss triggers directly in Excel and Google Sheets with intuitive native formulas.

Interactive Formula Sandbox

Select or edit formulas below to preview live evaluation in your sheet

Formula Engine Connected
fx
#
A (Formula Target)
B (Active Formula)
C (Live Output)
1
Nexus Mutual Solvency
=INSUR_SOLVENCY("nexus-mutual")
245.0% (Adequate)
2
InsurAce Reserves
=INSUR_TVL("insurace")
$42,180,000
3
Total 30D Payouts
=INSUR_CLAIMS("all", 30)
$1,480,200
Function Reference

=INSUR_SOLVENCY(id)

Calculates the real-time capital solvency ratio (CAR) of the specified protocol. Returns ratio formatted as a percentage or raw float based on formatting.

• Latency: Sub-second
• Auto-Refresh: 60 seconds
• Data Source: Onchain Archive Nodes

Free Financial & Actuarial Templates

Solvency II Capital Adequacy Model

Standard template for computing SCR (Solvency Capital Requirement) and MCR with stress test sensitivity tables.

Open in Google Sheets

Parametric Trigger Monitor

Automated sheet tracking oracle heartbeats, de-peg variances, and pending claim disbursements in real-time.

Open in Google Sheets

Protocol Yield & Risk Benchmark

Compare capital provider yields (APR) against underwriting loss exposure across all 8 supported blockchain networks.

Open in Google Sheets