250

A Profitable Intraday Trading system: Excel Sheet

Posted on by admin

Note – Due to some unprecedented technical reasons, we have stopped supporting this excel sheet since Jan 2020. Alternatively, you can check the same strategy in the google sheets version here

In this post, we’ll explore a profitable Intraday Trading system. An automated excel sheet is created for the same which can be downloaded at the end of this post. This excel sheet will automatically download the data for Nifty50 stocks and indicate Buy/Sell signals. Also, it will show the profit % and stop loss value. This strategy is 80% accurate in all market conditions if applied on liquid stocks and commodities.

Check out below link for Live signals based on this strategy (would not require downloading Excel sheet)

Intraday Open High Low Strategy -Live Signals

Strategy Overview

Parameter Value
Preferred Timeframe Intraday 5 minutes
Indicators Used None
Buy Condition Open=Low for the current day. Buy after half an hour of market open
Sell Condition Open=High for the current day. Sell after half an hour of market open
Stop Loss Indicated in Excel Sheet
Targets As per one’s risk appetite or End of the day

Excel Sheet

Parameter Description
Worksheet Name Intraday Trading System
Inputs Column C,D,E,F,G Symbol name and Price for the day. It’s not needed to manually enter anything.

Sheet will be updated automatically every 1 minute.
Outputs Position (Column H) BUY/SELL signals for the particular stock. If this field is blank then don’t take any trade.
Price (Column I) Price above/below which Buy/Sell orders should be placed.
Stop Loss (Column J) Stop Loss Price.
Profit/Loss at EOD (Column K) Profit/Loss % at the end of the day based on the entry price.

Screenshot

How to use this Excel Sheet

Step 1: Download the sheet from the end of this post to your local computer.

Step 2: Open the sheet. It will throw few warnings. Press OK for all.

Step 3: Make sure that you are connected to the internet. The sheet will update automatically every minute as per the live market data. Click on ‘Refersh Data’ button if you want to update it forcefully.

Step 4: After half an hour of market open time, check the sheet for Buy/Sell signals. Place your order above/below ‘Price’ column in the excel sheet.

Step 5: Place stop loss as indicated in the Excel sheet.

Step 6: Book profit/loss based on your risk appetite and make sure that your entire position is squared off at the end of the day. This is an Intraday only strategy.

Note: The Sheet works perfectly fine in Microsoft Excel 2016. We have received few complaints where users are not able to update the sheet in Office 2010 or below versions. Please upgrade to the latest version for seamless access to the sheet and data.

Download Link

Intraday Trading System

Download Amibroker AFL for this strategy here.

Also check out the modified version of this strategy at the below link:

Intraday NSE BSE Open High Low Strategy

 

Spreadsheets for Success

Related Posts

250 Comments

      • Dear Sir,
        Sorry, but i am not able to update this sheet. i open the sheet, enable the internet connection and it shows value value signs doesnt show prices, i mean in all the columns only value word is written when i enable the internet connection. please inform me how to do this.

        • Dear Sir,
          I am Extremely thankful to you for sharing such a wonderful information to beginner like me. It’s Superb !!
          I request you to kindly allow / permit me to access this excel sheet. So i can update it regularly.

          Regards :

          Rajat Sharma

      • Dear Admin, there is something wrong with the exel chart. Its not updating.
        Can u check and provide the proper link again?

  2. Really wondering, how you could bring down live data on Excel sheet. Simply wonderful!! Probably you should start step by step tutorials on Excel also. It will help immensely as it helped in afl.
    Request: 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. Stay tuned.
      We will try to add Index data in this Excel sheet and let you know.

  4. do u have for usdinr also as iam trading in USDINR, eurinr.. Pl email such things to track positional BUY sell calls & intraday BUY sell calls — my mob -9820414831

  5. 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

    • Hi Viral,

      This strategy cannot be tested in Excel sheet. We will try to backtest it in Amibroker and post the results soon.

  6. Very Nice Sir… Do you have any excel base strategy for commodities ?

    • Hi Raj,
      In this strategy, stop loss is dependent on open price every day. So it won’t change during trading hours.

  8. 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!! Keep it up!!!

  9. 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. You’ll always find something interesting to read and learn.

  10. some error msg is showing like from nseindia site not datas can be retrived bro.

    • Hi Ganesh,
      Can you check if your firewall or ISP is blocking access to NSE Website?

  11. I am using this fantastic excel sheet & finding it quite useful. 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!!

  12. Sir as requested above, please try and post back tested results for this strategy. It will be really helpful.

  13. Hello Sir, is it possible to have excel for all the stocks in nse
    could you please let me know how to do this

  14. Hello Sir,

    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. Many thanks

  15. Can we get 1min data for crude and Natural gas, is it OK even if they’re global data…

    • Hi Harsha,
      Commodity trading is not our niche. And it’s actually hard to get commodity intraday data free of cost.

  16. What is Best time to take a Position?Is at after 15 mins after Day’s Open or is there any time you suggest

      • In my opinion, use one min chart, trade second candle either buy or sell as per signal in scrip here. Because 95% trading takes place in premarket i.e from 9.00 to 9.07am. Rest of the trading finishes upto 9.30 or 9.45 am.
        Date 11 Nov 2016. Sell in ACC @1443 (as per excel sheet here) At 10 am ACC price was 1403.
        How can any one sell ACC at 1443 on 11 Nov 2016 at 10 am?
        Price of ACC was 1443 on 11 Nov 2015 at exactly 9.16 am.

        • Hi Pablo,

          I agree with your analysis and it makes sense for this particular stock on Nov 11. 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.

      • मेरे एक बात समझ में नहीं आ रही है. यहाँ एंट्री प्राईस दी गयी है. तो जो “समय” में यहाँ की एंट्री प्राईस चार्ट के ऊपर आ जाए उसी “समय” एंट्री करना है या 10 बजे चाहे जो भी प्राईस हो उस पर एंट्री करना है. दोनों में से एक हो सकता. या तो एंट्री प्राईस या तो 10 बजे चाहे जो प्राईस हो. सुसायडल है भाई.

      • and what if the price which is mentioned in excel sheet for buy/sell is either
        more or low so still we can wait for that price? or we need to trade at whatever price is at @10 AM? also is it works for futures and options as well?

  17. Hi Admin,
    Can you guide me regarding the best time frame for intraday & swing trading.I mean it should be 3min,5min,15min or more.Please reply!Thanks!

    • 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.

  18. 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.

    • Hi Mustak,
      We are working on creating an automated AFL for this. Stay tuned!

    • Building robotic system for automated trade is possible for those trading platform which can be linked to Excel Sheet. For e.g. NOW, NEST can be linked to excel sheet and automated trading systems have been programmed according to trading strategy of one’s choice.

    • Building robotic system for automated trade is possible for those trading platform which can be linked to Excel Sheet. For e.g. NOW, NEST can be linked to excel sheet and automated trading systems have been programmed according to trading strategy of one’s choice.It will be independent of Amibroker and lightning fast with no delay.

  19. sir you mentioned on 14th march that you have developed excel strategy for crude and you have given a link also. But when that link is opened that shows only nse stocks. Please clarify

  20. Sir, my 2 cents on this strategy – First this strategy assumes that the volatility ends after the first 30 or 45 minutes of the day & stock may then move in a trend which may not be the case. A backtest will reveal a lot of stocks which hit the stop (open price) during the day after the first 30-45 minutes. Second the data taken from different sources like Google Data / Sharekhan TT terminal / NEST terminal / Zerodha PI will differ & hence backtest results will also differ.

    • 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!

  21. Sir in an afl how to give a command for profit booking. In automated robo system which i am using there is common profit and loss setting and i am unable to fix p/l for individual scripts

    • 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.

      • under analyisi , only chart opened are tested is it correct? how to get analysis ofall stocks in favourate list pl? thanks

        • 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.

          • Hi….can u explain more about that….
            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.

  22. Thanks for providing such a wonderful help to the trading community.

  23. SIR, LT IS SHOWING OPEN VALUE 3229.70 WHERE AS TODAY’S OPEN IS 1244.65, KINDLY CHECK AND REMOVE THE ERROR IF ANY, THANKS

  24. SIR, XL SHEET IS SHOWING ANY DATA IN CAIRN, PNB & VEDL, KINDLY CHECK AND DO THE REQUIRED SO THAT THERE IS DATA FOR THESE 3 SCRIPS ALSO, THANKS

    • Hi Karan,
      Please download the updated sheet we shared. Errors have been resolved.

  25. sir i think it will be useful if u add a date column in your Profitable Intraday Trading system: Excel Sheet

    • Hi Mustak,
      Thanks for your suggestion! We would try to add date column in the sheet.

  26. Hello Sir,
    Thank you for correcting it. Please explain us how to add other stocks to the same excel sheet and get live price with buy/sell signals. Many thanks

    • Hi Nasrudeen,
      For now, this excel sheet is automated for just Nifty 50 stocks. We’ll try to develop another excel sheet where you can add any other stock.

  27. Hi sir ,
    I gon througw all the post and its wonderful experience to read about yours excellent work .
    Just i want to know that ” is pullying live data in xls from any sources like nseindia / google finance or etc is legal ?
    Thanks

    • Hi Optimus,
      Thank you! Yes,it’s totally legal to pull live data from NSE or any other websites. However, it may not be legal to buy Historical data products from NSE and distribute it to others without NSE’s consent.

      • thanks for yours reply, do you have any like where i can refer for NSE legal police about live data pulling ,

        and do you have any system for stock options intraday trading .

        Thanks & regards
        Optimus

  28. Sir, can you help to share trading setup for intra n postional trading

  29. i dont know how to apply excel sheets in my computer. pls explain me. step by step. how to install excel sheet in my stsem

    • Hi Chandrasekaran,
      Please install Microsoft Office in your system. Then you can easily access this Excel sheet.

  31. Thanks a lot for sharing such valuable strategies on excel set up,looking forward for options trading system

    • 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.

  32. Hello Sir,
    Firstly thanks for your nice creation. I am from Bangladesh. I want to use it to our stock market “Dhaka Stock Exchange”. Please guid me to for the way of use it. Thanks in advance.

    • 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.

  34. sir ur really great. Thank you for helping us.
    sir if it’s possible plz upload this excel sheet with mcx live commodity data.

  35. 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. You did and doing a fantastic job 🙂 God bless you and wish your all dreams comes true.
    If you could have also added target levels in excel that would have been wonderful for safe trader like us
    Happyzz helping !!!!

    • Thanks Javed. Target levels can be based on your risk appetite. Try doing profit slicing for two different target levels.

      • Thank Admin for reply. Have you success in creating Future options excel as well ?

  36. Dear admin,
    Good job done by you. Keep it up.
    It would be great if you develop excel sheet for stock futures.

  38. Hello Bhai, Thanks a lot for this !
    Can you please share a sheet with other stocks apart from nifty50, for ex: fno stocks

  40. hello,
    i have a request to make can i have few selected stocks in excel sheet or for online view for this link https://tradingtuitions.com/intraday-open-high-low-strategy-live-signals/.
    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.
    Thank you.

    • Hi Vivek,

      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. Till now, it’s working for me and most of the other readers here.

  41. Appreciating you for your superb indicator… I am not experiment yet and just downloaded and found some errors like BOSCHLTD & LT same market data and CAIRN, PNB & VEDL not updating with market showing #VALUE! kindly check and modify it. and Can u tell me the success rate of this indicator or can u post 1 month result or any backtest…

  42. Hello,

    This excel sheet is not working for me 🙁 Can you please help.

  44. 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. Thanks a lot.

  46. Yes we can,i am using it now, i have taken service from Truedata for live streaming of quotes and my excel shows me all nifty 50 data gives me buy or sell signal using the strategy i have finalized.

  47. Hi,
    This is list of f&o stocks but price of equity, it would be good if you update it with f&o price.

    • Check if the Excel App in your phone supports real-time data connections and macros.

  50. Hi, downloaded excel file, but frequently receiving following error message : “unable to open file //www.nseindia.com/live_market/dynacontent/live_watch/stock_watch/niftystockwatch.json cannot download the information you requested” Please help resolve this issue

  52. Awesome tool brother I m searching like this tool,got it finally can I add some more stocks here if possible tell me how ?

  54. 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. do let me know what needs to be done.
    thanks a ton for sharing this utility
    God Bless you

  55. Hello Sir,

    Thanks a lot for making such wonderful website & various tools.

    I am having query regarding “Profitable Intraday Trading system: Excel Sheet”. The excel file available to download is only having Nifty 50 stock list. Can you please share excel file with F&O Stocks & Index.

    Regards,
    Amit C.

  56. Also unable to pull data from the NSE website, any help would be really appreciated. Great sheets btw, thanks a lot.

  57. 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. Please assist.

  58. Hi, could you please send me the excel sheet of F&O – intraday open high low – to my mail ID – thanks in advance

  59. hi kindly sent your excel sheet of F&O OPEN -HIGH-LOW with live rates up dation link or auto up dation from nse site plz i need it urgently.
    my emila id – pradeepsarin1960@gmail.com
    mobile 08791479781 plz sent & oblige me

  60. Hi Sir,
    How can use this. I need to download the AFL for this strategy. Kindly Help me.

  63. Hi guys,
    I was reviewing the trading rules and have a question.
    you buy if the Open is the low of the day, however, how can you know if it is H or L if the day has not ended.

    • Hi Javeir,

      The rule is to buy when Open=Low for first half an hour of trading. 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!

  64. Dear Sir,
    Many thanks for you to develop a website like this. My doubt is about the entry point. If Open= low ,can we buy the stock on spot rate at 9.45 AM or can we wait till the market reaches the point which mentioned in the ‘Price’ Column? Please advice.
    Hazeer

      • Dear Sir,

        Many thanks for the update. Could you please explain about how i can use this method in commodity trading?

  65. 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? or any other sheet for futures trade. Thanks

  67. Dear Sir,

    Many thanks for the update. Could you please explain about how can I use this method in commodity trading?

    • 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.

    • Hi Geetha,

      Target depends on your risk appetite. I would recommend to use trailing stop loss.

  69. also please suggest if we buy stock after the price mentioned for the buy signal stocks… can we make profit for sure?

    • Hi Geetha,

      All profit/loss calculations in the excel sheet are based on the price column, and you can see it makes decent profits for most of the stocks. But still perform paper trading for few days before going live with this.

  70. Dear Admin, the downloadable excel sheet doesn’t have India VIX, Bank nifty and Nifty signal feeds. Also kindly add few more popular stacks which trades with high volume apart from Nifty stocks

  71. I downloaded excel sheet. It did not ask me Step 2: Open the sheet. It will throw few warnings. Press Ok for all. I downloaded at 15.43 on 07/10/16.
    ACC price being shown is Rs.1395. Present price on NSE is 1624. Guide me please.

  72. Yes. It is working. Please help me. It is showing error in values of CAIRN, PNB and VEDL. What can I do? Can you please tell me how to trade using it? Stop loss I understood. What is “price”? I have buy or sell at this “price”?

  73. Can you share only 5 liquid stocks from nifty50 priced low buy sell price and sl for intraday?

  74. how do i get open-high-low-close information for entire NIFTY stocks? not just NIFTY50.
    What changes do I need to make in Cell E1 of your excel?

  75. Dear M/s, This has reference to your “download link- Intraday trading system” below your “how to use excel sheet step1-6”.
    I downloaded it. It is showing very old price of ACC scrip. How come? Please make it up to date. Or stop writing here down load- Intraday trading system.

  76. Admin ..this setup is great..plz add One more column…Prev Day Close…its for sureshot and choose own stop loss….

  77. Buy Condition Open=Low for the current day. Buy after half an hour of market open
    Sell Condition Open=High for the current day. Sell after half an hour of market open
    Open = low of the day? day starts at 9. closes at 3.15pm . how i will now open = high or low of the day at 9.45 am? how ridiculous? high can be any time in the day or at the end of the day and same for low. how difficult the things are to understand? please explain with and example.

    • ADMIN kindly answe the question for PABLO..NOV 5th..

      Open = low of the day? day starts at 9. closes at 3.15pm . how i will now open = high or low of the day at 9.45 am? how ridiculous? high can be any time in the day or at the end of the day and same for low. how difficult the things are to understand? please explain with and example.

      • Hi Mani,

        The primary assumption of this system is to take positions when Open=High or Open=Low till first 30 minutes of trading hours. Please read the instruction and other comments carefully to understand it better.

  78. Sir,
    I have error on the following line live-updating excel sheet, Please solve it
    Run-time error ‘1004’:
    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: ? [ ] : l *
    . Make sure the file/path name doesn’t contain more than 218

  79. Hello Sir,

    I find the strategy interesting, I have been looking for such a one. Thank you.

    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.

  81. Hi, great work. I have downloaded the file however few stocks are there where data doesn’t get populated. Ex- Cairn, PNB and VEDL

  82. Hi Admin,
    In my excel sheet for some symbols all the values are showing as just #VALUE!, can you please check from your end.

  84. Sir, My request if you may provide an excel sheet to “Evaluate The Option Strategy” before placing the trade. how to calculate probability of Max profit & Loss & risk reward ratio of the Strategy.
    That will be very kind of you, Regards

  86. Hi I noticed that it keep on changing no. of positions like sometimes I see total no. of positions 11 after sometimes it is 9 after 15 min total positions are 7, Could suggest pls how to deal with this ?

    • Hi Radhe,

      The number of positions change when the signals are no longer valid. For ex: Sell signal is generated in the morning when Open=High, but later it vanishes if High crosses the Open price later in the Day.

  88. The way excel is made I am liking it. should I place sl for short day’s high and sl for long day’s low ? Please suggest.

  89. 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.

  90. Admin,

    Can u share EXCEL where we can see all future stocks…this file only contains nifty 50 stocks

    Thanks in advance

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

  92. sir wonderful work you are doing for small investor like me.
    sir can we add script in this excel sheet,like
    siemens….
    which is not there in this sheet.

  94. hi sir,
    i want to ask you if my 1st day trade i have no shares open=high i have no share how this sign i can use it.
    open=low here i can buy but open=high no share how i use to sell shares

  98. Thank you so much for this helpful sheet.

    is it possible to read some of the data directly from BSE site into Excel ? I’m looking for fields like 52 week low,52 week high, last quarter sales amount, Total number of shares available ?

  99. Its an excellent excel sheet. could you help me how to modify for other stocks too such as midcap / nifty 100 etc

  102. hello sir i download that excel sheet but data is not updating its showing value value value everywhere…..ls help me

  103. dear sir it not working whenever i refresh it shows onlu value no real time rates are updated

    • Hi Prem,

      Can you please check your internet connection and also if Macros are enabled in your Excel. Its working perfectly fine at my end.

  104. Dear Sir,
    What a wonderful strategy to share, really have a fan of your work.
    I request you to please allow me to access this excel sheet so that i can update it automatically every day.
    Regards:
    Rajat Sharma

  105. Hello Sir/Madam
    I have downloaded EXCEL SHEET but when I enable INTERNET Connection.All Columns are showing VALUE only.
    Please advice to enable the live excel sheet.

    • Hi,

      Can you please try with Excel 2016, it works perfectly fine in my system.

    • Hi,

      Can you please try with Excel 2016, it works perfectly fine in my system.

  107. Hi,
    I have few doubts in this strategy mainly regarding the entry point and profit calculation.
    1.In the steps you have told to enter the market at 9.45 AM for all stocks for which there are buy/sell signals.
    2.Although tAt 9.45 AM,although the buy/sell signals are still good,the CMP would have already crossed(either buy or sell) the price value mentioned in the excel.
    3.Your profit loss calculation was done considering the price level mentioned in the excel,but we may not get those prices @ 9.45 .In this case the profit/loss percentage would be quite different from how you are calculating right
    Just for example.
    ACC on 4th August,2017,
    SYM OPEN HIGH LOW LTP POS PRICE SL P/L %
    ACC 1,793.50 1,837.00 1,793.50 1,818.45 LONG 1801 1784.5 0.97%
    if we go by the strategy we buy @9.45 at the cmp=1819.85 and ltp of the day=1818.45 which infact resulted in a loss,but the excel says 0.97 profit.Am i doing the correct way or consfused.please expain with an example from recent signals if i am wrong anywhere

  108. Hi,
    The data is free from nse. The data must be delayed by 15 mins? So how can then we use the excel for live trading?

  110. Dear Sir,
    Sorry, but i am not able to update this sheet. i open the sheet, enable the internet connection and it shows value value signs doesnt show prices, i mean in all the columns only value word is written when i enable the internet connection. please inform me how to do this.

  112. Hi … is there a way I can get a excel created which will give me every 30 min high and low for all FNO stocks of india..dont need a live . Need EOD data

  116. Hi Admin,

    would like to know , if at all want to add some more stocks based on our wish list, can we add it? what would be the procedure. appreciate your help on this.

    • Hi Nabhi,

      Right now there is no way to do that. We shall come up with the improved version of sheet in future.

  118. Hi Admin,
    Do you have excel sheet for FO stock for intraday trading similar to Nifty50 stock list excel sheet?

  119. I wanted to extend the formula for more stocks but it seems the code is pwd protected. Can you please remove that 🙂

  120. Sir,
    Excellent work. please give link .json for F&O stocks. i want to modify this excel sheet for FO stock.

  122. Kindly make it web based instead of excel. Loading time is slow. Secondly as open= low or high hits in the morning 9:15 only. So please keep only those shares instead of all. Hope you understood.

    Thanks

  123. It wont work on Google Spreadsheet, How can i place these excel into Google Spreadsheet so that it can work on drive

    • Hi Pankaj,

      You would need to manually update the current data in the sheet. This excel doesn’t auto updates

  125. Dear Admin
    Excellent work on getting this excel sheet together.
    Will it be possible for you to pull the “nifty500StockWatch” from the web onto the excel sheet instead of the existing “niftyStockWatch” so that more stocks can be monitored.
    Thanks

  128. Hello

    There are certain issues with the downloadable spread sheet (Intraday Trading system v3.0) Here are some of the observations.
    1. Lupin data is not getting populated
    2. HDFC and HDFC Bank are showing the same values.
    Otherwise this is perfect.
    Please rectify the defectd.

  129. i just downoaded this sheet values for scripts are not updated..do i need to anything on this..

  130. Hey. Great work first of all. Very helpful to beginners like me. I was wondering if this (OHLC) strategy could be used with liquid Futures as well? And if yes, then do we need need to make some change in the Time Frame or Execution?
    Thanks in advance.

  132. dear sir i want commodity intraday strategy excel sheet, please how to use this on commodity segment???

  135. unable to open http:/www.nseindia.com/live_market/dynacontent/live_watch/stock_watch/niftystockwatch.json The internet site reports that the item you requested could not be found (http/1.0 404)
    when open intraday-trading-system v3 file so see this error so please solve this issue.

  136. I have a problem in trfreshing the excell shhet which i downloaded from the link provided vy you.It says cannot open the nse website link
    can you please help

Leave a Reply

Your email address will not be published.