Put options

[Redcoat]

Calculate puts needed to insure against stock market loss..

 

[Joe4]

Welcome to the Board!

I think your question is a bit lacking in details.
Note the tips mentioned in item A5 here: https://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html

Everyone here is a volunteer, so make it as easy as you can for people to help you.

• State your question clearly, including your entire need at the start.
• Add some representative sample data - actual data is much better than an image (see also "Posting Aids" below).
• Tell us what formula/code you have currently, and why your results are not what you want.
• Include which version of Excel and Operating System you are using.
• If you are looking for help with an error received, what is the actual error message and where exactly does it occur?
• Before posting, read your question back to yourself to check it will make sense to somebody unfamiliar with your worksheet.
• Be patient. The more you 'push' for help, the less likely you are to receive it
• If you are truly in urgent need, you should consider hiring the MrExcel Consulting team.