How to Analyze Your Parqet Portfolio Offline with X-Ray Data

7 min read

Parqet (formerly Tresor One) has become one of the most popular portfolio tracking platforms in the German-speaking investment community. It connects to your broker, imports your transactions, and provides a clean dashboard showing your holdings, performance, dividends, and allocation. One of its most powerful features is X-Ray — a detailed breakdown of your portfolio’s composition.

But what if you want to work with that data offline? Maybe you need deeper analysis, want to combine it with other data sources, need Excel-compatible output, or simply prefer to keep your portfolio details on your own machine. This guide covers how to export your parqet X-Ray data and analyze it locally.

What Is Parqet’s X-Ray Feature?

X-Ray is parqet’s portfolio analysis view. It goes beyond the basic holdings list to show you:

  • Individual positions with their current values and weights in your portfolio
  • Asset allocation across different categories
  • Geographic distribution of your investments
  • Sector breakdown showing which industries your money is concentrated in

The feature gives you a more granular understanding of your portfolio than a simple holdings list. Instead of just seeing that you own Fund A and Stock B, X-Ray shows you where the underlying money is actually invested.

Why the X-Ray View Matters

Most investors hold multiple funds and ETFs, each containing hundreds or thousands of positions. Your portfolio might look diversified at the fund level — you own a world ETF, a European small caps fund, and a few individual stocks — but the X-Ray reveals the actual underlying exposure.

Common discoveries when using X-Ray analysis:

  • Hidden concentration: That world ETF and your individual tech stocks together might mean 30%+ of your portfolio is in just five companies.
  • Geographic imbalance: What looks like broad diversification might be 70% US when you account for the underlying ETF compositions.
  • Sector overlap: Your “different” funds might all be heavily weighted toward the same sectors.

Exporting X-Ray Data from Parqet

Parqet allows you to export your portfolio data as CSV. The export typically includes:

  • Position ID (usually the ISIN)
  • Holding name
  • Number of shares
  • Current value
  • Weight in portfolio
  • Additional metadata depending on the export options selected

To export, navigate to the X-Ray section of your portfolio on parqet.com and look for the export or download option. The resulting CSV file contains your portfolio breakdown in a structured format that can be opened in any spreadsheet application or analysis tool.

A Note on the CSV Format

The exported CSV follows a standard structure with columns separated by semicolons (common in European tools) or commas. The first row contains column headers, and each subsequent row represents a position in your portfolio.

The ISIN (International Securities Identification Number) in the export is particularly valuable. Unlike a ticker symbol, which varies by exchange and region, the ISIN is a globally unique 12-character identifier. This means the data can be reliably matched against other databases for enrichment — looking up the country of registration, the sector classification, or the current price of each position.

Why Analyze Offline?

There are several legitimate reasons to work with your portfolio data locally rather than exclusively through a web platform:

Privacy

Your portfolio is one of the most sensitive pieces of financial data you have. While parqet is a reputable platform with proper security, some investors prefer to do detailed analysis on their own machine. An offline tool that never transmits your data provides an additional layer of privacy.

Deeper Analysis

Web platforms are optimized for the most common use cases. If you want to do something unusual — custom groupings, specific filtering criteria, combining data from multiple accounts or platforms, or running your own calculations — a local tool gives you more flexibility.

Excel and Spreadsheet Integration

Many investors maintain their own spreadsheets for tax calculations, financial planning, or tracking performance over time. Having your portfolio data in a format that easily exports to Excel means you can integrate it into your existing workflow without manual data entry.

Offline Access

Sometimes you want to review your portfolio on a flight, in a location without reliable internet, or simply without opening a browser. Having the data locally means it is always accessible.

Working with Portfolio CSV Data

Once you have your CSV export, the question is what to do with it. Here are the common approaches:

Spreadsheet Analysis

Open the CSV in Excel, Numbers, or LibreOffice Calc. This gives you full control — you can sort, filter, create pivot tables, and build charts. The downside: setting up the analysis takes time, and you repeat the work every time you export updated data.

For basic questions like “what are my top 10 positions by value?” or “how much is in ETFs vs. individual stocks?”, a spreadsheet works fine. For more complex analysis — like breaking down country exposure based on ISINs — you need to add lookup data, which significantly increases the effort.

Programming Approach

If you are comfortable with Python or R, you can write scripts to parse the CSV, enrich it with ISIN-based lookups, and generate visualizations. This is powerful but requires programming knowledge and maintenance as formats change.

Dedicated Analysis Tool

This is where Pecuniator comes in. It is a desktop application designed specifically for analyzing portfolio CSV data — not just from parqet, but from any source that provides compatible CSV files.

What Pecuniator Does with Your Data

Pecuniator takes your exported CSV and provides immediate, meaningful analysis without manual setup:

ISIN-Based Country and Region Visualization

The ISIN itself encodes the country of registration in its first two characters (US for United States, DE for Germany, IE for Ireland, etc.). Pecuniator uses this to automatically generate a geographic breakdown of your portfolio. You can see at a glance how your investments are distributed across countries and regions — without needing to manually look up each position.

This is more informative than it might seem at first. Many European investors hold Irish-domiciled ETFs (ISIN starting with IE) that actually invest globally. The ISIN-based view shows you where your funds are legally registered, which is relevant for tax purposes and regulatory exposure, complementing the look-through geographic analysis that platforms like parqet provide.

Fast Search for Large Portfolios

If your portfolio contains hundreds of positions — not uncommon when you include individual ETF holdings from an X-Ray export — scrolling through a list is impractical. Pecuniator provides instant search across all fields: name, ISIN, value, or any other column. Type a few characters and the matching positions appear immediately.

Excel Export

One of the most requested features for portfolio analysis tools: the ability to export the analyzed data as a properly formatted Excel file. Pecuniator lets you take your CSV data, enriched with country and region information, and export it as XLSX for further analysis in Excel or for sharing with a financial advisor.

Works with Any Compatible CSV

While the parqet X-Ray export is a common use case, Pecuniator is not limited to parqet data. Any CSV file with portfolio positions — from another tracking tool, a broker export, or even a manually created file — can be loaded and analyzed. The tool adapts to the columns present in your file.

Desktop-Only by Design

Pecuniator is intentionally a desktop application, available for macOS and Windows. This is a deliberate choice for a portfolio analysis tool: your financial data stays on your machine. There is no cloud upload, no account creation, no server that stores your portfolio composition. You open the app, load your CSV, and everything happens locally.

For investors who are privacy-conscious — and when it comes to detailed portfolio breakdowns, that should be everyone — this architecture matters. Your complete portfolio composition, including exact share counts and values, never leaves your computer.

A Practical Workflow

Here is how the pieces fit together:

  1. Track your portfolio on parqet (or any other platform) for day-to-day monitoring, transaction import, and performance tracking.
  2. Export the X-Ray data as CSV when you want to do deeper analysis.
  3. Open the CSV in Pecuniator to get immediate country/region breakdowns, search through positions, and explore the data interactively.
  4. Export to Excel if you need the data in your spreadsheet workflow, for tax preparation, or for sharing.

This is not about replacing parqet — it is about complementing it with offline analysis capabilities that a web platform does not provide. Each tool does what it does best: parqet for live tracking and transaction management, Pecuniator for private, detailed, offline portfolio analysis.