Foreign Currency Valuation ReportContent also available for tax entities or on our global site.
Note: This report is only available on Expert and Sharesight Pro plans. You can upgrade your plan to use this feature.
The Foreign Currency Valuation Report in Sharesight allows you to see the value of the holdings (investments) in a portfolio denominated in the foreign currency of your choice, on any past date since your portfolio’s creation
The report calculates the final end-of-day value on the date selected for each holding in a portfolio, then applies the prevailing foreign exchange rate to calculate the value in the foreign currency chosen.
To make this calculation, Sharesight uses intraday FX rates from Open Exchange Rates, with support for over 67 different currencies in the report.
The report shows all investments held within a portfolio on the report date. As well as:
- The currency each investment is denominated in
- The price per unit in that currency
- The number of units held
- The value of the investment in the investment currency
- The value in the base currency of the Tax Residency of the portfolio
- The foreign exchange rate used
- The value of the investment in the foreign currency chosen
The report also allows you to view values broken down along a number of default dimensions or use Sharesight’s Custom Groups feature to group investments according to your own classifications.
Running the Foreign Currency Valuation Report
Follow this guide for help on the various options available when running the report.
1- From any page click on the ‘Report’ tab2- Click the Foreign Currency Valuation Report tile
3- Select the date to run the report
From the dropdown date selector calendar, choose the date on which you would like to run the report. By default it is set to the current date.
4- Select the grouping to view in the report
- Sector Classification
- Industry Classification
- Investment type
- Do not group (Holdings)
- Custom Groups - If you have already created a Custom Group, you can view the holdings values via your own organised specifications.
If you haven’t already created a Custom Group, you can click the ‘Custom Group Settings’ to set up a Custom Group to organise your holdings into your own specifications.
5- Select the Foreign Currency to view the report in
Choose from over 67 foreign currencies (including common cryptocurrencies) from the drop down menu.
6- View the Foreign Currency Report
Wait for the report to finish running, then view the report, or make changes to the options selected to further customise the report.
Note: The currency FX rate used is indicated at the end of the report.
Last modified on January 7, 2021 UTC