After D criticized the look of my spreadsheets I went to work. I have gotten them to a level that I never have to login to my broker platform anymore to track my stock or option positions, unless I'm actually placing a trade or funding. Now all I need is an api to actually place trades from my spreadsheet. Here is a call ratio spread I was tracking, you can see it even calculates the affect on the stock position below. Here is a call butterfly that I just opened...currently down about -$16. You can see that my cost was -$81 and currently worth -$65.07
It looks much better. You need to work on index models for trading beta-vol (single name vol). Calc the index forward. I prefer to work with an ATM fly skew value over using vol-basis (net 25D put/call annualized). It's normed and easier to heatmap/visualize. Start with a synthetic for each expiration and strike the ATM cfly and pfly. I typically go straddle width but it doesn't matter what you choose. I used to use (penny) synthetic strikes but the sheet ran too slow and made it impractical vs. simply running a 25D basis figure. cfly/pfly debit. Just choose nearest OTM strikes against the forward (synthetic long index at date). The idea is that verts (all) are the revenue side of skew and it hits four values on the smile (x-section). c/p wings(1,2) -> c/p body(3,4) (ATM single fig).
The poet says this- If you dont study, the markets can appear muddy Be prepared and dont take markets for granted Or else your wealth shall become slanted I the end its up to you Will you lose or join the chosen few ?