| View previous topic :: View next topic |
| Author |
Nifty and Stock option charts - Excel file |
soonil123
White Belt
Joined: 15 Mar 2009
Posts: 15
|
Post: #1  Posted: Wed Nov 13, 2013 10:31 pm Post subject: Nifty and Stock option charts - Excel file |
 |
|
Dear Members
I`m attaching the open interest excel file for Nifty and some stock option charts which will help user to see the real time update in excel format.
with bullish and bearish trend of index and stock.
kindly post vaulable comment to imporove the excel file.
| Description: |
|
| Filesize: |
186.65 KB |
| Viewed: |
734 Time(s) |
|
| Description: |
|
Download |
| Filename: |
BANKNIFTY-OPEN_INTEREST_CHART.xlsx |
| Filesize: |
41.79 KB |
| Downloaded: |
802 Time(s) |
| Description: |
|
Download |
| Filename: |
NIFTY-OPEN_INTEREST_CHART.xlsx |
| Filesize: |
92.65 KB |
| Downloaded: |
889 Time(s) |
|
|
| Back to top |
|
 |
|
|
|
soonil123
White Belt
Joined: 15 Mar 2009
Posts: 15
|
| Post: #2 Posted: Thu Nov 14, 2013 1:06 am Post subject: NIFTY OPEN INTEREST CHARTS - EOD BASIS |
|
|
hello Members...
This is Nifty open interest charts on EOD basis....
for reference and training purpose.
| Description: |
|
| Filesize: |
187.04 KB |
| Viewed: |
821 Time(s) |
|
|
|
| Back to top |
|
|
pkholla
Black Belt
Joined: 04 Nov 2010
Posts: 2890
|
| Post: #3 Posted: Thu Nov 14, 2013 10:23 am Post subject: |
|
|
Soonil bhai, Some of us are happy with 2003 version of MS Office, Word = .doc / Excel = .xls. Can I trouble you to take a few seconds: open your xlsx file, save as, old version (xls), save, post in your thread?
Thnx in advance! Prakash Holla
|
|
| Back to top |
|
|
yashrahul
Yellow Belt
Joined: 29 Jun 2013
Posts: 512
|
| Post: #4 Posted: Thu Nov 14, 2013 11:24 am Post subject: |
|
|
Soonil123:keep it up 
|
|
| Back to top |
|
|
vinay28
Black Belt
Joined: 24 Dec 2010
Posts: 11748
|
| Post: #5 Posted: Thu Nov 14, 2013 11:44 am Post subject: Re: Nifty and Stock option charts - Excel file |
|
|
| soonil123 wrote: | Dear Members
I`m attaching the open interest excel file for Nifty and some stock option charts which will help user to see the real time update in excel format.
with bullish and bearish trend of index and stock.
kindly post vaulable comment to imporove the excel file. |
soonil, in what way it is diferent from the one you uploaded 2 days ago?
|
|
| Back to top |
|
|
soonil123
White Belt
Joined: 15 Mar 2009
Posts: 15
|
| Post: #6 Posted: Fri Nov 15, 2013 12:54 am Post subject: |
|
|
Dear Vinay,
i was posting file in some other members thread and it was not good and some senior member feel the thread was moved its topic direction , so according to their suggestion i started new thread ....
in future i`m going to upload new file with new information.
i had created this file with available information with me ..... still i`m not able to fully understand the meaning of graph and how to get proper direction of market with this charts.
I hope some senior will guide to understand the charts drawn in this file....
Today i`m uploadineg same file with modification of Put/Call Ratio to get the better view of market direction....
| Description: |
|
Download |
| Filename: |
NIFTY-OPEN_INTEREST_CHART.xlsx |
| Filesize: |
93.3 KB |
| Downloaded: |
656 Time(s) |
| Description: |
|
Download |
| Filename: |
NIFTY-OPEN_INTEREST_CHART.xlsx |
| Filesize: |
93.3 KB |
| Downloaded: |
591 Time(s) |
|
|
| Back to top |
|
|
vinay28
Black Belt
Joined: 24 Dec 2010
Posts: 11748
|
| Post: #7 Posted: Fri Nov 15, 2013 5:09 pm Post subject: |
|
|
| soonil123 wrote: | Dear Vinay,
i was posting file in some other members thread and it was not good and some senior member feel the thread was moved its topic direction , so according to their suggestion i started new thread ....
in future i`m going to upload new file with new information.
i had created this file with available information with me ..... still i`m not able to fully understand the meaning of graph and how to get proper direction of market with this charts.
I hope some senior will guide to understand the charts drawn in this file....
Today i`m uploadineg same file with modification of Put/Call Ratio to get the better view of market direction.... |
thanks soonil. But I could not see the diference between two files you have uploaded with same name with recent post. Also, is it a revised version of file uploaded few days ago? I couldn't find any diference. thanks again
|
|
| Back to top |
|
|
saumya12
Brown Belt
Joined: 21 Dec 2011
Posts: 1509
|
| Post: #8 Posted: Mon Nov 18, 2013 12:57 am Post subject: |
|
|
| pkholla wrote: | Soonil bhai, Some of us are happy with 2003 version of MS Office, Word = .doc / Excel = .xls. Can I trouble you to take a few seconds: open your xlsx file, save as, old version (xls), save, post in your thread?
Thnx in advance! Prakash Holla |
Prakash, I have change this file to .xls
Just check, if it is working
PS I hope that soonil wont mind this change of file extn.
| Description: |
|
Download |
| Filename: |
nifty_open_interest_chart_209.xls |
| Filesize: |
93.3 KB |
| Downloaded: |
612 Time(s) |
|
|
| Back to top |
|
|
pkholla
Black Belt
Joined: 04 Nov 2010
Posts: 2890
|
| Post: #9 Posted: Mon Nov 18, 2013 9:14 am Post subject: |
|
|
| saumya12 wrote: | | I hope that soonil wont mind this change of file extn. |
Thanks to Soonil for creating the file and to Saumya for converting it to required format. Prakash Holla
|
|
| Back to top |
|
|
soonil123
White Belt
Joined: 15 Mar 2009
Posts: 15
|
| Post: #10 Posted: Wed Nov 20, 2013 1:13 am Post subject: |
|
|
Thanks Saumya for converting file and help to member of icharts.
|
|
| Back to top |
|
|
soonil123
White Belt
Joined: 15 Mar 2009
Posts: 15
|
| Post: #11 Posted: Fri Nov 29, 2013 12:54 am Post subject: NEW EXCEL FILE FOR GENERATING MONTHLY BASIS OF CHART |
|
|
Dear Member ,
I found basic file of option, which i edited to generate the monhtly basis chart and its impact on call and put of given strike price in both up and downtrend with chart.
The worksheet labelled Basic is a simple option pricer.
You simply enter the option details into the yellow shaded areas and
the output values will be displayed underneath in the blue shaded cells.
The worksheet labelled "Option Cal Down" is a option calculator with given strike price and closing price , input the value in yellow cell and output is given in green tab ,
similarly to generate the monthly basis chart select the range of upper limit and lower limit of particular month and select the best strike price it will generate the best possible ways of market direction and best possible upper limit call/ put price and vice versa.
| Description: |
|
| Filesize: |
144.39 KB |
| Viewed: |
709 Time(s) |
|
| Description: |
|
| Filesize: |
59.3 KB |
| Viewed: |
488 Time(s) |
|
| Description: |
|
| Filesize: |
62.49 KB |
| Viewed: |
505 Time(s) |
|
| Description: |
|
Download |
| Filename: |
OptionTradingWorkbook.xlsx |
| Filesize: |
40.73 KB |
| Downloaded: |
809 Time(s) |
|
|
| Back to top |
|
|
vinay28
Black Belt
Joined: 24 Dec 2010
Posts: 11748
|
| Post: #12 Posted: Fri Nov 29, 2013 9:03 am Post subject: |
|
|
| soonil, your painstaking dedication is remarkable.
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
