An automated excel sheet is created for the same which can be downloaded at the end of this post. Check out below link for Live signals based on this strategy would not require downloading Excel sheet.

Intraday Open High Low Strategy -Live Signals. Sheet will be updated automatically every 1 minute. Stop Loss Column J Stop Loss Price. Make sure that you are connected to the internet. The sheet will update automatically every minute as per the live market data. This is an Intraday only strategy. Download Amibroker AFL for this strategy here. Really wondering, how you could bring down live data on Excel sheet.

Probably you should start step by step tutorials on Excel also. It will help immensely as it helped in afl.

Dhaka Stock Exchange Broad Technical Analysis - urisofod.web.fc2.com

Can you add Index values into this sheet? Glad to hear that you liked this post. We were actually thinking to start a series on Excel tutorial. We will try to add Index data in this Excel sheet and let you know. Please find the AFL for this strategy here http: Hello sir can this be open through mobile also.

Actully in mobile it is not connecting or updating data can u plz provide assistance how to use this in mobile also.

But there are other Excel based strategies that can be useful. Check out this one: If other than this you have any other links pls forward the same. Hi is it possible for u to post the back tested results of the above system for the past one year. Also if u can test it post one hour from the open. This strategy cannot be tested in Excel sheet. We will try to backtest it in Amibroker and post the results soon. Hi Abhi, We posted one strategy which works good in Crude Oil, gold and silver.

Please check this out: Hi Raj, In this strategy, stop loss is dependent on open price every day. Hi I had knowledge about this…but failed to take advantage of it. Well, I have downloaded it…hope it will work fine!! And thank you so much for your great work!! Dear Admin, I am a small trader and at present trading mostly in the options segment,off course due to small trading capital.

From my side, I want to request you if you could kindly try to post something like this fantastic excel sheet you had posted. Hi Pankaj, Thanks for your kind words. Please subscribe to our posts. Please keep it up and from my side again I would like to request you such a sheet for NSE stock options segment please!!!

Thank you so much again!! Sir as requested above, please try and post back tested results for this strategy. It will be really helpful. Hello Sir, is it possible to have excel for all the stocks in nse could you please let me know how to do this.

Hi Rohit, Please send the screenshot to support tradingtuitions. The excel sheet is amazing, Thanks for this great sharing. Note that the sheet has a little error. HDFC prices shown are retrieved from HDFCBANK and LT prices shown are retrieved from BOSCHLTD. Appreciate correcting and uploading a fresh file. Hi Harsha, Commodity trading is not our niche.

What is Best time to take a Position? In my opinion, use one min chart, trade second candle either buy or sell as per signal in scrip here. Rest of the trading finishes upto 9. Date 11 Nov Sell in ACC as per excel sheet here At 10 am ACC price was How can any one sell ACC at on 11 Nov at 10 am? Price of ACC was on 11 Nov at exactly 9. I agree with your analysis and it makes sense for this particular stock on Nov But before posting any strategy we backtest it on multiple markets and instruments and suggest the best possible parameters.

In this case entering after half an hour of market open has the best success ratio and profitability for most of the stocks backtested on around 10 years of data. But at the end its upto you how you want to modify the strategy rules. Here you are giving the price at which scrip is to be bought or sold. The time at which that price is available for entering the trade is the time.

Not 10 am or other. Given price is crucial. I mean it should be 3min,5min,15min or more. Hi Pankaj, The timeframe totally depends on your personality and your emotion handling capabilities.

Practically 1 minute is the best TF for intraday, but most of the people could not find it suitable due to high risk associated with it. So they switch to 5 minutes. I would suggest you to start with 5 minutes for Intraday and 30 minutes for Swing.

Dhaka Stock Exchange

Sir it is great to watch this excel sheet strategy for nfo stocks. Pl tell me is there any possibility to plot these technic in amibroker and by the by it can be linked to robo system and work will be done automatically. Building robotic system for automated trade is possible for those trading platform which can be linked to Excel Sheet.

It will be independent of Amibroker and lightning fast with no delay. But when that link is opened that shows only nse stocks. A backtest will reveal a lot of stocks which hit the stop open price during the day after the first minutes.

Hi Rajen, Yes,you are correct. A quick backtest would reveal that number of losses is way higher than number of profits. However, it all depends on your money management. A good risk-reward ratio would keep you profitable in the long term.

And this strategy ensures a good risk-reward ratio if you maintain SL strictly. We are also working on an AFL to further optimize this system. Thanks for your suggestions! Sir in an afl how to give a command for profit booking. Hi Mustak, You can use ApplyStop function in Amibroker for setting up profit targets. But the interface between Amibroker and your robo system should understand this function. Please contact your robo system provider for details.

Hi Kamal, I hope you are talking about Amibroker backtesting. To backtest on all your favourite stocks you first have to create a watchlist and add all those stocks. Then in the analysis window you would get an option to select that watchlist. I want use this exel file for other stock…how can i do.

Plz explain step by step. Hi Amirpal, Right now this sheet is automated for just Nifty50 stocks. You would need to manually enter data for other scrips. SIR, LT IS SHOWING OPEN VALUE Hello Sir, Thank you for correcting it.

Hi Nasrudeen, For now, this excel sheet is automated for just Nifty 50 stocks. Hi sirI gon througw all the post and its wonderful experience to read about yours excellent work.

Hi Optimus, Thank you! Hi Atul, We have shared many trading setups for Intraday and positional in the past. Please can i buy berkshire hathaway b shares the below link: Hi Chandrasekaran, Please install Microsoft Office in your system. Then you can easily access this Excel sheet.

Check for the below strategy apart from this one: Thanks a lot for sharing such valuable strategies on excel set up,looking forward for options trading system.

Dhaka Stock Exchange Broad Candlestick Patterns - urisofod.web.fc2.com

Hi Umesh, Thank you! Right now we are developing strategies only for Futures and Spot, will soon start Options section in our website. Let me know if you have anything specific in mind. Hello Sir, Firstly thanks for your nice creation. I am from Bangladesh. Please guid me to for the way of use it.

Hi Ruhul, Thanks for your kind words. I am not sure if it is possible to get live data from Dhaka Stock Exchange. Please send me the URL of its website. I will try to look into it. Please send me modified excel sheet to: Thank you for helping us. Dear Admin, This is an amazing formula excel. You are the master. I was searching something gr8 tool from months and finally got it from you.

If you could have also added target levels in excel that would have been wonderful for safe trader like us Happyzz helping!!!! Target levels can be based on your risk appetite. Try doing profit slicing for two different target levels. Dear admin, Good job done by you. It invest dhaka stock market todays market be great if you develop excel sheet for stock futures. Hello Bhai, Thanks a lot for this! Can you please share a sheet with other stocks apart from nifty50, for ex: Please check the below link for all FNO stocks: Dear Admin, Nice to see the excellent excel sheet developed for the intraday trading for Nifty stocks.

Would like to request you to share the excel sheet for all future scripts. Please see the below link for future scrips: And i would also want to tell that excel sheet is getting downloaded but the data is not getting automatically updated therefor i have even checked the firewall or isp both are not blocking any website.

Please let me know why is this happening and at last i am really very thankful for your hardwork may god give you grace and prosperity. We can add the requested stocks in the Live Excel sheet. Please feel free to post the stock names in Comments. Can you please try downoading the Excel sheet in some other machine to figure out if there is any problem in your Excel installation. Please find the detailed backtest report and AFL code in the below link: Hi, After a long search i found this website and it is amazing.

Thanks for all the hard work you have done in creating these sheets.

I have one request only. Is it possible to make a sheet for nifty 50 stocks with only todays open price, todays high, todays low, previous days high and previous days low refreshing every one minute. This would be a big help. Yes we can,i am using it now, i have taken service from Truedata for live streaming of quotes and dojima rice market origins futures trading excel shows me all nifty 50 data gives me buy or sell signal using the strategy i have finalized.

Yes, few stocks have data issues since NSE changes their API very frequently. Consider using the below link for accurate data: Hi, downloaded excel file, but frequently receiving following error message: Can you check from your web browser if you are able to open this link: Awesome tool brother I m searching like this tool,got it finally can I add some more stocks here investor sentiment and the near-term stock market 2004 possible tell me how?

Great work admin keep it up i am getting same problem the below link not opening please get the solution for same waiting for your guidance http: Hello sir, Just downloaded the excel utility, and it looks good as well,But i am getting an error in CARIN, PNB, and VEDL scripts. The excel file available to download is only having Nifty 50 stock list. Also unable to pull data from the Hdfc vkc forex card online website, any help would be really appreciated.

Great sheets btw, thanks a lot. I am getting the error as unable to open the nseindia website and Cannot download telesales jobs from home uk information you requested when try to open the downloaded excelsheet. Hi guys, I was reviewing the trading rules and have a question.

So there is no need to wait till EOD. Oh, ok, so the L is only the L of the first half hour, and then you buy at whatever price is available after that, thank you! Dear Sir, Many thanks for you to develop a website like this. My doubt is about how the experts buy and sell gold bullion stocks entry point.

Many thanks for the update. Could you please explain about how i can use this method in commodity trading? Sir, Very useful stuff for a trader. I found data is updating as per the equity market. My query is that is this strategy works in futures also? Could you please explain about how can I use this method in commodity trading? The method remains the same for equity or commodity, but I fear we do not have any ready-made excel sheet for commodities yet.

But still perform ub forex pvt ltd trading for few days before going live with this.

Also kindly add few more popular stacks which trades with high volume apart from Nifty stocks. I downloaded excel sheet. It did not ask me Step 2: It will throw few warnings. Press Ok for all. I downloaded at ACC price being shown is Rs. Present price on NSE is Check out this link for more accurate signals: It is showing error in values of CAIRN, PNB and VEDL. What can I do? Can you invest dhaka stock market todays market tell me how to trade using it?

Stop loss I understood. What changes do I need to make in Cell E1 of your excel? It is showing very old price of ACC scrip. Please make it up to date. Or stop writing here down load- Intraday butterfly option strategy adjustment system.

Check out the more accurate version of this system at the below link. It been stated at the article as well http: But what I am trying to say. You are directing here to one link. There the data is incorrect. So edit here in post. Or change the link to http: We understand your concern.

But I would like to mention that data is incorrect only for few scripts and that to because of frequent changes in API at NSE website. And still there are people who are more comfortable using downloaded excel sheet rather than google sheets. We really appreciate your suggestion and review. Please read the instruction and other comments carefully to understand it better. The file could not be accessed.

Try one of the following. Make sure the specified folder exists. Make sure the folder that contain the file is not read only. Make sure the file name does not contain any of the following characters: Could you get me the excel sheet for this, I tried downloading the excel sheet from the link in this page but values arent getting updated.

Ex- Cairn, PNB and VEDL. Yes, that is a known issue. You can use below excel hosted in Google for other scrips: Hi Admin, In my excel sheet for some symbols all the values are showing as just VALUE!

Stock Exchange in Bangladesh- tutorial part 2

That will be very kind of you, Regards. Hi I noticed that it keep on changing no. The number of positions change when the signals are no longer valid. The way excel is made I am liking it. Please make an excel sheet of the same list scanning 15 min opening range breakout, and please make in Microsoft Excel format online sheets are not working perfectly for me. Can u share EXCEL where we can see all future stocks…this file only contains nifty 50 stocks.

HI can we add this excel to Trade tiger Snap to excel trading system to push orders automatically?

Its an excellent excel sheet. I checked just now and the excel sheet is working fine at my end. Can you please send the screenshot to support tradingtuitions. Your email address will not be published.

Subscribe to Trading Tuitions. Currently you have JavaScript disabled. In order to post comments, please make sure JavaScript and Cookies are enabled, and reload the page. Click here for instructions on how to enable JavaScript in your browser. Home Categories General Amibroker Trading Systems Tutorials Trading Excel Sheets Experiences Risk Management and Psychology Option Strategies Amibroker Tutorials Trading Systems Live Signals Intraday Open High Low Strategy -Live Signals Camarilla Pivot Points Excel Sheet: Live Signals Live Charts Recommended Trading Courses About Us Contact Us.

A Profitable Intraday Trading system: Excel Sheet Posted on March 10, by admin. Please share it with your friends! AFL of the week: How will the Stock Markets change in next 20 years? I really Thanked you for sharing this…. Dear Admin, Have you started series on excel tutorial as mentioned in the above post? Hi Sourav, Please find the AFL for this strategy here http: Hi Viral, This strategy cannot be tested in Excel sheet.

Very Nice Sir… Do you have any excel base strategy for commodities? Hi Ganesh, Can you check if your firewall or ISP is blocking access to NSE Website? Hello Sir, The excel sheet is amazing, Thanks for this great sharing. Please download the updated file. Thanks for pointing this out! Hi Rohit, Best time would be 45 minutes after market open. Hi Pablo, I agree with your analysis and it makes sense for this particular stock on Nov Hi Mustak, We are working on creating an automated AFL for this.

Thanks for providing such a wonderful help to the trading community. Hi Karan, Please download the updated sheet we shared. Errors have been resolved. Hi Mustak, Thanks for your suggestion!

We would try to add date column in the sheet. Sir, can you help to share trading setup for intra n postional trading. Thank Admin for reply. Have you success in creating Future options excel as well?

Hi Satish, Please check the below link for all FNO stocks: Hi what time this sheet should be started? Hi Vivek, We can add the requested stocks in the Live Excel sheet. Hi Ashwin, Can you please advise what error you are getting? Check if the Excel App in your phone supports real-time data connections and macros. Sir ,Please Check, VEDL,PNB,CAIRN data problem, check just now. Hi Saurabh, Yes, few stocks have data issues since NSE changes their API very frequently. Hi Pravin, Can you check from your web browser if you are able to open this link: Unable to open the website, gives an error.

Is there any way around this? Hello Sir, I am getting the error as unable to open the nseindia website and Cannot download the information you requested when try to open the downloaded excelsheet. Hi Sir, How can use this. I need to download the AFL for this strategy. Download it from below link: Dear Sir, Many thanks for the update. Hi Raj, You can take positions in future based on the signals from spot. Hi Hazeer, The method remains the same for equity or commodity, but I fear we do not have any ready-made excel sheet for commodities yet.

Hello Admin, How can we decide upon target price for exiting. Hi Geetha, Target depends on your risk appetite. I would recommend to use trailing stop loss. Hi Swanand, Check out this link which has everything you are looking for.

Hi Pablo, Check out this link for more accurate signals: Can you share only 5 liquid stocks from nifty50 priced low buy sell price and sl for intraday? Hi Pablo, Check out the more accurate version of this system at the below link. I am really very sorry to trouble you. Thanks and best regards. ADMIN kindly answe the question for PABLO. Hello Sir, I find the strategy interesting, I have been looking for such a one.

Could you please also confirm if the same thing can be applied in Zerodha PI too. Hi Sami, Unfortunately it is not possible in the current version of excel sheet. Hi Tanmoy, Yes, that is a known issue. Hi Nagarajan, Real time Data automatically refreshes in excel sheet. Sure Sarvesh, we would try to post such excel sheet.

Hi Radhe, The number of positions change when the signals are no longer valid. Admin, Can u share EXCEL where we can see all future stocks…this file only contains nifty 50 stocks Thanks in advance. Hi Sir Can you add options and future stocks data in that sheet. Thank you so much for this helpful sheet. Hi Toufik, I checked just now and the excel sheet is working fine at my end.

Leave a Reply Cancel reply Your email address will not be published. Excel Sheet Comments. Intraday Open High Low Strategy -Live Signals Comments.

Intraday Trading Strategy for Nifty 74 Comments. Trading Range Breakout on Daily timeframe: Excel Sheet 60 Comments. Open Interest Analysis Excel for Options 52 Comments. Low Risk High Reward 46 Comments. Intraday 1 Minute data: Free Download 44 Comments.

Intraday Opening Range Breakout system 38 Comments. Binary Options Trading for Dummies June 20, On Balance Volume OBV Indicator Excel Sheet June 11, Algorithmic Trading Courses for Beginners June 08, How to use Put Call Ratio for your Trading Decisions? Demystifying Initial Public Offering IPO May 19, Top 5 Stock Market Magazines for Traders and Investors May 01, A Simple and Efficient CCI Trading System April 25, Symbol name and Price for the day.