Overview
When reviewing your 13F results, you may see Missing Data alerts for MarketValueInInstrumentCurrency.
MarketValueInInstrumentCurrency represents the value of a position expressed in the instrument’s currency. If the rules engine cannot derive this value, it will be flagged as missing data.
This article explains what this field is used for, why it may be reported as missing, and what data you need to provide to clear the alert and allow your 13F results to calculate correctly.
Why This Happens
The system determines MarketValueInInstrumentCurrency using the following logic, in order:
Missing Price (Most Common)
The most common cause is that the instrument's Price input is missing from the positions file.
If the instrument has underlying components (for example, Warrant > Equity), prices for both the instrument and its underlying component are required. Without a price, it is not possible to calculate the market value.
Missing MarketValue
If Price is not provided, the system looks for MarketValue instead. MarketValue is an asset-level property.
Missing MarketValueInInstrumentCurrency
If Price and MarketValue are both missing, the system will look for MarketValueInInstrumentCurrency as a last alternative.
If none of these three fields is present, the rule will report Missing Data for the MarketValueInInstrumentCurrency property.
Bonds and Convertibles: Additional Considerations
For Bonds and Convertible instruments, this missing data alert is most commonly caused by a missing FaceValue input.
FaceValue is required to calculate the market value of these instruments; without it, the system cannot perform the necessary calculations.
If you are seeing missing data for either of these instrument types, check that FaceValue is included in your positions file.
How to Resolve
To fix a MarketValueInInstrumentCurrency missing data alert:
Provide Price
Add Price to the instrument.
Include prices for any underlying instruments, where applicable.
Or Provide MarketValue
Add MarketValue at the asset level.
Or Provide MarketValueInInstrumentCurrency
Add this property to the asset(s) if neither Price nor MarketValue can be supplied.
For Bonds and Convertibles
Ensure FaceValue is populated so the system can calculate market value correctly.
Once the required data is added, make sure to re-upload or rerun the applicable NAV Date to apply the changes.
Feel free to contact our Support team via the In-App Messenger or by email for additional help.