Blog

Importing your portfolio just got easier

by Scott Ryburn, CTO, Sharesight | Aug 10th 2011

We know from the feedback that we get that the biggest challenge for many new customers is getting their historic portfolio set up Sharesight. One of our goals is to make it as easy as possible for you to get your data into (and out of) Sharesight. Last week we released some improvements to our file importer to make it compatible with a much broader range of spreadsheet files.

The first step is getting a list of all of your trades into a spreadsheet. Thankfully this is easier than it sounds as most online brokers allow you to export a copy of your trading history in a form that can be opened up in a spreadsheet program such as Microsoft Excel.

Provided that your spreadsheet contains one row per trade and one column per attribute (price, quantity, date etc) it is now much easier to import this data into Sharesight.

Importing your data in two easy steps:

1. Save your file in CSV format

Save as CSV

Once you have the data in a spreadsheet, you need to choose ‘Save As’ and save the file as a CSV file. CSV stands for ‘comma separated values’ and is basically just a plain text file without any extraneous formatting information.

2. Upload to Sharesight

Column Selection

To access the file importer, click ‘Add New Security’ then click ‘Bulk Import’ and click on the ‘Import CSV’ button.

Once you have selected your file to upload you may need to specify what piece of information is contained in each of the columns you want to import.

You have the chance to add, modify, or delete any data before it is finally imported into your portfolio. Sharesight won’t let you import invalid data, but if there are any problems they will be clearly highlighted so that you can fix them up.

FURTHER READING

Top20 NZX monthly Mar24

Top 20 NZX trades by Sharesight users – March 2024

by Stephanie Stefanovic | Mar 28th 2024

Welcome to the March 2024 edition of Sharesight’s monthly NZX trading snapshot, where we look at the top 20 trades Sharesight users made on the NZX.

Top 20 US month Mar24

Top 20 trades in US stocks by Sharesight users – March 2024

by Stephanie Stefanovic | Mar 27th 2024

Welcome to the March 2024 edition of Sharesight’s monthly USA trading snapshot, where we look at Sharesight users’ top 20 trades in US stocks.

Top20 ASX monthly Mar24

Top 20 ASX trades by Sharesight users – March 2024

by Stephanie Stefanovic | Mar 26th 2024

Welcome to the March 2024 edition of Sharesight’s monthly ASX trading snapshot, where we look at the top 20 trades Sharesight users made on the ASX.