| View previous topic :: View next topic |
| Author |
Only for Stock Option traders... |
vinay28
Black Belt
Joined: 24 Dec 2010
Posts: 11748
|
Post: #16  Posted: Thu Apr 11, 2013 10:32 am Post subject: |
 |
|
| ndpotade wrote: | | vinay28 wrote: | | thanks. nifty not included in this? |
Here we are getting only stop option data so nifty wont be there.
I have only set formulas on the data, to know the trend. |
ok but looking at it what worries me is why ril is bearish
|
|
| Back to top |
|
 |
|
|
|
ndpotade
Yellow Belt
Joined: 05 Feb 2010
Posts: 580
|
| Post: #17 Posted: Thu Apr 11, 2013 10:42 am Post subject: |
|
|
| vinay28 wrote: | | ndpotade wrote: | | vinay28 wrote: | | thanks. nifty not included in this? |
Here we are getting only stop option data so nifty wont be there.
I have only set formulas on the data, to know the trend. |
ok but looking at it what worries me is why ril is bearish |
it is latest data comparison with Previous day's close.
From the image, we can see that call values are going down and put values are going up for RELIANCE.
| Description: |
|
| Filesize: |
85.59 KB |
| Viewed: |
394 Time(s) |
|
|
|
| Back to top |
|
|
vinay28
Black Belt
Joined: 24 Dec 2010
Posts: 11748
|
| Post: #18 Posted: Thu Apr 11, 2013 10:50 am Post subject: |
|
|
| ndpotade wrote: | | vinay28 wrote: | | ndpotade wrote: | | vinay28 wrote: | | thanks. nifty not included in this? |
Here we are getting only stop option data so nifty wont be there.
I have only set formulas on the data, to know the trend. |
ok but looking at it what worries me is why ril is bearish |
it is latest data comparison with Previous day's close.
From the image, we can see that call values are going down and put values are going up for RELIANCE. |
oh I know. I was just wondering aloud
|
|
| Back to top |
|
|
ndpotade
Yellow Belt
Joined: 05 Feb 2010
Posts: 580
|
| Post: #19 Posted: Thu Apr 11, 2013 11:18 am Post subject: |
|
|
List of stocks where only one trend as per stock option movement.
| Description: |
|
| Filesize: |
10.07 KB |
| Viewed: |
1443 Time(s) |
|
|
|
| Back to top |
|
|
ndpotade
Yellow Belt
Joined: 05 Feb 2010
Posts: 580
|
| Post: #20 Posted: Fri Apr 12, 2013 6:56 am Post subject: |
|
|
Good Morning to all,
I have created an excel file where it compare Option Price & Open Interest of Previous day with the current Price & OI of stock option.
The file consists of Latest 100 MOST ACTIVE CALLS & 100 MOST ACTIVE PUTS in Trading hours and will update automatically.
In column J, namely TREND & column K, namely Suggestion, I have considered the following rules to find trend.
1 ) If Current Price of Call option & Current Open Interest is greater than Price & Open Interest of Previous day, the trend will be marked as "BULLISH" ans suggestion will be "GOOD FOR LONG".
2 ) If Current Price of Put option & Current Open Interest is greater than Price & Open Interest of Previous day, the trend will be marked as "BEARISH" ans suggestion will be "GOOD FOR LONG".
3 ) If Current Price of Call option & Current Open Interest is less than Price & Open Interest of Previous day, the trend will be marked as "BEARISH" ans suggestion will be "GOOD FOR SHORT".
4 ) If Current Price of Put option & Current Open Interest is less than Price & Open Interest of Previous day, the trend will be marked as "BULLISH" ans suggestion will be "GOOD FOR SHORT".
All the Best.
| Description: |
|
Download |
| Filename: |
NITIN_OPTION_1204.xls |
| Filesize: |
501.5 KB |
| Downloaded: |
874 Time(s) |
|
|
| Back to top |
|
|
ndpotade
Yellow Belt
Joined: 05 Feb 2010
Posts: 580
|
| Post: #21 Posted: Fri Apr 12, 2013 7:04 am Post subject: |
|
|
Please share your views & observations to improve the file.
In last 2 days, first file was downloaded 60 times & second file was downloaded 20 times but nobody has shared their views on the file.
|
|
| Back to top |
|
|
kingkrunal
White Belt
Joined: 22 Jun 2012
Posts: 498
|
| Post: #22 Posted: Fri Apr 12, 2013 9:45 am Post subject: |
|
|
| ndpotade wrote: | Please share your views & observations to improve the file.
In last 2 days, first file was downloaded 60 times & second file was downloaded 20 times but nobody has shared their views on the file. |
nitin bhai... i have few queries... how exactly to use this sheet ???
I mean ok all signal and all good ... but can u explain me by giving an example from previous day sheet
|
|
| Back to top |
|
|
vinay28
Black Belt
Joined: 24 Dec 2010
Posts: 11748
|
| Post: #23 Posted: Fri Apr 12, 2013 9:47 am Post subject: |
|
|
| nitin, is RIL in a buy now and if so, is 800ce in buy?
|
|
| Back to top |
|
|
mozillan
White Belt
Joined: 15 Apr 2007
Posts: 21
|
| Post: #24 Posted: Fri Apr 12, 2013 10:56 am Post subject: Nice work |
|
|
| ndpotade wrote: | Please share your views & observations to improve the file.
In last 2 days, first file was downloaded 60 times & second file was downloaded 20 times but nobody has shared their views on the file. |
Thanks for sharing your strategy. Is the trend purely based upon the change in OI, or does it take into account price action also? Also, where does the sheet update its data from? There is a difference in prices in my platform and in the worksheet. Any way, thanks for the great work.
| Description: |
|
| Filesize: |
146.82 KB |
| Viewed: |
426 Time(s) |
|
| Description: |
|
| Filesize: |
55.27 KB |
| Viewed: |
414 Time(s) |
|
|
|
| Back to top |
|
|
ndpotade
Yellow Belt
Joined: 05 Feb 2010
Posts: 580
|
| Post: #25 Posted: Fri Apr 12, 2013 2:17 pm Post subject: Re: Nice work |
|
|
| mozillan wrote: | | ndpotade wrote: | Please share your views & observations to improve the file.
In last 2 days, first file was downloaded 60 times & second file was downloaded 20 times but nobody has shared their views on the file. |
Thanks for sharing your strategy. Is the trend purely based upon the change in OI, or does it take into account price action also? Also, where does the sheet update its data from? There is a difference in prices in my platform and in the worksheet. Any way, thanks for the great work. |
I have considered only stock option data of April Expiry and as Today is a special day of INFY where it can be possible that in Most Active Calls & Puts, stock option of May expiry is appearing so data is not matching.
Thanks for observations.
|
|
| Back to top |
|
|
ndpotade
Yellow Belt
Joined: 05 Feb 2010
Posts: 580
|
| Post: #26 Posted: Thu Apr 18, 2013 6:52 am Post subject: |
|
|
Good Morning to All,
The link is valid for 18-04-2013 only.
All the best.
| Description: |
|
Download |
| Filename: |
NITIN_OPTION_1804.xlsx |
| Filesize: |
255.93 KB |
| Downloaded: |
449 Time(s) |
|
|
| Back to top |
|
|
ndpotade
Yellow Belt
Joined: 05 Feb 2010
Posts: 580
|
| Post: #27 Posted: Thu Apr 18, 2013 8:31 pm Post subject: Re: Only for Stock Option traders... |
|
|
37 downloads but no reply.
Is it useful or useless ?
|
|
| Back to top |
|
|
imranairaj
White Belt
Joined: 06 May 2009
Posts: 8
|
| Post: #28 Posted: Mon May 06, 2013 10:37 am Post subject: |
|
|
hi ndpotade,
you are fantastic, please send today's stocks.
Regards,
Imran
|
|
| Back to top |
|
|
pkholla
Black Belt
Joined: 04 Nov 2010
Posts: 2890
|
| Post: #29 Posted: Mon May 06, 2013 10:44 am Post subject: Re: Only for Stock Option traders... |
|
|
| ndpotade wrote: | | 37 downloads but no reply. Is it useful or useless ? |
Arey, bhai, u r from foren? We Indians are like that only. Chhota sa problem ho to gaali, bada labh to bhi silence. Thank you for posting. Prakash Holla
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
