Bring your own data into the wealthAPI ecosystem

Bring your own data into the wealthAPI ecosystem

Background: wealthAPI allows you to seamlessly plug-in family-office grade wealth management functionalities into your existing offering. For the perspective of an end-user, data consistency is important. We thus offer our partners to “bring their own data” to allow for a frictionless integration into their existing ecosystem.

Additionally, this might come with a huge cost advantage, as our partners typically already hold data licenses which they would love to re-use.

Essential data

The following data entities are essential to the service and should thus be provided.

Quote data

We are able to handle any quote data provider, including crypto currencies. It is also up to you, which stock exchanges you would like to include.

Quote data contains the following entities:

Securities

A meta description of a security (typically an ISIN). This should come with

  • the name of the security

  • the type (e.g. a stock, bond or ETF)

  • if it denotes in percent or currency

(Optional) Security classification

This data is often delivered with the “Securities” request.

  • a region classification

  • a sector classification

We will map your classification internally into the GICS standard thereby providing interoperability.

Historic quote timeseries

  • a series of end-of-day prices, in daily resolution

    • high, low, last and volume are optimal, but we can also just work with “last”

  • optimally the series range back for at least 10 - 15 years

  • data should be delivered split adjusted as well as non-split adjusted

  • no adjustment for capital measures and dividends must be done

  • the currency of the timeseries should be provided

We will query the full timeseries only once, then the data will be cached on our side to keep load off your APIs. Also, we will refresh data for the last 30 days once per week to account for gaps that might have happened due to connectivity issues, quote provider issues or other technical issues.

Current quotes

The current valuation of a security, on a certain stock exchange. We typically expect your API to deliver the values currency, high, low, bid, ask and last; each with a timestamp. If not available, we can map whatever your API provides to our internal data structures.

Dividend data

If you are using our “dividend planner” module, then dividend data is essential as well.

Historic dividends

A timeseries of historic dividends for a given security (typically an ISIN). This should contain the fields

  • amount

  • pay date

  • ex date

  • currency

  • is special (is this a special or a regular dividend)

  • payment interval (optional)

(Optional) Analyst estimates

A prediction-series of future dividend, typically derived from analyst consensus. Predictions should have the same datapoints as a historic time series; only with a future date.

  • amount

  • pay date

  • ex date

  • currency

  • is special (is this a special or a regular dividend)

  • payment interval (optional)

If no predictions are available, we will calculate this based on a linear model. See https://wealthapi.atlassian.net/wiki/spaces/PD/pages/618921990.

(Optional) A list of securities that have updated dividend data

To reduce the number of daily API requests we highly recommend that you provide an endpoint listing the securities (typically a list of ISINs) that had recent data updates. This way our dividend data importer needs to only iterate over securities that have in fact new data.

Optional / nice-to-have data

Fund and ETF classifications

You might want to bring your own fund and ETF classification data for a more consistent feeling. To enable fund and ETF “lookthrouhgs”, we use the following data points

  • breakdown by regions; this is percent in country (e.g. 35 % US)

  • breakdown by industries; is is percent by sector (e.g. 12 % Technology)

  • breakdown by currencies; this is percent by currency (e.g. 40 % EUR, 60 % USD)

  • Top 10 holdings

  • (Optional) Full holdings

(Optional) A list of funds that have updated data

To reduce the number of daily API requests we highly recommend that you provide an endpoint listing the funds (typically a list of ISINs) that had recent data updates. This way our classification data importer needs to only iterate over securities that have in fact new data.

Investment fundamentals

In case you would like to use our fundamental APIs, we can also include stock fundamentals. This might be useful if you would like to build on our existing frontend components. It is however totally fine and common to directly integrate your own existing stock fundamental APIs.