- Stock Rover - https://www.stockrover.com -

Managing Portfolios Via Brokerage Integration

Introduction

This article shows you how to link your brokerage account(s) to Stock Rover so you can automatically monitor, analyze and research your portfolio(s) from within Stock Rover.

Stock Rover’s brokerage integration provides a complete view of all your portfolios, as it handles multiple portfolios within a brokerage, as well as portfolios maintained in multiple brokerage houses.

What is a Linked Portfolio?

Before jumping in, let’s define what a “Linked Portfolio” is.

A Linked Portfolio is a portfolio maintained in Stock Rover that is “Linked” to your brokerage portfolio. When you link your Stock Rover account to your brokerage(s), a read-only connection is established between your brokerage and Stock Rover. Once the connection is established, details for each portfolio are then retrieved by Stock Rover and updated nightly. This means that your portfolio(s) holdings in Stock Rover are always in sync with your portfolio(s) holdings in your brokerage account(s).

A Linked Portfolio is the easiest and most efficient way to keep your portfolio up to date in Stock Rover and ensure that Stock Rover’s Portfolio Analytics [24] is evaluating all portfolio activity.

If you prefer not to connect to your brokerage, Stock Rover also supports Manual Portfolios, where you manually update the holdings in a Stock Rover portfolio to match those of a portfolio in your brokerage. Manual Portfolios are also handy when you want to create your own model portfolio(s).

Brokerage Connect

You create a Linked Portfolio using the the Brokerage Connect [25] tool in Stock Rover. Brokerage Connect uses Yodlee [26], a trusted [27] cloud-based account aggregator to establish a read-only connection to your brokerage(s).

A quick word about safety and security. Yodlee handles billions of transactions for millions of users. Their security policies are supervised by banking agencies and they comply with the Gramm-Leach-Bliley Act (GLBA) preventing the disclosure of personally identifiable information. Only Yodlee interacts with your account credentials and institutions. Stock Rover never handles and does not have access to your brokerage credentials.

Brokerage Connect is available to all Stock Rover subscribers, though the number of brokerage connections and portfolios supported differ based on your plan [28]. Even free users can access Brokerage Connect, with the same limits as Essentials users.

Brokerage Connect [29]

Yodlee’s brokerage integration provides end-of-day positional data. This means that when an investor connects Stock Rover to their brokerage(s), daily portfolio positions are returned by Yodlee and synchronized with corresponding Linked Portfolios inside of Stock Rover.

Because Stock Rover’s portfolio tracking is position based, we do not capture the gains or losses from day trading (holding a position for less than a day), or from selling at a better price than the closing price. However the results will show up indirectly via a change in your cash position and account value. Note that the analytics still tend to be very accurate, as missed gains or losses tend to average out.

Accessing Portfolio Manager

Portfolio Manager gives us access to all things related to portfolios.

Portfolio Manager functions include the ability to view and modify a portfolio’s positions or, if we prefer, view and modify the underlying buy and sell transactions.

As we’ll see in a bit, there may be instances where we will need to access Portfolio Manager to affect changes to a Linked Portfolio.

  1. Select Portfolios from the Start Menu
  2. Choose the desired Portfolio in the Navigation Panel
  3. Select Modify this Portfolio in Portfolio Actions or sight

portfolio manager [30]

Positions

The example below is showing a portfolio of four positions.

portfolio positions [31]

Transactions

Although Stock Rover is position based, we do support transactions. Stock Rover’s transactions provide an audit trail, tracking why a position changed. Stock Rover infers “buy” and “sell” transactions based on the change in positions.

The transactions listed below were inferred based on the change in end-of-day positional data provided by Yodlee.

portfolio transactions [32]

Managing a Linked Portfolio

When a Linked Portfolio is initially created, the most current portfolio positions are returned. Going forward the Linked Portfolio will then be updated when the holdings in the brokerage portfolio change.

Below we’ll delve into how Stock Rover handles portfolio history and how you can add additional portfolio history. We’ll also show how you can make adjustments to a Linked Portfolio on the rare occasion where the data returned by the brokerage is incorrect.

Linking

To create a Linked Portfolio we’ll first want to launch Brokerage Connect. There are several ways to access the tool. The first way is by clicking selecting ‘Brokerage Connect’ in the Start Menu.

Brokerage Connect [33]

You can also select ‘Brokerage Connection’ under Portfolio Actions or when your are in the Portfolio Manager [34], select ‘Brokerage Connect’ under ‘More Actions’. Both options are highlighted below.

launch brokerage connect [35]

When you launch Brokerage Connect you’ll be connected to the Yodlee interface, where you’ll then be able to search for your brokerage house.

Below we searched for and found Fidelity and are now being prompted for our brokerage account login information.

Brokerage Connect [36]

Once the connection has been verified, you will see the Brokerage Connections panel in Stock Rover with your portfolio(s) from the linked account loaded.

Below is an example of a Fidelity Investments brokerage account connection with one portfolio.

Brokerage Connect Fidelity [37]

Renaming

By default, the portfolio(s) that appear in the Brokerage Connections panel will be linked to a new Stock Rover portfolio with the legal name of the portfolio as it appears in your brokerage account.

If you’d like, you can rename the Linked Portfolio in Stock Rover to something a bit more friendly.

You’ll first want to click on “Portfolios” in the Start Menu and then select the Linked Portfolio you’d like to rename in the left-hand Portfolios pane. Note that the icon next to the portfolio is slightly altered to indicate it is linked.

You can then either right-click on the portfolio and select rename or select ‘Rename this Portfolio’ under Portfolio Actions.

rename portfolio [38]

Position History

It is important to understand that when you first link your Stock Rover account to your brokerage account(s), Yodlee returns your portfolios’ current positions. Because only your current positions are known, the buy date for each of the holdings is set to the date the connection is established.

The example below is showing a first-time connection to a Linked Portfolio in the Portfolio Manager [34]. We can see via the Transactions tab that each of the portfolio’s positions was created on the date the brokerage connection was established which is January 23rd.

no portfolio history [39]

Going forward portfolio history is tracked and updated on a daily basis. Stock Rover will update your Linked Portfolio(s) to match your brokerage, based on the positional data returned by Yodlee.

Importing Past Position History

If you would like the Portfolio Analytics to account for position changes previous to the date that the brokerage connection was established, you will need to import past position history.

You can import your position history via the Import Updates option, available in the Portfolio Manager [34].

You will be importing .CSV or .XLSX files that each contain all the positions from a monthly or quarterly brokerage statement. It is important that these import files contain all portfolio positions. For example, if the file being imported only contains detail on 2 out of 5 of your holdings Stock Rover will assume you sold the 3 missing holdings.

You will want to import the files starting with the oldest brokerage statement and then move forward chronologically. Each time you import a file, Stock Rover will adjust your portfolio positions and infer the appropriate buy and sell transactions.

The Import Update option is initiated by selecting the “Import” button in the Positions tab in the Portfolio Manager. Before clicking on “Import” you want to make sure to set the “Positions as of” date to the brokerage statement date. To set the “Positions as of” date click on the calendar icon circled in the screenshot below and select appropriately.

import updates [40]

Clicking the Import button will then launch the Import Portfolio window, where you then Browse for the file and then select Import.

import portfolio [41]

Backcasting

Even without importing position history, you can always analyze your portfolio and view the historical performance prior to the date the brokerage connection was established via a Stock Rover feature called Backcasting.

Backcasting projects the holdings of the portfolio on the date of the portfolio’s earliest position record even further back in time, as far back as the earliest report date supported in Stock Rover, which is January of 2007. Backcasting can be enabled or disabled [42] on a per-portfolio basis.

Backcasting is enabled by default, however you can turn backcasting off so that Portfolio Analytics uses the earliest buy date entered in the portfolio as the earliest date it will report on. The “Explain” icon, highlighted in the screenshot below, provides a brief explanation of backcasting.

backcasting [43]

Tracking Assets

When Stock Rover updates a Linked Portfolio with new position data from your brokerage, the tickers are verified to make sure that they can be priced. If a position cannot be priced, then the ticker is classified as an “Asset”.

Assets help you distinguish between tickers that are included in Stock Rover’s research and analytics and those that are not.

An Asset will typically be classified as a Fund, a Stock, a Bond, or an Option, but there are also many other classifications. such as real estate or commodities. In the case of a Stock or a Fund that can’t be priced, it may be because the ticker is not listed on a supported exchange [44] or there was a glitch, where Yodlee returned incorrect information, in which case you can easily correct the misidentified ticker symbol.

If your Portfolio contains assets, they will be listed at the end of the list of positions in Portfolio Manager [34]. In the example below the symbol, MAX202745 is a Fidelity 529 College Saving Fund, which isn’t listed on an exchange. We can see that the MAX202745 ticker is listed at end of the alphabetical list of positions just after THO – Thor Industries.

portfolio manager assets [45]

When you load a Portfolio with Assets into the Table [46], an Asset summary row is displayed at the bottom. The screenshot below shows the portfolio’s positions along with a summary of Assets using the Portfolio Performance View [47].

displaying assets [48]

When you click “>” on the “> Assets” label, a popup will appear with details for each of the Assets. In our example, we have a single asset.

displaying assets [49]

Updating a Position

A Linked Portfolio will almost always match what is reported in your brokerage. With that said, there are rare occasions where you may need to update a position in your Linked Portfolio. A couple of the common cases where an update is required are listed below.

Cost Per Share

If the Yodlee feed returns the wrong Cost Per Share for a holding, the cost can be easily adjusted in the Portfolio Manager [34] to the correct value.

In the Portfolio Manager, you’ll want to choose the positions tab. You can then select the Cost Per Share cell that corresponds to the holding you would like to adjust and then update the price. The new Cost Per Share will remain until the portfolio gets an update from the brokerage with a change in the quantity.

update cost per share [50]

Brokerage Feed Corrections

On rare occasions the Yodlee feed can misidentify a symbol. Examples include assigning an outdated ticker symbol to a position, or the position being misclassified as a Bond instead of a Stock, or the brokerage using a different symbol for a security than Stock Rover does. In any case, a misidentified symbol cannot be priced and will therefore be categorized as an Asset. However, you can correct this so it shows as a priced position, if Stock Rover can price it.

Correcting a misidentified symbol is straightforward. You begin in the Portfolio Manager [34] and choose the appropriate portfolio, and then click on the Positions tab. While in the Corrections column, you will then click on the Edit button that corresponds to the misidentified symbol.

correcting misidentified symbols [51]

A Brokerage Feed Corrections window will then appear. Here you can enter and then “Save” your Corrected Value(s).

correcting misidentified symbols [52]

Troubleshooting Brokerage Connect

Let’s begin by doing a quick review of how Brokerage Connect works.

When the Brokerage Connect tool connects to your brokerage, it performs a portfolio discovery. For each discovered portfolio, a Linked Portfolio is created in Stock Rover.

Brokerage Connect then updates each Linked Portfolio with the portfolio’s positions returned by the brokerage. The position data returned by the brokerages mirrors what you see on your brokerage statement; where you have a line for each holding with the ticker, quantity, and cost per share.

Note that corresponding buy and sell transactions are inferred by Stock Rover, based on the changes in portfolio positions. This allows you to to easily track position history as well as the transactions necessary to effect the position changes.

Brokerage Connect updates a Linked Portfolio…

  1. when the brokerage portfolio is initially discovered
  2. when you log into Stock Rover
  3. on a nightly basis
  4. when you manually “Refresh”
  5. when you update your brokerage credentials

The synchronization of your Linked Portfolio with your brokerage is almost always transparent. However, for those rare occasions where a Linked Portfolio is not in sync with its brokerage here are some helpful troubleshooting tips.

How to See if Your Portfolio is Up To Date

When you launch Brokerage Connect there is a status indicator next to the Brokerage name that tells you whether the last connection was successful and the date and time of that connection.

Successful Update

Below is an example of a successful update by Brokerage Connect to a Linked Portfolio called “Fidelity Investments – Joint”

  1. The green checkmark icon tells us a connection was successfully made to Fidelity Investments
  2. The connection was successfully established on January 19th, 2023 at 9:11PM
  3. The portfolio’s last trade occurred on January 6th, 2023

brokerage connect success [53]

Unsuccessful Update

Below is an example of Brokerage Connect failing to connect. An update was initiated by clicking on the gear to the far right of Fidelity Investments and selecting “Refresh”.

  1. The yellow icon tells us the connection to Fidelity Investments failed
  2. The connection failed on January 30th, 2023 at 3:04PM

brokerage connect failed [54]

There are a number of scenarios that can cause a Brokerage Connect to fail:

  1. The brokerage itself may be experiencing an outage
  2. Multifactor authentication is enabled for brokerage access
  3. The brokerage may make itself unavailable during certain hours of the day.
     
    For example, Fidelity Investments doesn’t allow access between 9:00 AM – 10:30 AM EST and 3:00 PM – 4:30 PM EST.

Reasons to Force an Update

  1. If your Brokerage Connection failed recently, you can force an update to see if the problem is a one-time issue or whether the issue is persistent.
  2. If you change the password to your brokerage, you’ll need to reauthenticate in Brokerage Connect.
  3. Multi-factor authentication – some brokerages require the texted code to be entered every time an update is initiated.

If you are experiencing a connection problem, do not delete the brokerage connection, as doing so will delete all the portfolio’s history and you’ll then need to Import Updates from your monthly or quarterly brokerage statements.

How to Force an Update

Although Brokerage Connect automatically updates your Linked Portfolio, you can manually force an update.

You’ll want to:

  1. Select Portfolio Tools in the Start Menu and then select Brokerage Connect.
  2. Click the Gear next to the brokerage and select Edit Credentials.
  3. edit credentials [55]

  4. Click Update

    The “Edit Credentials” window is unique to each brokerage. In our example, we are showing what the “Edit Credentials” window looks like when we select a Fidelity Investments brokerage account.

    – You only need to re-enter your account information if your password has changed.
    – If you see the message “You are linking to the same account again which is currently in progress“, this means an update is already in progress. You’ll want to click “Done” and wait a few minutes for the current update to complete. You can then click the Gear next to the brokerage and select Edit Credentials.
      – If the issue is persistent and you cannot successfully force an Update you can request assistance by emailing support@stockrover.com [56].

    update credentials [57]

  5. If you have multi-factor authentication enabled then you will need to enter the texted code or answer the security question sent to you by your brokerage, then the update to your brokerage will continue.

Note: When you force an update, the brokerage returns whatever position data it has at that moment. Changes to your portfolio that result in new positions, changes in quantities of existing positions and/or removal of positions will all show in Stock Rover once they have settled in your brokerage.

Summary

We hope you have found this post on Brokerage Connect useful. Brokerage connect is a safe, secure way to automate your portfolio tracking across multiple portfolios and brokerages.

Once the brokerage connections are made, everything is automatic. Your portfolios within Stock Rover are kept up to date and accurate with zero work on your part.

Brokerage connect is a real time saver. It allows you to focus on how your portfolios are performing, rather than the mechanical work of keeping them accurate and up to date by hand.