Blog

Import foreign exchange transactions via CSV

by David Olsen, Senior Marketing Manager — Content/SEO, Sharesight | Apr 24th 2018

We know from the feedback that we get that the biggest challenge for many investors is getting their portfolio set up in Sharesight. So one of our goals is to make it as easy as possible for you to get your data into (and out of) Sharesight. We recently released some improvements to our CSV file importer to allow you to import historical foreign exchange (or FX) transactions (including cryptocurrencies) to your Sharesight account.

Tracking foreign exchange investments in your Sharesight portfolio

We recently introduced Sharesight’s Foreign Currency tracking feature to allow investors to track foreign exchange accounts with intraday prices updated at 5 minute intervals, plus the ability to denominate brokerage fees in the currency being traded.

Currently 32 worldwide currencies can be tracked using the FX account feature – plus 8 cryptocurrencies – with additional currencies to be added in the future.

Import your historical FX transactions to Sharesight

The first step is getting a list of all of your FX transactions 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, brokerage, etc) it is now much easier to import this data into Sharesight.

Screen Shot 2018-04-23 at 11.17.36 am

Sharesight’s Import bulk trades via CSV feature lets you map foreign exchange transactions to a currency account holding for each currency held. Once imported you’ll be able to track the value of your FX holdings with prices updated every 5 minutes.

Screen Shot 2018-04-23 at 11.18.30 am

Sharesight is your passport for investing

Sharesight understands the importance of diversifying your investments internationally. Which is why Sharesight now tracks 30 markets around the world. Adding support for intraday foreign exchange rates is all part of our vision to be your passport to unlocking your true portfolio performance.

Unlock your investor passport today

  1. Sign-up for a FREE Sharesight account.
  2. Add your holdings to your portfolio(s).
  3. Sharesight converts the prices and valuations of your holdings from their listed market to your portfolio’s base currency – automatically – and continues to track currency fluctuations, including their impact on your performance!

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.