[hulmatParticipant]

sir can anybody explain that how to automate option premium decay analysis?

[mehulpabaniParticipant]

Same query i m also facing….have tried many ways….and i m not having much tecknical kmowledge ….can anybody can give some tips regarding it?? Basically maily facing issue of fetching live data

[vpnkumar87Participant]

Dear sir, i successfully pull option data. Now i need your help please give us a clue how we can automate premium decay sheet.

[AkshayParticipant]

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.

[SANTANUMAJI1994Participant]

This reply has been accepted as the best answer.

To
hulmat,mehulpabani
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

[Nitin BhatiaKeymaster]

You can also automate in Excel using functions, formulas and macros but it will increase your work.

[Author]

Posts