Portfolios with Holdings in Multiple Currencies

The holdings in the portfolio can be in any currency. For example, if your portfolio's base currency is CAD, you can have securities that trade in CAD and USD. Or if your portfolio's base currency is EUR, you can have securities that trade in EUR, GBP, CHF and USD. There are no restrictions on what holdings you can have in a portfolio.

In the Prices and Fundamentals view, StockMarketEye will display the native values for each holding. For example, a holding that trades in USD will display the Market Value, Gains and other columns in USD; a security that trades in CAD would display in CAD.  The native values will be converted automatically to the portfolio's base currency when StockMarketEye computes the values for the Total line.

The standard columns, such as MktVal or Gain show the values in the native currency of the holding. 

If you'd like to see the converted values (i.e. the native values converted to the portfolio's base currency), you can add any of the "Ccy" columns. For example, you can add the "MktVal Ccy" column to see the converted market value; or the "Gain Ccy" to see the converted gain of this holding.  There are many other "Ccy" columns that you can add (hint: search for "ccy" in the Available Columns field in the column configuration window).

You can also add the "FX" column to see the current exchange rate. The FX rate is updated automatically when new quotes are retrieved. The "Currency" column shows the holdings native currency.

User's Guide:  How to Configure Columns in StockMarketEye

When you add a security that trades in a different currency, you should check the "Currency Options" section of the entry window to verify the currency and exchange rate at time of purchase. The currency selected in the "Currency Options" section should be the currency in which the security trades (i.e. a stock that trades on the US exchanges would be USD; a stock that trades on the Canadian exchanges would be CAD; a stock that trades on the Frankfurt exchange would be EUR). All the values in the entry window (such as Price, Commissions, Fees and Net Total) should be in that same currency.

The exchange rate should be the rate between that currency and the portfolio's base currency at the time of the purchase. StockMarketEye will automatically update the exchange rate to the exchange rate from the selected "Date" field when you select a different currency in the "Currency Options" section. If you have a specific exchange rate from your brokerage statement, you can enter it in the Exchange Rate field.

The currency in the "Currency Options" section will initially be set by StockMarketEye. Sometimes, however, StockMarketEye can not determine which currency to use, or a security will trade in a different currency than most other securities on an exchange (for example, a fund that trades in USD, but is listed on the London exchange). In this case, you can set your own by clicking on the "Change" button and selecting a different currency. See this page in our user's guide on changing a holding's currency:

User's Guide:  Changing a Holding's Currency

StockMarketEye uses the FX rate defined at purchase when calculating column values such as Gain, Gain%, TR, TR%, CastBasis Ccy, etc. The FX rate defined at purchase (in the "Currency Options" section described above) is available in the "Buy FX" column of the Prices or Fundamentals view column.

If you are seeing discrepancies that could be potentially be attributed to FX issues, you should verify these transactions in the Transactions report. Open the Transactions report and filter for the security in question. Then verify that the Currency and FX columns (add these columns to the view if necessary) have correct values for the security involved. You can make changes to those transactions if necessary.

After making any changes in the Transactions report, if the changes do not appear to be reflected in the Prices/Fundamentals views, you may need to rebuild your Prices view from the transactions.