Portfolio Value by Currency Calculator
Convert entered holdings to a selected total currency using manual exchange rate quotes. Review the total and value shares grouped by denomination currency.
How the calculation works
Choose a total currency, then enter a name, currency, quantity, and unit price for each holding. The local value is quantity multiplied by unit price. A zero quantity leaves that row inactive. A blank price on a positive quantity is incomplete, while a zero price is allowed.
For a holding in another currency, enter a manual quote in units of the selected total currency per 1 unit of holding currency. With USD selected, a quote of 1.10 for EUR means 1 EUR = 1.10 USD. Quotes are not fetched from a market feed and are cleared when you change the total currency.
The calculator converts each complete holding and sums the values. It shows the total in the selected currency and percentages grouped by each holding’s denomination. Missing quotes or invalid active values prevent the full total from appearing.
Use Portfolio Rebalancer Calculator to compare weights after entering converted values there. Use the Real Return tool to apply an inflation assumption to a value.
Step by step
- Choose a total currency and enter holding details.
- Add manual quotes in base currency units per 1 holding currency unit.
- Review the total and shares grouped by denomination currency.
Worked example
Enter a USD holding with quantity 10 and unit price 100, plus a EUR holding with quantity 5 and unit price 200. Set the USD base quote to 1.10 USD for 1 EUR.
The USD holding is worth $1,000 and the EUR holding converts from €1,000 to $1,100. The total is $2,100. The denomination shares are 47.62% USD and 52.38% EUR.
When to use this calculator
Use this calculator when you have holding values in more than one currency and want to express them in one selected currency using quotes you provide.
Use the result as a converted snapshot of the entered values. The currency groups follow each holding’s denomination and do not show the underlying currency exposure of a fund or company.
Common input mistakes
Check the quote direction. With USD as the total currency, the EUR quote is USD units for 1 EUR, not EUR units for 1 USD.
A missing quote is not treated as a zero value. Add a valid quote for every active foreign currency holding before reading the total.
Calculation
Local holding value = quantity × unit price
Converted value = local value × manual quote when currencies differ
Portfolio total = sum of converted holding values
Denomination share = converted value grouped by holding currency / total × 100
The quote is units of selected base currency per 1 unit of holding currency. Each converted holding is rounded to two decimal places before denomination totals, including currencies that normally use zero decimal places. Percentages are rounded independently and may not add up to exactly 100%. Denomination grouping is not a measure of underlying revenue exposure or currency hedging.
Assumptions and limits
Prices and exchange rates are manually entered scenario assumptions, not live market data. The calculator converts values and groups them by the currency label on each holding. It does not look through funds or companies, measure revenue currency, model hedging, or include fees, taxes, or trading costs.
Key terms
- Total currency
- The selected currency used to express the converted total and each holding value.
- Manual exchange rate quote
- The number of selected base currency units for one unit of a holding currency.
- Denomination currency share
- The share of converted value grouped by the currency selected for each holding. It does not identify underlying economic currency exposure.
Related calculations
After converting values, use Portfolio Rebalancer Calculator to compare entered holdings with target weights. You must enter those values there yourself.
For an inflation adjusted value, use the Real Return tool to apply an inflation assumption to a value you provide.
FAQ
Which direction should an exchange rate use?
Enter the number of selected base currency units equal to one unit of the holding currency. For example, with USD selected as the base, enter 1.10 for 1 EUR when the scenario uses 1 EUR = 1.10 USD. A quote in the reverse direction is not valid for this field.
What happens when a quote is missing or invalid?
Enter a manual quote for every nonzero foreign currency holding. If an active holding is missing a quote or has a nonpositive quote, the calculator withholds the portfolio total instead of treating the unconverted holding as zero.
What does the currency percentage represent?
The percentage groups entered holdings by the currency selected for each holding, after conversion into the selected total currency. It does not measure the currencies of a company’s revenue, a fund’s underlying securities, or any currency hedge.
Are the exchange rates live?
No. The calculator does not fetch exchange rates or security prices. Enter prices and manual quotes for your own scenario.
How are zero quantities and blank prices handled?
A holding with quantity zero is inactive. A positive quantity with a blank unit price is incomplete and blocks the total. A unit price of zero is valid and contributes zero value.
Related tools
Convert your entered holdings here, then enter the resulting values in Portfolio Rebalancer Calculator if you want to compare them with target weights.