Skip to main content

How to Resolve 13F Missing Data for MarketValueInInstrumentCurrency

Updated over a week ago

Overview

When reviewing your 13F results in FundApps, you may see Missing Data alerts for MarketValueInInstrumentCurrency.

MarketValueInInstrumentCurrency represents the value of a position expressed in the instrument’s currency. If FundApps 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

FundApps 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, FundApps cannot calculate the market value.

Missing MarketValue

If Price is not provided, FundApps looks for MarketValue instead. MarketValue is an asset-level property.

Missing MarketValueInInstrumentCurrency

If Price and MarketValue are both missing, FundApps expects MarketValueInInstrumentCurrency to be provided.

If none of these three fields are 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; if it is not provided, FundApps 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:

  1. Provide Price

    • Add Price to the instrument.

    • Include prices for any underlying instruments, where applicable.

  2. Or Provide MarketValue

    • Add MarketValue at the asset level.

  3. Or Provide MarketValueInInstrumentCurrency

    • Add this property to the asset(s) if neither Price nor MarketValue can be supplied.

  4. 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 FundApps support via the In-App Messenger or by emailing [email protected] for additional help.

Did this answer your question?