Tracking Canadian Mutual Funds that Trade in $USD

Several Mutual Fund products from Canadian providers trade in $USD. Example:

Previously, Portfolio suppressed the ability to view it in Holdings - leading to the impression that it was not held.

When purchased, it would only appear in the "Transactions" view and in the total market values.

Individual Portfolios now contains a new section within the Holdings view called "Funds (US$)" that properly displays these funds.

Example: Capture.PNG

"Funds (US$)" is also broken-out in the "My Investments" section on the main page.

Improved PDF Summary Reports

Changes include:

  • Recently-improved gain/loss calculations are included (at summary and position level)
  • Added breakdown by asset class to summary on first page
  • Corrected issue with asset allocation
  • Improved design (naming and formatting)

Investment Returns displayed in Percentages (%) in Summary and Filter Views

Returns represented as a percentage (%) have been added next to dollar values ($) throughout the Portfolio tool. New locations include:

  • Summary View
  • Portfolio Header
  • Price Performance (Filter)
  • Annual (Filter)

Example: https://www.theglobeandmail.com/investing/markets/portfolio/ Capture.PNG

Gains and Losses: Calculations & Percentages

The Globe Investor Portfolio tool has been updated to address feedback about gain/loss calculations and percentages.

Within the Annual Filter, Portfolio YTD (%) previously used a position's value from inception/historical purchase date, rather than the first day of the year.

  • For the purpose of annual calculations, we are now treating all gains as realized each year (all gains are realized at the end of the period).
  • The overall calculations (i.e. since inception values) remain unchanged.
  • Also, we elected to treat each lot as an at-risk investment, when calculating percentages.

For example, see the following scenario:

  • JAN 1, BUY 100 @ $10.00
  • JAN 2, SELL 100 @ $11.00
  • JAN 3, BUY 100 @ $10.00
  • JAN 4, SELL 100 @ $11.00

Total profit is $20. We can calculate gain percentage as follows:

  • 10% = $20/$200 (we have $200 invested/at-risk)

All annual percentages have been recalculated and applied to your account. These changes are now viewable with the tool.

Note: during the deployment of this improvement a percentage of users noticed if the position has a transaction on the last day of the previous period (e.g. 2018-12-31 for the YTD frame), then the following frame (YTD) displayed broken gains/losses. This bug has been corrected.

Missing Dividends - April

Dividends from 2019-04-14 and 2019-05-01 were not properly applied to transactions entered within the Portfolio tool.

This has been repaired and affected positions have been processed retroactively. If affected, you should see the correction within your account now.

We are acutely aware of the importance of income within our users' holdings and apologize for any inconvenience this has caused.

This error was caused due to a missed update file. Further, this issue was compounded as the programmatic notification designed to alert us in this event was configured incorrectly. We have taken steps to prevent this scenario in the future.

Changes to Cash Account Management

For "Cash" accounts it is now possible to switch position types under the "More" button:

  • When you switch a position to make cash adjustments, it creates all cash transactions for the position.
  • When you switch a position to not make cash adjustments, it deletes all cash transactions for the position.

This means that cash balances cannot be skewed by the timing of enabling or disabling cash adjustments.

When you alter a cash transaction type Portfolio will display the following:

Transactions for TICKER-T impact your CAD balance. When TICKER-T transactions are entered, corresponding debit (or credit) transactions are also entered into your CAD account. For example, when you buy shares, a your CAD cash account is debited to cover the cost of the purchase.

Changes to System-generated Transactions

Within Portfolio it is possible to view historical Transactions in the small pop-up modal next to a ticker, and with the Transactions view.

In both locations we have removed the ability to change system generated transactions. These transaction types can no longer be removed from view.

Standard transactions and cash transaction types, including:

  • Dividends and splits
  • Debit-for-buy, debit-for-dividend, credit-for-sell

This change is to assist the preservation of data integrity in Cash accounts. Reminder that it is possible to change and set system defaults to allocate dividends and distributions as recurring purchases, entered into cash, or ignored.

Corporate Action Maintenance: Impact on Cash-enabled Accounts

Throughout the month of April, the Portfolio team is conducting Maintenance for Dividend Ex- and Pay-Dates to better apply dividend ex, record and payment dates.

To properly complete this maintenance, it was necessary to reconstruct users who have enabled a "cash" account balances.

This means users who enabled a cash account may notice variances in their end-of-day balances. In some cases, this may result in a new, unexpected cash account balance:

  • Any deposit or withdrawal transactions you entered was preserved.
  • However, the system is now responsible for managing cash new transaction types arising from purchases, sales, and dividends.
  • As a result, any cash transaction related to a purchase, sale, or dividend was re-created.

Your new balance is mathematically correct, since all purchases, sales, and dividends are now accounted for. However, we realize the balance may not match your expectation. In that case, we'd encourage you to review the transaction history.

You have the following options:

  1. You can enter a deposit or withdrawal to adjust your balance.
  2. You can review, edit, or remove previous deposits or withdrawals.
  3. You can also configure stock, fund, and other positions to affect (or be excluded from affecting) cash account balances.

Reminder that cash accounts assemble a synthetic tabulation of a cash balance. The result is rebuilt data with a higher degree of accuracy. This work is now complete and your patience is appreciated.

Maintenance for Dividend Ex- and Pay-Dates

We are in the process of conducting Portfolio system maintenance to better apply dividend ex, record, and payment dates.

  • Presently, all dividends paid after January 2019 now carry both the correct pay- and ex-date within your Portfolio account.
  • This will also retroactively fix variance caused in Portfolio valuations that may have occurred in the past.
  • We will continue to process and test retroactive batch updates in the coming weeks to be the beginning of user transaction digitization.

There is no action required and no loss of service access. Thank you for your patience as we conduct this maintenance during the month of April.

Custom View - Income Data

Within the Portfolio tool it is now possible to keep track of income earned over time from dividends and distributions using "Custom Views". To enable income tracking:

Step 1. Select "Create/Edit Custom Views" from the main Views dropdown:

1.png

Step 2. Create a view and open the "Portfolio" section. Select "Income Inception" and/or "Income YTD". Save.

2.PNG

Step 3. Select your new Custom View.

3.PNG

UPDATE: February 1, 2019

For investors looking to project future equity dividend income, we have launched "Income Forward". This option allows you to forecast the amount of dividend data you expect to receive in the upcoming calendar year.

This is calculated by multiplying the most-recently paid dividend times dividend frequency. For example, on a company paying $1 on a quarterly basis, if you held one share, your Income Forward would be $4.

No published changelogs yet.

Surely Globe Investor Portfolio will start publishing changelogs very soon.

Check out our other public changelogs: Buffer, Mention, Respond by Buffer, JSFiddle, Olark, Droplr, Piwik Pro, Prott, Ustream, ViralSweep, StartupThreads, Userlike, Unixstickers, Survicate, Envoy, Gmelius, CodeTree