The ultimate wheelhouse tracker :)

W

wxytrader

wxytrader said:
Does anybody know of a wheelhouse spread sheet that tracks multiple symbols on the same sheet, and auto-fills all the relevant data for you, so you don't have to look up, and re-enter the same information multiple times? So basically the only data you have to enter manually is the original CSP.

Every sheet I have seen requires you to put each symbol in its own tab, and there is a lot of redundant data entry.
More...

NM, I decided to just create my own tracker that did what I needed.

Main features
  • Tracks multiple symbols on the same sheet. When selling a call, it will lookup and autofill the corresponding # of contracts and strike price you got assigned at. This is a must when you are tracking multiple symbols.
  • Automatic status updates. It will show when an option is otm, itm, closed, shares assigned, shares delivered.
  • All assignments and deliveries of shares to be handled automatically. If your short puts expire itm, it will automatically buy the shares. If your short calls expire itm, it will automatically sell the shares.
Once I place a trade, I can check in after expiry and see the outcome without ever having to manually update anything.

All trades
Clipboard11.jpg



Stock holdingsxxxxxxxxxxxxxxSort trades by symbolxxxxxxStats
Clipboard11a.jpg



Other features
  • Tracks and calculates break even strike price.
  • When closing a position, it will display the weighted average cost basis for reference.
  • Shows the projected PnL based on the strike price of a sold call.
  • Shows the projected monthly income based on the price of an option, automatically calculating the maximum # of expirations in a month for that symbol.
  • Automatically formats expired orders.
  • Tracks all premium (daily, monthly, annually)
  • Tracks ROI, return on risk, allotted funds per symbol.
  • Tracks allotted funds for open positions.
  • Tracks unrealized PnL.
  • Tracks all underlying realized PnL.
  • Tracks how long each symbol has been traded.
  • Select symbol to track individual stats.
  • Toggle between USD/CAD.
  • Alerts you when an option is itm.
:)

ah crap I meant to post this in the original thread...mods?
 
Last edited:
wxytrader said:

NM, I decided to just create my own tracker that did what I needed.

Main features
  • Tracks multiple symbols on the same sheet. When selling a call, it will lookup and autofill the corresponding # of contracts and strike price you got assigned at. This is a must when you are tracking multiple symbols.
  • Automatic status updates. It will show when an option is otm, itm, closed, shares assigned, shares delivered.
  • All assignments and deliveries of shares to be handled automatically. If your short puts expire itm, it will automatically buy the shares. If your short calls expire itm, it will automatically sell the shares.
Once I place a trade, I can check in after expiry and see the outcome without ever having to manually update anything.

All trades
View attachment 336875


Stock holdingsxxxxxxxxxxxxxxSort trades by symbolxxxxxxStats
View attachment 336876


Other features
  • Tracks and calculates break even strike price.
  • When closing a position, it will display the weighted average cost basis for reference.
  • Shows the projected PnL based on the strike price of a sold call.
  • Shows the projected monthly income based on the price of an option, automatically calculating the maximum # of expirations in a month for that symbol.
  • Automatically formats expired orders.
  • Tracks all premium (daily, monthly, annually)
  • Tracks ROI, return on risk, allotted funds per symbol.
  • Tracks allotted funds for open positions.
  • Tracks unrealized PnL.
  • Tracks all underlying realized PnL.
  • Tracks how long each symbol has been traded.
  • Select symbol to track individual stats.
  • Toggle between USD/CAD.
  • Alerts you when an option is itm.
:)

ah crap I meant to post this in the original thread...mods?
More...


How did you create your own tracker? You code?
 
You must log in or register to reply here.
Back
Top