Prop Consistency Denominator Worksheet
Compare best-day share under positive-day and net-profit denominators. Generic arithmetic, not a firm rule engine.
Default Example
Positive-day profit $1,200 less losing-day losses $200 gives $1,000 net profit. A $600 best day is 60% of net profit but 50% of positive-day profit. With a hypothetical 50% threshold and unchanged best day, the net denominator would need $200 more profit.
Static Formula
Required denominator = best day / (threshold / 100). Additional denominator = max(0, required denominator - entered denominator). This assumes the best day does not increase and other inputs remain unchanged. New larger winning days or further losses invalidate that assumption.
What It Cannot Decide
A zero or negative denominator produces an undefined positive-profit ratio. The worksheet cannot verify daily accounting, fees, reset clocks, account vintage, other objectives or eligibility for payment. Meeting the generic at-most ratio is not a firm-approved pass. No inputs are uploaded.
Primary Sources
From a fixed-best sensitivity to a full daily ledger
The original worksheet retains its static calculation under an entered best day. The new daily-objective ledger derives its best day from every supplied row. In the packet, adding a 1,500 positive day changes the numerator as well as net profit, leaving a sixty-percent net share rather than automatically solving the ratio.
Use the original result only under its unchanged-best premise. The additional ledger does not observe actual trading days or decide a pass. It keeps target, declared day counts, positive-day qualification and consistency separate, with null administrative approval. A conditional amount is not a trading target or reason to increase risk to force completion.