|
|
| Discuss excel worksheet to analyse options bhav copy at the Options within the Traderji.com - Discussion forum for Stocks Commodities & Forex; In collaboration with a person who is expert in excel programming, we are developing a ... |
|
|||||||
| Notices |
 |
|
|
Thread Tools |
| Sponsored Links |
|
#1
23rd August 2006, 10:13 PM
|
|||
|
|||
excel worksheet to analyse options bhav copy
In collaboration with a person who is expert in excel programming, we are developing a excel sheet for formatting options bhav copy of NSE. those who are interested can chip in with their requirements.
The excel sheet will report in summary the following: highest increase in closing price of options Highest increase in volumes of options(of 10 or 20 or 30 userdefined) Highest increase in Open interest of options ( 10 0r 20 or more) Company wise details of : calls total volumes/total OI/chn in OI today etc. Please note that since it involves programming time of the professional programmer, it may not be free but should be reasonably priced. 
|
|
#2
30th August 2006, 07:38 PM
|
|||
|
|||
|
Re: excel worksheet to analyse options bhav copy
Top ten in terms of change in open interest
IFCI09CA10 - 724,500 NAGARF09CA12.5 - 322,000 IDBI09CA70 - 235,200 ASHOKL09CA40 - 181,450 MTNL09CA160 - 177,600 TATAST08CA520 - 176,175 IDBI09CA65 - 156,000 NAGARF09CA15 - 140,000 TATAST09CA520 - 135,000 TATAST08CA510 - 125,550
|
|
#3
31st August 2006, 12:03 PM
|
|||
|
|||
|
Re: excel worksheet to analyse options bhav copy
Its really nice that u are trying to make this in excel. it will give u a lot of flexlibility.
If you are looking for futures and options data we can look at the following website Code:
http://www.derivativesindia.com/scripts/newsnupd/index3.asp
|
|
#6
2nd January 2007, 12:24 PM
|
|||
|
|||
|
Re: excel worksheet to analyse options bhav copy
hi when will able to get the benefit of the sheet
|
|
#7
3rd January 2007, 12:59 PM
|
|||
|
|||
|
Re: excel worksheet to analyse options bhav copy
I think one of the essential requirements would be a snapshot of the variance in options of the same strike price for different maturities.
Another important factor would be the support and resistance levels of the underlying and Option pricing based on these supports and resistances. Regards Shashank
|
|
| Bookmarks |
| Thread Tools | |
|
|
Similar Threads for: excel worksheet to analyse options bhav copy
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Site providing EOD data parsed from NSE bhav copy | trader9 | Data Feeds | 44 | 21st May 2007 02:49 PM |
| Excel Spreadsheets | CreditViolet | Software | 8 | 4th September 2006 08:12 PM |
| Strategy for Technical Analyse ? | cico | Technical Analysis | 2 | 18th January 2006 06:32 PM |
| exporting to excel | cmlee | MetaStock | 5 | 3rd October 2005 04:34 PM |
| excel help | vvn | Introductions | 4 | 8th August 2005 08:06 PM |
Indemnity, Disclaimer & Disclosure
Notice:
• By visiting Traderji.com you indicate your acceptance of our Forum
Rules Disclaimer & Disclosure and indemnify Traderji.com, its
associates and related parties of all claims howsoever resulting from
the usage of the forum.
• Disclaimer: Trading or investing in stocks & commodities
is a high risk activity. Any action you choose to take in the markets
is totally your own responsibility. Traderji.com will not be liable for
any, direct or indirect, consequential or incidental damages or loss arising out of the use of this information.
• Disclosure: The information in this forum is neither an offer to sell nor solicitation to buy any of the securities mentioned herein.
The writers may or may not be trading in the securities mentioned.
• All names or products mentioned are trademarks or registered trademarks of their respective owners.
General Content Disclaimer Notice:
In light of our policy of encouraging candid, open exchanges of views and the rapid distribution of information originating from many sources, Traderji.com cannot determine the accuracy of information that may be uploaded to the forum. Opinions, advice and all other information expressed by participants in discussions are those of the author. You rely on such information at your own risk. You are urged to seek professional advice for specific, individual situations and not rely solely on advice or opinions given in the discussions. Since Traderji.com is an open and free discussion forum, any comments made by members of this forum in their posts reflect their own views and not of the owner or administrator of Traderji.com. Thus the owner/administrator indemnify themselves of all claims whatsoever and will not be liable or responsible for any members comments/views in this forum Traderji.com. If you find any objectionable or offensive posts made by members of this forum which you would like to bring to our notice for removal then please Contact Us.
how to use excel worksheet to analyse options bhav copy
