> For the complete documentation index, see [llms.txt](https://wpahelp.windhamlabs.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://wpahelp.windhamlabs.com/managing-custom-time-series.md).

# Managing Custom Time Series

## Adding custom time series

Users can upload data not found in the Windham Time Series database via one of two methods.

(1) The **Time Series Utility** allows users to manage and add proprietary data (returns) for use in the WPA.

(2) The **Excel Add-in** allows users to upload custom data directly from within Microsoft Excel. 

![WPA Custom Time Series Excel Add-in](/files/-MEdVJXKm_vGuBAVdIAW)

## How do WPA databases work?

The WPA uses XML flat files to persist database structures. This facilitates local storage and security management for end-users in accordance with their organizational security policies.

#### WPA's Main Database

The main database file is named tsdocument.xml and is typically found

```
<User's Documents Folder>\Windham Files\v3.0\Time Series\tsdocument.xml
```

{% hint style="danger" %}
The Windham-managed database file is named **tsdocument.xml**. Users should not attempt to edit or overwrite this file, take caution to save your custom database files using a different file name.
{% endhint %}

#### Custom Database

The custom Time Series databases are produced using the Time Series Utility or using the Excel Add-in which saves database as **.xml** files. The default file name for the custom database is

```
tsdocument-prop.xml
```

Users can also create and maintain custom databases in any location of their choosing and can select any filename for this database.

## Pointing to a Custom Time Series Data File

The WPA would need to be configured to the location of your custom time series XML database.&#x20;

![Specifying your custom managed time series database file](/files/-MUG5VgEE24ogv8HW5wv)

1. Go to the Options screen within the File menu
2. Browse to the location of your custom time series file in the **Custom Time Series Location** field
3. Select your custom time series data file (\*.xml)
4. Save your selection and refresh the database