Creating Formula for Futures Options Spreadsheet

[famoso]

Hello

I have recently started selling strangles on ZB US treasury bonds. I am trying to work out how to convert the 17/64 price I received, to dollars for my spreadsheet. I am also trying to work out an excel formula to calculate the total premium collected for the short strangle trade. The price paid is as above.

above is the spreadsheet. I am trying to workout the total premium received in an excel formula. The current formula I have for the Premium cell is =K6*E6*31.25*0.5

k6=open price
E6=quantity

if anyone can help that would be great. Also, I'm looking to get in touch with someone genuine who has experience in options selling and who could assist me in building out my spreadsheet at a later stage.

 

[jkpieterse]

If your Open price is in cell K3:

=LET(numbers,TEXTSPLIT(K3,"/"),INDEX(numbers,1)/INDEX(numbers,2))

 

[famoso]

Hi and thanks, yes K3 isopen price. This formula you presented, where would I insert it? to work?

Thanks

I have tried to upload a mini sheet, followed instructions but nothing works.

 

[jkpieterse]

In the cell where you need the price as a number.