The P2P Dash API

Your balance in Google Sheets

In your sheet, open Extensions → Apps Script and paste this function. Under Project settings → Script properties, add P2PDASH_TOKEN with your token. Then type the formula into a cell. Any field of the summary works, e.g. "netIncome".

function P2PDASH(field) {
  const token = PropertiesService.getScriptProperties()
    .getProperty("P2PDASH_TOKEN");
  const res = UrlFetchApp.fetch(
    "https://app.p2pdash.com/api/v1/account/summary",
    { headers: { Authorization: "Bearer " + token } },
  );
  return JSON.parse(res.getContentText()).data[field];
}

=P2PDASH("totalBalance")   →  12233.5

Sheets keeps the result and only asks again when the formula changes. To refresh, add a second argument like =P2PDASH("totalBalance", A1) and change A1. Each cell is one request. Anyone who can edit the sheet can also read the token in Apps Script, so don't do this in a sheet others can edit.

Interest per month

The timeseries with granularity=month gives you one point per month with data. Install the library once with pip install requests.

import os
import requests

res = requests.get(
    "https://app.p2pdash.com/api/v1/account/timeseries",
    params={"granularity": "month", "from": "2026-08-01", "to": "2026-10-31"},
    headers={"Authorization": f"Bearer {os.environ['P2PDASH_TOKEN']}"},
)
res.raise_for_status()

for point in res.json()["data"]:
    print(point["date"][:7], f"{point['interest']:.2f}")

2026-08 94.80
2026-09 96.42
2026-10 98.15

XIRR per platform

Save this as xirr.mjs and run node xirr.mjs (Node.js 18 or newer). The XIRR comes as a fraction: 0.0984 means 9.84% per year. A platform without enough data gets null.

const res = await fetch("https://app.p2pdash.com/api/v1/account/metrics", {
  headers: { Authorization: `Bearer ${process.env.P2PDASH_TOKEN}` },
});
if (!res.ok) throw new Error(`${res.status} ${await res.text()}`);
const { data } = await res.json();

for (const p of data.xirr.platforms) {
  const xirr = p.allTimeXirr === null
    ? "-"
    : (p.allTimeXirr * 100).toFixed(2) + "%";
  console.log(p.name.padEnd(12), xirr);
}

Platform A   9.84%
Platform B   10.37%
Platform C   11.20%
Platform D   -

Figures for your tax return

Interest and bonuses per platform for one year, shortened with jq. Which of them count as income depends on your country's rules; the API only shows what is in P2P Dash.

curl -s "https://app.p2pdash.com/api/v1/account/tax?year=2025" \
  -H "Authorization: Bearer $P2PDASH_TOKEN" \
  | jq '.data[] | {name, interest: .years[0].interest, bonus: .years[0].bonus}'

{
  "name": "Platform A",
  "interest": 412.37,
  "bonus": 25
}
{
  "name": "Platform B",
  "interest": 288.9,
  "bonus": 0
}

Lists and details

GET /api/v1/account

Which token you are using, its scopes and when it expires. Handy for checking that a token still works.

GET /api/v1/platforms

All your platforms with their IDs, portfolios and totals. Start here to find the IDs.

GET /api/v1/platforms/{id}

One platform, the same object as in the list.

GET /api/v1/platforms/{id}/intent-history

When you changed your plan for a platform (grow, hold, exit and so on).

GET /api/v1/portfolios

All your portfolios with their platforms.

GET /api/v1/portfolios/{id}

One portfolio.

GET /api/v1/platform-types

Facts per platform type: country, asset classes, regulation, founding year. The same for every user.

Query parameters

from, to

Only for timeseries. Days in YYYY-MM-DD, both included. With month or year they widen to whole periods. The balances still count from your first day of data, so a later from doesn't reset them.

granularity

Only for timeseries. day (default), month or year. The date of a point is the last day of its period. A day or period without data has no point at all, so don't expect zeros.

year

Only for tax. A calendar year like 2025. Platforms without data in that year are left out.

Two more 403 codes exist, forbidden and plan_required. With a normal account you won't see them.

Example: a date that doesn't exist

curl "https://app.p2pdash.com/api/v1/account/timeseries?from=2025-02-30" \
  -H "Authorization: Bearer $P2PDASH_TOKEN"

{
  "error": {
    "code": "invalid_request",
    "message": "Not a valid calendar date",
    "details": [
      {
        "field": "from",
        "message": "Not a valid calendar date"
      }
    ]
  }
}