Import a New Portfolio

In Stock Rover it is possible to import a portfolio, which means that you can import portfolios from most brokerage houses, as well as portfolios contained in spreadsheets and portfolios that have been exported from Stock Rover.

To import from a file right click on ‘Portfolios’, and select ‘Create Portfolio’ and in the following screen, select ‘Import from file’.

portfolio

You can also import a portfolio from the Stock Rover’s Investors’ Library. For more information on the Investors’ Library, please see the Library help documentation.

Please note that you cannot combine two portfolios by importing one into the other.

Note to Mac users: You may need to save your .csv or .txt portfolio file as a Windows CSV file from Excel before importing.

Importing by Quantity

The format of the file you import is typically an Excel spreadsheet, or a CSV or text file (.csv, .xls, .xlsx or .txt). When importing by quantity you will want to select the Content Type, “Holdings on One Date”, as shown in the screenshot below.

portfolio

After selecting the content type, click ‘Browse’ to navigate to the file that you want to import.

This type of file should have the headings Ticker and Quantity. It can also have a Price column. If the price column exists, it will be used for the cost basis. If it is omitted, the current price for the stock, ETF or fund will be used as the cost basis.

If the file has a Buy Date column, it will be ignored since the Position As of date, which is specified in a dropdown in the import window is used as the buy date. Enter an ‘Position As Of’ date for the start of the portfolio, as called out in the screenshot above, which will be used to keep track of your historical positions, as well as be utilized in the Portfolio Analysis facility. As shown in screenshot above, you can look over the portfolio to ensure it was read correctly.

If there is a column that was not labeled correctly on the import, and as a result does not match properly to the Ticker, Quantity and/or Price columns, you can fix this by selecting the proper column header you would like to assign to Ticker, Quantity and/or Price as shown in the screenshot below.

portfolio

If it was read correctly, click ‘Import’ button, as highlighted in the screenshot above, and the portfolio will be added under ‘Portfolios’ in the Navigation panel.

The contents of the an example import file is shown below:

Ticker, Quantity,  Price
AXP,  200,  124.77
BK,  400,  50.29
COP, 250, 64.01

Please see the sample files below that can be imported into Stock Rover:

Sample Quantity Portfolio Import Text File
Sample Quantity Portfolio Import CSV File
Sample Quantity Portfolio Import XLSX Text File
Sample Quantity Portfolio Import XLS Text File

Importing by Percent

Portfolios can also be created by percent. The file format required for importing by percent has to be a CSV or text file (.csv or .txt).

When importing by quantity you will want to select the Content Type, “Holdings on One Date”. The headers of the column Ticker and Quantity are still required but in the place of the Quantity value you enter the percent. If the price column exists, it will be used for the cost basis. If it is omitted, the current price for the stock, ETF or fund will be used as the cost basis.

If the file has a Buy Date column, it will be ignored since the Position As of date, which is specified in a dropdown in the import window is used as the buy date. When using percentages to create portfolios you must have a Cash amount. If the import doesn’t have a cash value, you will be prompted for one while performing the import.

The contents of the an example import file is shown below:

Ticker, Quantity,  Price
GM,  30%,  53.99
IBM,  30%,  121.74
KO,  30%,  42.49
WMT,  10%,  128.32
CASH,  100000,  1.0

Please see the sample files below that can be imported into Stock Rover:

Sample Percent Import Text File
Sample Percent Import CSV File

Importing with History

Another option with importing portfolios is importing the history of the portfolio. This option can be done with changing the Content Type and selecting, “Purchases on Different or Multiple Buy Dates” or “Import from Stock Rover Full History Export”.

From External Files

Select Content Type “Purchases on Different or Multiple Buy Dates (Partial History)”, see screenshot below.

portfolio

With this import, the Ticker, Quantity and Buy Date columns are all required. The quantity column refers to the number of shares purchased by the portfolio on the date. If a sale occurs on a given date, simply enter a negative quantity for shares. The Price column for setting the cost basis is optional. If the price column is omitted, it will use the current price for the stock as the cost basis. As shown in screenshot above, you can look over the portfolio to ensure it was read correctly, and make any changes as needed. If it was read correctly, click ‘Import’ button, as highlighted in the screenshots above, and the portfolio will be added under ‘Portfolios’ in the Navigation panel.

The contents of the an example import file is shown below:

Date,  Ticker,  Quantity,  Price
7/31/2019,  AXP,  100,  124.77
7/31/2018,  AXP,  200,  130.50
7/31/2017,  AXP,  300,  150.00

Note here is a list of the valid date formats:

  • 7/31/2020
  • 07/31/2020
  • 7/31/20
  • 07/31/20
  • 2020-07-31

Please see the sample files below that can be imported into Stock Rover:

Sample History Portfolio Import Text File
Sample History Portfolio Import CSV File
Sample History Portfolio Import XLSX Text File
Sample History Portfolio Import XLS Text File

From Stock Rover Export

Select Content Type “Import From Stock Rover Full History Export”. This is used if you have have exported a portfolio from your own account in Stock Rover format or received a portfolio from another Stock Rover user in Stock Rover format and would like to import it into your account.


Top
Create a New Portfolio Update a Portfolio