How To Create Intraday Trading Excel Sheet From Sharekhan TradeTiger?

Intraday Trading Excel Sheet

In this post I will show you how you can create a highly accurate intraday trading excel sheet from Sharekhan TradeTiger terminal. We will first download live data in excel from the Sharekhan Trade Tiger terminal and later we will apply a formula for intraday trading system on the live data. Let me do it step by step.

First login to Sharekhan Trade tiger terminal. Once you are logged in open your market watch. Here I will open predefined NSE Nifty50 market watch to get live data of all Nifty50 stocks data in excel.

Please see the screenshot below to see how to open a marketwatch in Sharekhan TradeTiger.
TradeTiger Open MarketWatch
So, now your NSE Nifty50 stocks marketwatch will be opened and you can see the market watch like the following image:
NSE MarketWatch Sharekhan TradeTiger
Now we will activate Trade Tiger’s snap to excel funsction and click on New Snap. Check the image below:
Sharekhan TradeTiger Snap To Excel
This function will try to save the marketwatch snapped into excel and will ask you for the save location of the excel file. Provide an appropriate name for the excel sheet. I named it Nifty50. Save it to the default folder as shown in the image below:
Sharekha TradeTiger Save New Snap
So the intraday trading excel sheet will now be saved in the default location and the file will be opened automatically. The excel workbook contains 3 sheets and the first is Streaming_Stock_Watch and you can not make changes to this. If the market is open you can see prices changing like terminal in this sheet.
TradeTiger Streaming Watchlist
Now go to the second sheet called WorkArea. This sheet can be modified and you can apply formula in this sheet. This intraday trading excel sheet automatically contains daily pivot levels. We will build a highly accurate intraday trading system using Open High Low Same Trading Strategy For Indian Stock Market.

In the last column I have given heading Open = High and next column I have given heading Open = Low. Now in my intraday trading excel Open is in column J, High is in column K and Low is in column L. So Open = High formula for first stock I have used:

=IF(J9=K9,”SELL”,””)

For Open = Low formula for first stock I have used:

=IF(J9=L9,”BUY”,””)

Now drag the formulas through out both the columns and your buy sell signal using excel is complete using Sharekhan TradeTiger. Today, is 1st March, 2017 and I have got BUY candidates: INFRATEL, ITC and SELL candidates LUPIN, M&M, ONGC, TATAMOTORS and ULTRACEMCO. Check the image below:
Intraday Trading Excel Sheet
Trading Strategy Using The Open Equals To High OR Low Intraday Trading Excel Sheet:
BUY and SELL to be executed after 15-30 minutes of trade. For BUY keep a 1%-2% intraday target and keep stop loss few ticks below day’s low. For SELL keep a 1%-2% intraday target and keep stop loss few ticks above day’s high. You can test the strategy and let me know your observations in the comment below.

Author Bio

Indrajit Mukherjee

Indrajit is a professional blogger and Trading System developer, Amibroker expert, Wordpress expert, SEO expert and Stock market analyst. Trading since 2000, he has started the journey of StockManiacs.net on 2008. He follows Indian and world stock markets closely.

6 Responses to How To Create Intraday Trading Excel Sheet From Sharekhan TradeTiger?

  1. h n shah says:

    Very nicely explained. Can we put buy or sell order using this excel sheet directly from the sheet?

  2. Avinash J.R. says:

    It’s a good reading but it is very old strategy which may not be successful.I also read about ur article about using Renko charts & u are the only one to explain for the Indian markets, i really appreciate ur efforts.But in Pi the renko for nifty futures gives very big boxes unlike Kite.Pi is the most easiest to use but there some drawbacks so if you can inform Zerodha to check into it.

    • Avinash you are correct. But I have seen markets run in cyclical nature. So old strategies start working after 8-10 years. Pi also you can control box sizes. Try a 10 size box in 2 minutes renko chart of Nifty. Check HERE.

  3. JAYANTA GHOSH says:

    thank you Mr Indrajit for this beautiful tool. It seems, setting a target for buy or sell depends on price of particular scrip. like 1-2% for stock price 1000. Precisely, based on individual’s trading style and appetite. No gyan, only my observation.
    regards
    Jayanta Ghosh

Leave a Reply