Trades: Calculating Position and P&L

Updated by Sameer Soleja

In Molecule, a Trade and its Position are not the same thing.


To the system, a Trade is a contract that you execute, such as a fill for an order on an exchange.


Molecule creates a Valuation row for every reporting date between the Trade Date and each leg's Settlement Date. These Valuation rows contain 150-odd attributes, including position (called unit quantity) and various P&L metrics (realized, unrealized, daily change, etc.).

The sum of all Valuation rows, for all trades, for today's reporting date, is your position. Since Molecule calculates this at such a granular level, you can slice and/or aggregate your position by just about anything -- exchange ticker, tenor, commodity, location, custom field. As a result, you don't have to wonder whether Molecule contemplated a specific trade in your position or P&L. You can pull a Valuations extract and see it.

Frequently Asked Questions

Doesn't this create a lot of data?

Yes. Molecule is designed to handle this.

The Position is wrong on the Trades screen!

That's because the Trades screen doesn't show position. If you use it to triangulate position, it will be incorrect when contemplating strips and options. The Valuations screen (and extracts, and custom reports we build for you) are what show position.

I want to see Position/P&L for this single trade.

On the Trades screen, hover your mouse above the M.ID (trade ID), like this. Click the backwards clock icon on the right, and you'll see the history of that trade's valuations.

You can use the purple column selector on the popup to pick which valuation metric you want to see.

How did we do?