Contents
In Stock Rover it is possible to import a portfolio, which means that you can import portfolios from an export from most brokerage houses, as well as portfolios contained in spreadsheets, portfolios that have been exported from Stock Rover, and portfolios from our library.
To import from a file right click on ‘Portfolios’, and select ‘Create Portfolio’ and in the following screen, select ‘Import holdings from file’.
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.
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.
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 the price column is omitted, then the close price for the selected Position as of date will be used as the cost basis.
Enter a ‘Position As Of’ date for the start of the portfolio, as called out in the screenshot above. The Position As Of date is used to keep track of your historical positions and is also referenced in the calculations of the Portfolio Analytics facility. The display allows for the review of the portfolio’s holdings before importing to ensure it was read correctly. If the file has a Buy Date column, it will be ignored since the Position As of date is used as the Buy Date.
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.
If it was read correctly, click the ‘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, PriceAXP, 200, 124.77BK, 400, 50.29COP, 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
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 the price column is omitted, then the close price for the selected Position as of date 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.
Ticker, Quantity, PriceGM, 30%, 53.99IBM, 30%, 121.74KO, 30%, 42.49WMT, 10%, 128.32CASH, 100000, 1.0
Sample Percent Import Text File Sample Percent Import CSV File
Another option with importing portfolios is importing the history of the portfolio. This option can be done with changing the Content Type and selecting, “Multiple Dates” or “From Stock Rover Export”.
Select Content Type “Multiple Dates”, see screenshot below.
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, then the close price for the Buy Date will be used 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.
Date, Ticker, Quantity, Price7/31/2019, AXP, 100, 124.777/31/2018, AXP, 200, 130.507/31/2017, AXP, 300, 150.00
Note here is a list of the valid date formats:
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
Select Content Type “From Stock Rover 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.
The Browse Portfolio Library link as highlighted below, brings you to our Library where you can import any of the portfolios we have available. Please see our Library help for more detail.
