Why Don't My Investments Add Up Correctly in the Totals?

The Total line in the Prices view shows you the sum total of the individual investments currently held in your portfolio.  For example, for a monetary column such as "MktVal" (market value), StockMarketEye will essentially add up all of the individual values in that column and display the value in the Total line.

For more information on the various metrics and columns available in the Prices view, see the section on Investment Metrics - Current Holdings

If the values in the Total line do not seem to add up correctly, it is often due to one of the following:

Individual Holdings in Different Currencies

Your portfolio can contain holdings that trade in different currencies. For example, you can have a portfolio that has individual holdings in USD, CAD and EUR. The investment's native currency values will be shown on their line in the Prices view.

On the other hand, the Total line of the portfolio has only one currency. In order to add up the individual holding's values for the Total line, StockMarketEye must convert any holdings from their native values to the currency used in the Total line.

The converted values are shown in the "Ccy" columns. For example, the "MktVal Ccy" column shows the holding's native market value converted to the currency of the Total line.

There are many different "Ccy" columns that you can add to your prices view - MktVal Ccy, Gain Ccy and TR Ccy, just to name a few. See this page for how you can add columns:

You may also want to add the "FX" column to your Prices view. This column shows the current exchange rate used by StockMarketEye to make the conversion from the individual holding's currency to the currency shown in the Total line. This exchange rate is downloaded automatically each time StockMarketEye retrieves the current quotes for that portfolio.

For more information on multi-currency portfolios, see the section, Portfolios with Holdings in Multiple Currencies

Changing the Currency of the Portfolio

By default, StockMarketEye uses USD as the currency for all portfolios. You can change this default in the Preferences -> General tab.

If you create a portfolio in USD, then add individual investments that trade in different currencies (CAD, EUR, etc), those investments will have an exchange rate set. The exchange rate is stored in the individual holding's "buy" transaction. It is the exchange rate between the investment's native currency and the currency of the portfolio on the date of the transaction.

Later on, if you decide that you want the portfolio (ie. the Total line) to be in a different currency, you can change the portfolio's currency in the Properties -> Currency tab.

However, when changing the currency of a portfolio, StockMarketEye does not automatically update the exchange rates in the transactions. This can lead to a Prices view whose Total line does not "add up".

To fix this situation, go into the Transactions report of your portfolio and update the exchange rates of the transactions.  You make these changes to the FX rate either in the Details window in the Currency Options section for a particular transaction.

Or in the directly in the specific cell in the table - click to select the transaction's line, then click again in the FX cell of that line:

A Typical Scenario

A typical scenario is this: you create your first portfolio with a default currency of USD. You then add your individual investments, which are in a different currency, say CAD. After adding a few holdings, you realize that the Total line is in USD and not in CAD. You then open the Properties window of that portfolio and change the currency to CAD. But even afterward, the Totals don't seem to add up.

Unfortunately, changing the currency of the portfolio does not automatically change the exchange rates in the transactions. You'll have to go into the Transactions report and update the exchange rates to 1.0 as described above. After that, the Totals will add up as you expect.

Still need help? Contact Us Contact Us