I need an excel file to analyse option chain in my MacBook Air 2020. I tried and tried a lot but not able to do that.
My requirements are as follows:-
1. Pull live index & stocks option chain data in excel
2. Select 5 upper & 5 lower strike rate OI data for call and put ( Strike rate should be above & below spot price)
3. This data should get auto refreshed in 10-15 mint time and the difference of PUT OI & CALL OI should be get saved at a place or in next sheet.
4. There should be drop down filter where I can select stocks or index.
Let me know if you have any questions
Or if you can help me in that, if it’s serviceable I am okay with it. Kindly let me know the charges and how to proceed.
Also I need sql installation help in my MacBook Air 2020