Installing the application
Portfolio Performance is primarily targeted at a German speaking audience. Therefore, the application’s website is in German. If you aren’t fluent in German, you can use Google translate to understand what is written in the page.
The image below shows where you need to click in order to download the application for your operating system (as of June 2019).
Changing the language
When you install the application its language is configured to „Automatic“. Therefore, the language will be inferred from your operating system. If your operating system’s language is „English“ your application will be in „English“.
The application is available in English, German, Dutch and Spanish.
In case the application is in German you can change the language in the preferences of the application. In Mac OS:
- go through the menus „Portfolio Performance > Einstellungen > Sprache“.
- select „English“ in the „Sprache“ dropdown
- click „Anwenden und Schließen“
- Restart the application
The application works by storing all your portfolio information in a XML file stored on your computer. From the landing page you can create a new file or open an existing one.
The application also has a few sample files you can use to look at example portfolios so you can see the features of the application in action. The rest of this tutorial uses the kommer sample file for the examples.
Main sections of the application
The application has 5 main sections:
- Securities – In this section you specify all securities that you intend to create transactions on.
- Accounts – In this section you register your transactions in your brokerage accounts (e.g. deposits, withdrawals, buy, sell, dividend).
- Reports – In this section you can see graphs about your portfolio and how it is performing according to several metrics
- Taxonomies – In this section you can see how your portfolio is allocated across asset classes. You can also specify your target asset allocation.
- General Data – In this section you can see the evolution of currency exchange rates and can also change the details of the where ETF information is fetched from.
In the „All Securities“ tab is where you add your securities, e.g. ETFs. Follow these steps to add an ETF:
- click on the right side „+“ sign and then click on „search for instruments…“.
- type the ticker symbol for the ETF/exchange you are using and click on „search“. You can find the ticker symbol per exchange in the listings page of justETF. It is better to search by ticker symbol than by ISIN because this way the application will automatically pull the historical prices for the ETF you are tracking buying – ETFs have different prices depending on where they are listed.
- select the ETF you are looking for and click on „Apply“. Multiple exchanges might have the same ticker symbol. You will have to select the one that applies to you.
- confirm if you want to change the name of the ETF and then click “OK”
- optional: categorize the security. You can categorize a security according to its asset class (e.g. Equity, Debt) or its Asset Allocation (e.g. Risk Free Portfolio Part, Risk Based Portfolio Part) or Region. You can do that in the Taxonomies tab. This categorization will be useful when viewing charts.
Portfolio Performance has a concept of Deposit Accounts and Securities Accounts. A Deposit Account is where the „money“ is deposited to/withdrawn from, as well as where dividends are credited. A Securities Account is where you hold the different ETFs.
You will have to create a Deposit Account and a Security Account.
Creating a deposit account:
- Click on the the „Deposit Accounts“ tab
- Click on the „+“ sign on the top right corner
- Select „Add account“
- Change the name of the new Account from „No Name“ to your account name (e.g. DeGiro). You may also change the currency of the account.
Creating a securities account:
- Click on the „Securities Accounts“ tab
- Click on the „+“ sign on the top right corner
- Click on „Add securities account“
- Change the name of the new Account from „No Name“ to your account name (e.g. DeGiro).
- Change the associated „Reference Account“ to the appropriate Deposit Account. Securities Accounts and Deposit Accounts are linked so that for example, dividends from a ETF are credited to the correct deposit account or purchases are debited from the deposit account.
The purpose of the accounts is so that you can record your transactions. This is where you will spend the majority of our time. In the Deposit Accounts you can add “cash” related transactions like „Deposit“, „Withdrawal“, „Fees“, etc.
In the Securities Accounts you can add „ETF“ related transactions like „Buy“, „Sell“, „Dividend“.
A typical workflow you will see is something along the lines of:
- Create a „Deposit“ transaction in the Deposit Account
- Create a „Buy“ transaction in the Securities Account
- Create a „Dividend“ transaction in the Securities Account
Creating other types of transactions is as easy as the example transactions shown above.
In the reports section is where you will find charts and metrics of your portfolio.
The „Statement of Assets“ subsection has a global overview of the market value of all your open positions.
The „Holdings“ subsection shows your portfolio in a pie chart.
The „Performance“ subsection has key indicators for your portfolio like volatility, internal rate of return, drawdown.
The tabs under the „Performance“ subsection – Calculation, Chart, Return/Volatility, Securities, Dividends – allow you to dive into more specific details of your portfolio’s performance. In those tabs you can answer questions like:
- what is the total amount of capital gains?
- what is the total amount of dividends?
- how much have I spent in taxes?
- how has the portfolio grown over time?
- how is the performance breakdown per ETF?
The „Chart“ tab of the „Performance“ subsection allows you to compare your portfolio against a benchmark. A benchmark can be any ETF you add to the „Securities“ section.
To add a benchmark you have to click on the settings wheel and then click on „Add benchmark…“.
Then you can select a benchmark from one of the „securities“ you added and press „Ok“.
You can remove a benchmark from the graph by clicking on the name of the benchmark from settings wheel.
Taxonomies is how you categorize your ETFs. Categorizing ETFs allows you to see how much of each category you are exposed to.
You can have categories for „Asset Classes“ like Equity, Cash, Debt, Real Estate, etc.
Categories can be used so you can analyze how well you are doing in regards to your target allocation. You can use the „rebalance“ menu to set your target allocation and compare it to your “actual” allocation.
You can create new taxonomies by clicking on the „+“ button. There are a few „template“ taxonomies you can use or you can create something entirely new.
As I mentioned earlier in the „Securities“ section, taxonomies are assigned to your ETF in the „edit“ menu of a security.
In the „Currencies“ subsection you can see the evolution of currency exchange rates between two currency pairs.
In the „Settings“ subsection you can edit the data sources used for things like pulling historical prices.
I haven’t spent any time using the features of this section.
Exporting to CSV
You can export data to CSV from the application’s menu bar „File > Export …“. There you can select which information you want to Export.
Many thanks to @indexfundinvestor.eu for creating the initial version of this tutorial. Please help keeping it up to date by editing it.