# HTQLDB Formula Ready | The spreadsheet is in the database

> HTQLDB Formula Ready: over 500 spreadsheet-like functions, 79 of them financial, run alongside your data in queries, FLOWs and reports, with the names and arguments your analysts know. Core formulas also run in the browser through WebAssembly.

URL: https://sigmar.au/htqldb/formulas
Organisation: Sigmar AOS (trading name of Sigmar Investment)

*HTQLDB · Formula Ready*

## The spreadsheet is in the database.

Bring familiar spreadsheet-like functions directly into your queries, FLOWs and reports. Over 500 functions run alongside your data, using the names and arguments your analysts already know.

- [Explore formula functions](#functions)
- [Build with HTQLDB](https://sigmar.au/pricing)

### 500+ Excel-like functions

### 79 financial functions

### Shared formula core

*Calculations where the data lives*

## One formula. Consistent answers.

When applications calculate in separate services, dashboards and spreadsheets, business logic can diverge. HTQLDB runs formulas alongside the data used by your application.

> The language your analysts already know, where your data already lives.

## A familiar language for every calculation.

79 finance functions included in 500+.

### Math

ROUND, SUMIFS

### Statistics

Summaries and distributions

### Dates & periods

EOMONTH

### Finance

NPV, XIRR, PMT

### Arrays

Array calculations

### Text

UPPER, TEXTSPLIT

### Logic & lookup

XLOOKUP

### Forecasting & analytics

Model future outcomes

*HTQL in practice*

## Calculations inside your queries.

LOOKUP(orders,
  SHOW("order_id",
    ROUND(total, 0) AS rounded_total,
    UPPER(currency) AS currency),
  TAKE(20))

HTQL terminal

Round totals and format currencies while reading records.

Illustrative HTQL example and results

### 1001|129|AUD

### 1002|48|AUD

### 1003|215|NZD

### 1004|86|USD

### 1005|312|AUD

### 1006|57|GBP

## Financial models, closer to your data.

79 financial functions evaluate lending, cash flows, returns and investment decisions using functions familiar to finance teams: NPV · XNPV · IRR · XIRR · EBITDA · GMROI · CLV · Break-even.

PMT(0.0054, 360, 450000)
Monthly loan repayment · $450,000 principal · 30 years · 0.54% monthly rate

### A calculator beside a mortgage

### Explore Finance Ready

## The same calculation, wherever it runs.

Core formulas compile to WebAssembly for browser-side execution, as well as running inside HTQLDB.

WebAssembly supports the core formula surface.

### HTQLDB / PostgreSQL

### Core formulas

core

### Browser / WebAssembly

*A common foundation*

## Use formulas across your application.

### Queries

Summarise and calculate near the data.

### FLOWs

Apply calculations within governed execution.

### Reports

Derive figures from shared records.

### Data Ready

### Finance Ready

### Explore HTQL in practice

## Build on calculations you already understand.

Bring your formulas, models and business data together with HTQLDB.

- [Build with HTQLDB](https://sigmar.au/pricing)
- [Book a Demo](https://sigmar.au/book-demo)
