MT5 Trade-Size Self-Diagnostic: Compare Notional Value Against Median × 2.5 and the IQR Upper Limit

1. What the tool does: compare by notional value

The main function is a notional-value comparison. Each closed position loaded from the Positions list of your MT5 HTML report (or entered as CSV) is converted to USD or JPY notional value with this formula (supplementary six-column CSV stays USD-only):

Notional (BASE) = lots × price × contract size × BASE per 1 QUOTE

For an HTML report, this “price” is the position’s opening price (the closing price is not used). For CSV, the price you write is used as it is.

Then, over all the records you entered, pooled as one dataset, the tool computes Type 7 quartiles and takes the smaller of the IQR upper limit (Q3 + 1.5 × IQR) and the Median cap (median × 2.5) as the “adopted threshold”, and counts how many records exceed it.

What it shows:

• The adopted threshold, the largest notional and the number of records above the threshold
• Q1, median, Q3 and IQR, with the two limits side by side
• The notional of each record and its difference from the threshold

What it does not do:

• Reproduce an official review by Funded7 or any other prop firm, or judge pass/fail or prize eligibility
• Suggest a safe or recommended lot size (it produces no such output)
• Verify whether specification candidates apply to your account and trading period, or whether the selected FX method is suitable (you must confirm these yourself)

The official Rule 1A and the notional-value logic are explained in the original guide. That guide is currently available in Japanese only.

📄 Original article (Japanese only) Funded7 Funded7 Complete Guide: IQR, the 30-Second Rules, Qualifying Trades and Payouts The original Funded7 complete guide covering Rule 1A, median / IQR and notional value. It is written in Japanese. Open the original guide (Japanese) →

2. Compare notional values

Choose HTML → review settings → calculate. See the headline count first, then open only the numbers you want to explore.

The default is one closed Positions row per record; you can switch to sums of continuous holdings on the same symbol and side. Standard FX is the equal-weight average of published business-day rates within the 14 calendar days immediately preceding the diagnosis. This estimates values at recent average rates, not at each historical opening time. Supplementary six-column CSV remains USD-only.

3. How to enter data, and what you must check yourself

Current Funded7 public specifications, two-week average FX and separate-entry comparison are selected by default. Load HTML, review the settings and press “Calculate with these settings”. This does not identify your account’s firm. For another firm, switch to your own checked specifications. Calculation mode, actual account settings and historical applicability remain unverified; no unchecked specification is marked as verified.

Current reference candidates cover all 73 official symbols, including 15 indices. Index contract sizes come from the official FAQ and quote currencies from the official calculators. Only GOLD → XAUUSD, WTI → USOIL and SILVER → XAGUSD are explicit aliases, shown on screen. No other alias, suffix or case change is inferred. Editing a value exits the public estimate and requires verification. Detailed opening-time FX also requires checking both specifications and rates.

The flow with an HTML report

1. Choose the Positions HTML file saved as described in chapter 2. Closed positions are loaded automatically. Positions are not reconstructed from Orders or Deals.
2. Use JPY for a yen-denominated account or USD for a dollar-denominated account. An explicit account-currency field initializes this choice when readable; otherwise, choose it yourself. This is separate from the currency in which a product is priced.
3. Current Funded7 reference specifications are filled in by default. For another firm or your own values, switch to manual input and verify the specifications in Details. Entries are compared separately unless you choose to combine them until fully closed.
4. Press “Calculate with these settings”. Required public rates are retrieved before all records are compared. Missing data or a retrieval failure withholds the whole result. Press again after changing a setting.

Split entries recorded as separate rows in the HTML are compared separately, using each row’s lots and opening price. In the default individual mode, rows are not summed merely because their symbol or time is similar. If netting or the export has already combined them, the original pieces cannot be recovered. Profit/loss aggregation is outside this tool.

The separate-entry default draws on guidance USK received from support in an individual inquiry. It is not presented as a formally published official rule or a reproduction of an official assessment.

Standard comparison: an estimate using the recent two-week average FX rate

USD/JPY and other rates change daily. Standard mode equally weights the published business-day rates within the latest 14 calendar days at diagnosis time. The screen shows the period, observation count and update time. This is not a reconstruction of each trade’s historical opening-time value. Missing or unavailable required rates withhold comparison; no current spot or fixed rate fills the gap.

The comparison base and the product’s quote currency are different. A USD-priced product still needs USD-to-JPY conversion on a JPY account. The factor is BASE per 1 QUOTE: at a fictional 150 yen per dollar, USD-to-JPY is 150 and the reverse is its reciprocal. Identical currencies use 1. Standard averages are calculated after deriving each daily conversion factor, so the opposite-direction average is not necessarily the reciprocal.

When you want to combine entries made in several parts

With the default Compare each entry separately, three 0.1-lot gold buys recorded on separate HTML rows are compared as three records: 0.1, 0.1 and 0.1.

Combine entries until fully closed combines the same symbol and buy/sell direction while holdings continue from the first entry through full closure. In this example, one record covers the three buys totaling 0.3 lots. An additional entry can join at a different time while holdings continue. Buying again after every position has closed starts a new group. Different symbols and buy/sell directions are never combined.

The lot figures above illustrate grouping, not the comparison metric. The tool adds the individual entry notionals, each calculated from its own opening price, volume and contract size, using the selected FX method. A later entry after a partial close is still included cumulatively when it is represented as a separate history row. This is not peak simultaneous notional or total lots multiplied by one price. Each sum becomes one observation for the same IQR, median and threshold formula. Profit/loss is not aggregated.

After switching, additionally confirm that the history contains every group from its first entry through full closure, omits no earlier or still-open holding, and represents entries separately. The tool cannot independently verify completeness. It does not reconstruct entries already merged by netting or positions absent from the history.

• If full closure and the next opening share the same second, combined comparison is withheld because their order is unknown. Individual comparison remains available.
• A row opening and closing in the same second is also withheld when combining entries.
• A partial close and additional entry at the same second can remain in one group when another position is still held.
• The six-column CSV has no side or opening/closing times, so CSV remains individual-only.

Results distinguish imported position rows from the resulting group count. “Source row numbers” in the grouped-entry table refer to the numbered import preview above. Grouping changes both the distribution and the observation count; do not compare counts as though the threshold stayed unchanged. Grouping is an additional check of combined size. It changes the median and IQR too, so it does not always produce a stricter result. Neither method reproduces an official assessment or guarantees compliance.

Where do I find the contract size?

In MT5, right-click the symbol in Market Watch and open “Specification”. It shows the contract size (“Contract size”), the profit currency and more. Menu names can differ a little between versions and languages.

• Values can differ by broker, account type and symbol name (suffixes such as .r). Do not use examples from this article, or values for another symbol or another company; check the same symbol on your own account. The official table below is a reference, not proof of applicability to your account or past trades.
• The public estimate assumes the linear formula; manual input and detailed mode require you to confirm it applies: lots × price × contract size. If you are unsure about a symbol, ask your broker.
• The price is read from the opening price column of the Positions list. The closing price and the prices in other tables, such as Orders or Deals, are not used in the calculation.
• Column roles are decided by the fixed order of the header row (Time, Position, Symbol, Type, Volume, Price, S / L, T / P, Time, Price, Commission, Swap, Profit). Time and Price each appear twice, so a header in a different order is refused rather than guessed.

Supplement: six-column CSV (USD comparison only; individual only)

Open “Supplement: six-column CSV” under the tool to paste a CSV with the 6 columns symbol,lots,price,contractSize,quoteCurrency,usdPerQuote, one record per line. You do not have to retype every position of an HTML report into six columns. CSV is supplementary; the HTML report is the main input. Use it for separate records. Its usdPerQuote column is USD-only and never follows the HTML JPY selection.

• For USD-quoted products, always write 1 in usdPerQuote.
• For products priced in a currency other than USD, look up the factor at execution time yourself and write it per row. The tool does not fetch exchange rates and cannot tell whether the factor is correct. If the rate differs by date in your history, enter the factor for each trade’s time, row by row.
• Numbers must be plain decimals (no sign, exponent or thousands separator). A zero, a negative value or an unreadable row makes the tool show that row and refuse to calculate. It never drops rows silently.
• The limits are 5 million characters and 20,000 records per input. Anything larger is rejected, never truncated.

4. Reading the results with the sample

Press “Try the fictional HTML sample” to display 10 fictional (SYNTHETIC) records calculated in USD, individually, without entering your own data or specifications. SAMPLE_A / B are not real symbols. Position IDs, times, prices and specifications are all made up.

The HTML sample uses fixed fictional contract sizes of 100 for SAMPLE_A and 100000 for SAMPLE_B, both USD-quoted with conversion factor 1. It does not use Funded7 specifications or the recent two-week FX average. Closing prices and Orders / Deals values are not used. These assumptions never carry into real-input specifications or confirmation boxes.

“Try the fictional CSV sample” reproduces the same notional distribution. It includes another fictional symbol, SAMPLE_C, and a fixed EUR→USD factor of 1.2, but its 10 notionals and the statistics below are identical.

Fixed example: 10 fictional records / USD / individual comparison. This is not the result of a report you uploaded.

After calculating your own report, “This calculation’s results” appears directly below the large count in the same item/value layout. Different records, currencies or grouping change the quartiles and threshold. Your result is not expected to match this fixed example.

The result shows the current history’s IQR, median, adopted threshold and the number of outlier candidates above it. Before the specifications are supplied, comparison is pending, not free of outliers. With enough records and a nonzero IQR, zero candidates is described as “No outlier candidates were found in this dataset.” This does not guarantee future safety or an acceptable official assessment.

The sample figures above apply to the default individual mode. Combining entries until fully closed can change the observation count, quartiles and threshold.

5. The formula and the two limits

• Quartiles use Type 7, the same method as Excel’s QUARTILE.INC: among n sorted values, the position (n − 1) × p is linearly interpolated (p = 0.25 for Q1, 0.5 for the median, 0.75 for Q3). It works even with a single record, where everything equals that value.
• IQR upper limit: Q3 + 1.5 × IQR. The wider the spread, the higher this limit.
• Median cap: median × 2.5. The smaller the median, the lower this limit.
• Adopted threshold: the smaller of the two. When they are equal, it is shown as the Median cap.
• Above: only when the notional is greater than the threshold. A value exactly equal to it counts as inside.
• Exact arithmetic: numbers are handled as exact decimal strings and compared without rounding. The readable results table shows whole yen for JPY and two decimals for USD; details retain up to six decimal places. Values that look equal after rounding can still exceed the threshold before rounding.
• Few records: with fewer than 5 or 10 records the threshold moves a lot. A prominent warning is shown, and no “stable” or “pass” style judgment is made.
• When the IQR is 0: Q1 and Q3 are equal and the IQR upper limit equals Q3. The tool says so.

This formula is the one used by an earlier standalone tool. It has not been confirmed to be identical to Funded7’s official standard. Check the official numbers, coefficients and conditions in the original guide and on the official site.

6. Important limits

• The current-specification estimate does not verify account or historical settings. Manual input and detailed mode require applicability checks. Standard two-week average FX is approximate, not a historical execution-time valuation. Wrong specifications or currencies produce wrong results.
• Notional value is not margin, a deposit, stop-loss risk or profit/loss. It is the number lots × price × contract size × BASE per 1 QUOTE.
• In the default individual mode, a record is one closed row of the Positions list (one CSV row for CSV input). When combining entries, one observation is the notional sum of a confirmed continuous-holding group. Partial fills, scale-ins, partial closes and netting reversals are not reconstructed. It is also not maximum simultaneous exposure, a trade group (episode), a Trade Cluster or a reconstruction of official qualifying trades. How the report lists positions changes the count and the distribution.
• The period you cover changes the result. Which period and trades you include changes the quartiles and the threshold. Even if a report starts mid-history, the tool does not reconstruct positions or check that the report covers the whole account.
• Contracts whose notional is not proportional to price (for example ones defined through an inverse price) cannot be handled by this linear formula. Ordinary non-USD-quoted currency pairs can be compared when the required conversion rates are available.
• A positive difference from the threshold is not a guarantee of meeting an official standard. No “safe lot” or “recommendation” is shown. Being below the threshold is not a guarantee of rule compliance either.
• Agreement with other products or tools has not been checked. Standard two-week averages and detailed opening-time FX are supported, but exclusion of the latest averages, positions that are still open, and hypothetical lot / count simulation are outside this tool.
• Positions extraction and display have been checked using one user-provided HTML format. This does not guarantee compatibility with every MT5 format. Calculating actual notionals still requires verification of contract specifications, quote currencies and conversion factors. A report in a shape it cannot read is rejected as a whole, with the reason shown.

7. Privacy

• Trade inputs and loaded HTML are processed inside your browser and are not uploaded. Standard mode makes an external request for public FX data, without sending trade history or account numbers.
• The HTML you load is processed only as text. It is never opened as a page, and no images or other resources are loaded.
• This tool does not store your history (for example in localStorage), log it, or send any measurement event containing its contents. Site-wide mechanisms outside this tool, such as general access measurement, are not covered by this statement.
• Pressing Reset, or leaving or closing the page, clears both the input and the results.

8. FAQ

Summary: look at the notional numbers neutrally first

Lining trades up by notional value shows which ones are large compared with your usual trades. This tool presents those numbers as they are: the adopted threshold, the largest value, the number above it and the side-by-side comparison of the two limits.

Positions extraction and display have been checked using one user-provided HTML format. This does not guarantee compatibility with every MT5 format or the correctness of actual notional calculations. You must confirm applicability of specifications and the FX method, and the result is not an official verdict.

📄 Back to the original article (Japanese only) Funded7 Funded7 Complete Guide: IQR, the 30-Second Rules, Qualifying Trades and Payouts The original Funded7 complete guide. It is written in Japanese. Back to the Funded7 guide (Japanese) →