excel chart to show put/call for any script for running series

#1
I google many times to find an excel file which I can use to see chart for any equity script, by changing just name of the script but I failed to find one.. so I made one and sharing here...pls see and comment so I can improve, as it is my first trial (no macros is there , only used webquery), This is for current series,,but not restricted to Nov only.,,,when next series starts it will auto load next one

http://www.************/file/XByDfY5tba/eqtyoptionexcel.html star is www 4 shared . com

an image for same is here >> http://postimg.org/image/9tvzwmo8v/

http://s3.postimg.org/b8xklcpc3/stockoption.jpg
 
#4
so far 173 views and no comments for improvement......

still tried to modify by adding option data for quick reference....now how can I check this is reliable or not (the delta and price part) .....



ofcourse the option price calculation portion is extracted from some others work in excel...but I dont know who is the creator,,,courtsey and thanks goes to that unknows person........only thing I did is tried to link with the available actual data
 
#5
Hi
this is a very useful excel. a few questions/suggestions from my side:

1. Whats is the source of this data. The NSE website itself doesn't get updated real-time, and a delayed data in Options is as bad as garbage

2.How can I check the connections in the excel

3. I can't see the Option pricing sheets as you were talking?

4. Rather than PCRatio, its more relevant to capture change in Put IO to Change in Call IO, as it gives better info of the market sentiment

5. future suggestion. Most of the traders, have multiple positions with multiple scripts, so we all feel at home only with the Greeks, so we can immediately plan or next trade. It would be beneficial, if you can incorporate the net Greeks for the net traded positions

Can we do something ith the Nifty options... How can we incorporate the technical indicators like RSI, 200DMA, etc in one sheet ?
 
#6
Hi Sami (samip2u),

Thanks for your valuable time and comments.

As you doubted, it is the data from Nse site only. In fact I did not intend it for real time trading,, but to use as a quick reference to see where could be the possible support/resistance building up.

and regarding the option sheet part,, it is not updated in the link which I gave on first post, but shown in the image, in the post where I mentioned about my updation.

making note of your comments, now I realize the sheet need a huge make over.
once again thanks for spending your time. :thumb:
 
#7
Hi Shajan,

Good to see your updates and efforts on finding option tradings.I am not able to see the excel file in ************ site.

Request you to provide the correct URL.

Thanks.
 
#9
I google many times to find an excel file which I can use to see chart for any equity script, by changing just name of the script but I failed to find one.. so I made one and sharing here...pls see and comment so I can improve, as it is my first trial (no macros is there , only used webquery), This is for current series,,but not restricted to Nov only.,,,when next series starts it will auto load next one

http://www.************/file/XByDfY5tba/eqtyoptionexcel.html star is www 4 shared . com

an image for same is here >> http://postimg.org/image/9tvzwmo8v/

http://s3.postimg.org/b8xklcpc3/stockoption.jpg
Hey Shajan,

the link given here is not working. Can yu pls help with a new (working :p)
link?
 

manishchan

Well-Known Member
#10
Hi Shajan,

Good to see your updates and efforts on finding option tradings.I am not able to see the excel file in ************ site.

Request you to provide the correct URL.

Thanks.
Hey Shajan,

the link given here is not working. Can yu pls help with a new (working :p)
link?
Wonder why itz not working for you guys... are you changing ****** to 4shared... see the image below..

 

Similar threads