Category Archives: Excel
Nowadays all major stock brokers are providing facility to connect their trading terminal to microsoft excel. This is because you can create robust trading systems on excel writing your own formulas. So if you can get live data free of cost in microsoft excel your job becomes easier. I have already written How To Create Intraday Trading Excel Sheet From Sharekhan TradeTiger? and
Zerodha’s Pi platform contains 120 days of continuous intraday data. You can see this 90 days continuous chart in the ZERODHA PI platform. This continuous intraday data is also called IEOD. IEOD is the short form of Intra-EOD. Means its an intraday data but you get access to it only end of day (EOD). But this IEOD data is specifically helpful if you want to backtest in advanced platforms like Amibroker
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