Jump to content
Medved Trader Forums
  • 0

Portfolio totals / sub totals




Can you please see why is SPY calculated differently (as 100 share lot) than other symbols?

Also, can you please calculate sub total and totals for Time Value column too?

Can I request to add a column that calculates option's Time value % of current underlying price? T.V * 100 /Price


Link to comment
Share on other sites

14 answers to this question

Recommended Posts

  • 0

Thank you, I can manage the totals in spreadsheet for now.

I am trying to import a filtered list of options (~500 ) in to MT and scan for basic price values, volatility and option greeks. There are some data points already available, may be if you have time, you can add more option symbols data for scanning.

Link to comment
Share on other sites

  • 0

Hello, Thanks for adding the column, can you please compare the calculation with my spreadsheet below?

I think I made error on formula above, see if this is correct in spreadsheet for TV%

I think extrinsic value cannot be negative. Are mid prices being used or last? I assumed mid prices below.







Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...