Options Data Excel Automation
Budget: ₹1,500 – ₹12,500 INR
I have an Excel sheet that already contains options prices, futures prices and strike prices laid out in raw tables. I need a second workbook (or a re-structured copy of the same one) that automatically recognises the at-the-money (ATM) strike, computes the corresponding straddle value, and shows the ratio of that straddle to the current futures price. The file should refresh these three metrics instantly whenever I paste new daily data.
The layout I have in mind is simple: source data on one tab, clean summary on another. Formulas are fine; a small VBA routine or Power Query step is welcome if it keeps the workbook fast and eliminates manual intervention.
Deliverables
• A working .xlsx file with clearly labelled input and output areas
• Built-in calculations for:
1. ATM strike detection
2. Straddle value (call + put at the ATM strike)
3. Ratio of straddle value to futures price
• Brief instructions so I can drop fresh data in and see the numbers update
Accuracy and transparency are critical, so please keep any helper columns visible and comment complex formulas where needed.
Attached files have the format I am looking for and the raw data that needs to be used.
The layout I have in mind is simple: source data on one tab, clean summary on another. Formulas are fine; a small VBA routine or Power Query step is welcome if it keeps the workbook fast and eliminates manual intervention.
Deliverables
• A working .xlsx file with clearly labelled input and output areas
• Built-in calculations for:
1. ATM strike detection
2. Straddle value (call + put at the ATM strike)
3. Ratio of straddle value to futures price
• Brief instructions so I can drop fresh data in and see the numbers update
Accuracy and transparency are critical, so please keep any helper columns visible and comment complex formulas where needed.
Attached files have the format I am looking for and the raw data that needs to be used.