- This topic has 5 replies, 6 voices, and was last updated 3 years, 10 months ago by Nitin Bhatia.
May 16, 2019 at 9:56 PM #113225
sir can anybody explain that how to automate option premium decay analysis?
May 16, 2019 at 10:02 PM #113349
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
May 16, 2019 at 11:36 PM #114132
Dear sir, i successfully pull option data. Now i need your help please give us a clue how we can automate premium decay sheet.
May 17, 2019 at 12:53 AM #114392
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.
May 17, 2019 at 3:14 AM #114397
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
May 17, 2019 at 12:12 PM #114752
You can also automate in Excel using functions, formulas and macros but it will increase your work.
- The topic ‘how to automate premium decay analysis?’ is closed to new replies.