I tried several times with various ways but I don’t think without programming(VB/Python) and SQL knowledge its possible.
That’s why I am learning programming again, which I almost forgot after my collage days.
If you don’t want to learn programming then as suggested by Nitin sir, you can ask your friends or get it done by outsourcing it.
I Hoping a lot from Nitin sir’s video how to pull option chain.
Request to Nitin Sir: If we are not receiving any written consent from NSE or any other Broker to pull option chain, can you please share your method on any other free sites like Wikipedia or best way that you can create a special page for dummy option chain on your web site and teach us how we can pull data from it.
step 1 :- first choose which programming language you want to use..all popular programming language is absolutely free..only things is you must learn/know it. Nitin Sir use Visual Basic
I am using python for automation so i can explain you
step 2:-Study what is Xpath (to identify and navigate nodes/data in an XML/html page )
step 3:-Store the data to excel/server.I use Pythons Pandas library to store the data to excel..You need deep knowledge of mysql data base for storing data in web Server
step 4:calculating data is easy if u done all the above steps..just google every query you will get your solution