Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

and the respective data will automatically appear in the app

...

CALCULATION LOGIC:

Vanilla

  1. OPEN TRADES table

    1. AMOUNT = INIT PRICE * SIZE

    2. OPTION MARKET VALUE

      1. if call: max[UNDERLYING PRICE - STRIKE PRICE, 0] * SIZE

      2. if put: max[STRIKER PRICE - UNDERLYING PRICE, 0] * SIZE

    3. UNP/L:

      1. If buy: OPTION MARKET VALUE - PREMIUM

      2. if sell: PREMIUM - OPTION MARKET VALUE

  2. CLOSED TRADES table:

    1. OPTION SETTLED VALUE: similar to OPTION MARKET VALUE, but the position is closed

      1. expired: once bigger than EXP DATE, or

      2. close trade: fill up SETTLEMENT DATE and OPTION SETTED VALUE in OPEN TRADES table

    2. P/L: same logic as UNP/L, just change OPTION MARKET VALUE to OPTION SETTLED VALUE

  3. Exotic Position Details app:

    1. EQUIV VANILLA ACTION: combination of BS and C/P

    2. EQUIV UNDERLYING DIRECTION:

      1. S if SELL/C or BUY/P

      2. B if BUY/C or SELL/P

    3. SIZE = :

      1. QTY if BS == BUY else -QTY

    4. EQUIV UNDERLYING QTY

      1. QTY if EQUIV UNDERLYING DIRECTION == B else -QTY

    5. POSITION COST

      1. if C/P == C, STRIKE PRICE + PREMIUM / abs(SIZE)

      2. if C/P == P, STRIKE PRICE - PREMIUM / abs(SIZE)

    6. INTEREST RECEIVED: EMPTY

    7. P/L PROJECTION:

      1. if BS == SELL: PREMIUM

      2. if BS == BUY: empty

    8. REALIZED P/L:

      1. closed trade:

        1. If BUY: OPTION SETTED VALUE - PREMIUM

        2. if SELL: PREMIUM - OPTION SETTED VALUE

      2. open trade: empty

    9. CURRENT LOST: only open position

      1. if CURRENT P/L < 0, CURRENT LOST = CURRENT P/L

      2. else empty

    10. CURRENT P/L:

      1. open trade:

        1. If buy: OPTION MARKET VALUE - PREMIUM

        2. if sell: PREMIUM - OPTION MARKET VALUE

      2. close trade: empty

 

Snowball/Phoenix

  1. OPEN TRADES table:

    1. AMOUNT = INIT PRICE * SIZE

    2. STRIKE PRICE = INIT PRICE

    3. OPTION MARKET VALUE:

      1. please refer to the details at last section of the page

    4. UNP/L: same as VANILLA

  2. CLOSED TRADES table:

    1. OPTION SETTLED VALUE: similar to OPTION MARKET VALUE, but the position is closed

      1. expired: once bigger than EXP DATE, or

      2. close trade: fill up SETTLEMENT DATE and OPTION SETTED VALUE in OPEN TRADES table

      3. knock out: please find knock out details below.

    2. P/L: same logic as UNP/L, just change OPTION MARKET VALUE to OPTION SETTLED VALUE