Windham Portfolio Advisor
  • Windham Portfolio Advisor Support
  • Installation
    • Installing the Windham Portfolio Advisor
    • Installation Prerequisites
    • Installation FAQ
      • License Key Management
  • Time Series
  • Managing Custom Time Series
  • Custom Time Series Excel Add-in
  • Custom Time Series Utility
  • Updating the Windham Time Series Database
  • Mixing Data Periodicities within a Case File
  • Hedged and Unhedged Time Series
  • Overlays
  • Expected Risk
    • Annualizing Volatility and Return
    • Correlation
    • Covariance
    • Exponential Risk
    • Quiet and Turbulent Risk
    • Series Filter
    • Views (Risk and Correlation)
  • Expected Returns
    • Historical Returns
    • Equilibrium Returns
    • Implied Returns
    • Black-Litterman
    • Blend
    • Estimating Future Value: Arithmetic or Geometric
  • Optimization
    • Multi-goal Optimization
    • Transaction Costs and Turnover Controls
    • Risk Aversion
    • Full-Scale Optimization
  • Simulation
    • Simulation Methods
  • Exposure to Loss
    • Value at Risk
    • Probability of Loss
  • Risk Budgets
    • Risk Budgets
    • Value at Risk Sensitivities
  • Factor Analysis
    • Windham Factors
    • Factor Analysis
  • Cash Flow Analysis
    • Cash Flow Rules
    • Distribution of Wealth
    • Target Wealth Probability
  • Miscellaneous
    • Effective Tax Rates
    • Shadow Assets, Shadow Liabilities, and Illiquidity
    • Asset-liability Optimization
Powered by GitBook
On this page
  • Adding custom time series
  • How do WPA databases work?
  • Pointing to a Custom Time Series Data File

Managing Custom Time Series

PreviousLicense Key ManagementNextCustom Time Series Excel Add-in

Last updated 4 years ago

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.

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

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.

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.

  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

WPA Custom Time Series Excel Add-in
Specifying your custom managed time series database file