OTP (One Trade Perday) based on Open, Low and High values

anup

Well-Known Member
#21
@mastermind: Daily the excel generates around 15 scrips buy sell signal. So which stock we should really buy/sell ...how to compress the list
 

mastermind007

Well-Known Member
#22
@mastermind: Daily the excel generates around 15 scrips buy sell signal. So which stock we should really buy/sell ...how to compress the list
How do you choose which shirt to buy when you go shopping for clothes? How do you decide what to eat when you go out for a meal?

More precisely, How can someone else decide what you should buy?

This s/w has shrinks the list from 1800+ to 15 odd.

Can you not pick one or two out of that 15?

If your answer is no, please reconsider your decision about trading.



P.S. I do not sugar coat as it can cause mental diabetes!!!!
 
#23
How do you choose which shirt to buy when you go shopping for clothes? How do you decide what to eat when you go out for a meal? :lol:
. . :thumb: . .
 

healthraj

Well-Known Member
#24
It is practically impossible to buy all the script...So what is the alternative??
Some ways of filtering
- Go for stocks with Small lot size.
- Exclude High Beta Stocks if you cannot take Big risk because High beta stocks normally tend to move beyond the normal Stoploss range. You can look at my StockScreener to find out which are the High beta.
- Take into account VWAP (Volume Waited Average Price). When you are buying buy above VWAP and when you sell, Sell below VWAP.
- You can combine it with the FLOW levels to enter
- Most important Consider the Risk your taking from the Open price because the whole logic is based on the fact that the stock will not trace back to the Open price. So ideally for this kind of trading the Stoploss should be the Open Price. But if the Stock has already moved let us say 1% from the open price then you can avoid this stock.

there might be other ways to filter. But finally it goes without saying that, that is where is the magic, I mean choosing the right stock and choosing the right level to Enter.

This tool only suggests the Stocks to Trade on a particular day based on Open, Low and High. All the values are "Future" values and NOT SPOT.
 

healthraj

Well-Known Member
#25
Re: !!

Healthraj,

Excel spreadsheet that you posted is very good. I had gotten Ver 3.2 few months ago and was always wondering who the author was. I've also created a Excel 2007 solution which automatically downloaded RT NSE FO Options data into Excel. My spreadsheet was functional plain vanilla whereas yours is also a piece of art!!!

There is one technical issue and curious to know if you encountered it? Everytime downloading a web page fails, Excel curls up all the ranges and range names which often leaves rest of the sheet corrupted and inconsistently aligned. Did you ever run into problems of spreadsheet getting corrupted while changing contract months? It is something that was very bothersome for me and I abandoned Excel to move to C#


PS: my earlier post (about "creating login") was for someone else who was asking assistance for downloading
So I think you are talking about two things

- For the first problem, you can Refer to the function "GetSpecificStockFuturesData" in the module modStock. This function downloads the Futures data from NSEIndia site for a specific stock. So I use the code to download instead of using the "Data->From Web" menu in the Excel, where I was facing some issues in alignment etc... Look at the other parameters like WebFormatting, RefreshStyle, BackgroundQuery
- For FO Options data, I had written a tool to download, but then I dropped that because from the Options data not able to decide anything because the big players normally use options for hedging....
- you can also see the function GetDataFromNSEIndia, Where i calculate the Expiry date (Last thursday of the month)
- It would be good to code in C#. It should be far more performing... I am in the early stages of .Net. I wanted to convert the whole thing to an executable in .NET because .NET provide superior functionality especially for Graphs and Charts.... No time basically and am yet to learn .NET
 

healthraj

Well-Known Member
#26
18-Jun-13

Today NIFTY is looking FLAT to BULLISH. So it would be good to try noth the Strong BULL and STRONG BEARS. Let us see what we get at 10 AM.

Stocks to Watch

Code:
NSE Code	Risk at Entry	Signal
GAIL	64%	STRONG BEAR
HDFC	159%	STRONG BEAR
ICICIBANK	60%	STRONG BEAR
NTPC	74%	STRONG BEAR
TATAMOTORS	56%	STRONG BEAR
ABIRLANUVO	52%	STRONG BULL
CENTURYTEX	124%	STRONG BEAR
CESC	132%	STRONG BEAR
DIVISLAB	59%	STRONG BULL
FEDERALBNK	54%	STRONG BULL
HINDPETRO	95%	STRONG BEAR
MCDOWELL-N	150%	STRONG BULL
MCLEODRUSS	112%	STRONG BEAR
OFSS	48%	STRONG BEAR
RAYMOND	72%	STRONG BEAR
SIEMENS	90%	STRONG BULL
TATACHEM	50%	STRONG BULL
YESBANK	53%	STRONG BEAR
 

healthraj

Well-Known Member
#27
18-Jun-13 Recommendations.

Below is the Recommendations based in Open, High and Low at 9:55 AM. All the best

Code:
Date	Time	Stock	Action	Target Price	Profit / Loss	Remarks
18-Jun-13	9:55	ACC	SELL	1205.75	0.00	Opening the call -STRONG BEAR
18-Jun-13	9:55	GAIL	SELL	297.10	0.00	Opening the call -STRONG BEAR
18-Jun-13	9:55	HDFC	SELL	823.40	0.00	Opening the call -STRONG BEAR
18-Jun-13	9:55	HINDUNILVR	BUY	595.40	0.00	Opening the call -STRONG BULL
18-Jun-13	9:56	NMDC	SELL	108.20	0.00	Opening the call -STRONG BEAR
18-Jun-13	9:56	NTPC	SELL	149.05	0.00	Opening the call -STRONG BEAR
18-Jun-13	9:56	TATAMOTORS	SELL	295.85	0.00	Opening the call -STRONG BEAR
18-Jun-13	9:56	ABIRLANUVO	BUY	1067.95	0.00	Opening the call -STRONG BULL
18-Jun-13	9:57	CENTURYTEX	SELL	287.00	0.00	Opening the call -STRONG BEAR
18-Jun-13	9:57	CESC	SELL	333.50	0.00	Opening the call -STRONG BEAR
18-Jun-13	9:57	DIVISLAB	BUY	977.60	0.00	Opening the call -STRONG BULL
18-Jun-13	9:57	FEDERALBNK	BUY	437.10	0.00	Opening the call -STRONG BULL
18-Jun-13	9:57	HINDPETRO	SELL	259.50	0.00	Opening the call -STRONG BEAR
18-Jun-13	9:57	MCDOWELL-N	BUY	2491.20	0.00	Opening the call -STRONG BULL
18-Jun-13	9:57	SIEMENS	BUY	557.15	0.00	Opening the call -STRONG BULL
18-Jun-13	9:57	TATACHEM	BUY	303.00	0.00	Opening the call -STRONG BULL
18-Jun-13	9:58	YESBANK	SELL	481.00	0.00	Opening the call -STRONG BEAR
 

dineshN

Well-Known Member
#28
@Raj

Which course I've to take to learn VBA for excel. I've downloaded many ebooks but not able to grasp much. You are really a GEM. If I learn even 1% of what you know, it would be much creditable here!!!!
 

healthraj

Well-Known Member
#29
@Raj

Which course I've to take to learn VBA for excel. I've downloaded many ebooks but not able to grasp much. You are really a GEM. If I learn even 1% of what you know, it would be much creditable here!!!!
15 years of Self learning in Excel. No formal training done. If you have a requirement (the What part) and the Energy (Motivation), it is actually speaking very simple ( I am not exaggerating). Today with Internet everything is available in the internet.

My boost or energy came from the motivation that I was NOT able to find a single tool in the market which does the magic. I am trying to trade from 2009 onwards. So far not succeeded. So If I develop my own tool and If I fail I don't have to blame at least somebody else :). Actually most of the time I failed or lost money because I follow my own intuition rather than following what the tool says. If I blindly follow the tool, I will surely succeed but then for that I need to Master my mind. So Trading is 90% a mental game.

Of course you also need to have "Hacker mindset". For example the most difficult part of the tool was downloadin the data from Google. And recently the data Futures data downloaded from NSEIndia site.

My recent challenge is howto get the VWAP from the NSEindia site so that the OTP Tool can improved.
 

healthraj

Well-Known Member
#30
18-Jun-13 Recommendations.

Below is the Recommendations based in Open, High and Low at 9:55 AM. All the best

Code:
Date	Time	Stock	Action	Target Price	Profit / Loss	Remarks
18-Jun-13	9:55	ACC	SELL	1205.75	0.00	Opening the call -STRONG BEAR
18-Jun-13	9:55	GAIL	SELL	297.10	0.00	Opening the call -STRONG BEAR
18-Jun-13	9:55	HDFC	SELL	823.40	0.00	Opening the call -STRONG BEAR
18-Jun-13	9:55	HINDUNILVR	BUY	595.40	0.00	Opening the call -STRONG BULL
18-Jun-13	9:56	NMDC	SELL	108.20	0.00	Opening the call -STRONG BEAR
18-Jun-13	9:56	NTPC	SELL	149.05	0.00	Opening the call -STRONG BEAR
18-Jun-13	9:56	TATAMOTORS	SELL	295.85	0.00	Opening the call -STRONG BEAR
18-Jun-13	9:56	ABIRLANUVO	BUY	1067.95	0.00	Opening the call -STRONG BULL
18-Jun-13	9:57	CENTURYTEX	SELL	287.00	0.00	Opening the call -STRONG BEAR
18-Jun-13	9:57	CESC	SELL	333.50	0.00	Opening the call -STRONG BEAR
18-Jun-13	9:57	DIVISLAB	BUY	977.60	0.00	Opening the call -STRONG BULL
18-Jun-13	9:57	FEDERALBNK	BUY	437.10	0.00	Opening the call -STRONG BULL
18-Jun-13	9:57	HINDPETRO	SELL	259.50	0.00	Opening the call -STRONG BEAR
18-Jun-13	9:57	MCDOWELL-N	BUY	2491.20	0.00	Opening the call -STRONG BULL
18-Jun-13	9:57	SIEMENS	BUY	557.15	0.00	Opening the call -STRONG BULL
18-Jun-13	9:57	TATACHEM	BUY	303.00	0.00	Opening the call -STRONG BULL
18-Jun-13	9:58	YESBANK	SELL	481.00	0.00	Opening the call -STRONG BEAR
18-Jun-13 Closing status

Except HINDUNILVR, ABIRLANUVO and GAIL the rest of the stocks either hit stoploss or Reversed the Trend. Today those who traded will know how the market was doing a whipsaws between 5800 and 5850. So not a good day for OTP. But rather a good day for MTP.

Code:
Date	Time	Stock	Action	Target Price	Profit / Loss	Remarks
18-Jun-13	10:01	NMDC	BUY	108.30	-0.10	Closing the call - Trend Reversed UPwards - STRONG BEAR
18-Jun-13	10:06	SIEMENS	SELL	555.60	-1.55	Closing the call - Trend Reversed DOWNwards - STRONG BULL
18-Jun-13	10:10	FEDERALBNK	SELL	435.79	-1.31	Closing the call - Stoploss Triggered - STRONG BULL
18-Jun-13	10:13	MCDOWELL-N	SELL	2486.80	-4.40	Closing the call - Trend Reversed DOWNwards - STRONG BULL
18-Jun-13	10:37	ACC	BUY	1209.20	-3.45	Closing the call - Trend Reversed UPwards - STRONG BEAR
18-Jun-13	10:37	DIVISLAB	SELL	974.67	-2.93	Closing the call - Stoploss Triggered - STRONG BULL
18-Jun-13	10:37	HINDPETRO	BUY	259.65	-0.15	Closing the call - Trend Reversed UPwards - STRONG BEAR
18-Jun-13	10:38	TATACHEM	SELL	303.00	0.00	Closing the call - Trend Reversed DOWNwards - STRONG BULL
18-Jun-13	10:48	HDFC	BUY	825.87	-2.47	Closing the call - Stoploss Triggered - STRONG BEAR
18-Jun-13	10:51	YESBANK	BUY	482.44	-1.44	Closing the call - Stoploss Triggered - STRONG BEAR
18-Jun-13	11:17	NTPC	BUY	149.35	-0.30	Closing the call - Trend Reversed UPwards - STRONG BEAR
18-Jun-13	11:18	CENTURYTEX	BUY	287.86	-0.86	Closing the call - Stoploss Triggered - STRONG BEAR
18-Jun-13	12:15	CESC	BUY	334.50	-1.00	Closing the call - Stoploss Triggered - STRONG BEAR
18-Jun-13	13:31	TATAMOTORS	BUY	296.00	-0.15	Closing the call - Trend Reversed UPwards - STRONG BEAR
18-Jun-13	14:05	HINDUNILVR	SELL	595.90	0.50	Closing the call - Trend Reversed DOWNwards - STRONG BULL
18-Jun-13	15:13	ABIRLANUVO	SELL	1079.00	11.05	Closing the call - Manual - STRONG BULL
18-Jun-13	15:14	GAIL	BUY	295.05	2.05	Closing the call - Manual - STRONG BEAR
 

Similar threads