Category Archives: Excel

Create Your Own Excel Stock Research System Using Quandl Stock Data

In my post Quandl – Download Free Amibroker End Of Day Data, I had discussed how you can download free end of day data for Amibroker. In this post we will discuss how you can download quandl stock data and use it for creating an excel stock research system in no time.

Quandl Excel AddinFirst go to Quandl site and create a free account. Next visit the Quandl Excel Add-in page by clicking HERE

How To Import Live Data From Angel Speed Pro To Microsoft 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

How To Import IEOD Data From Zerodha Pi To Amibroker Using Excel

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

How To Connect Zerodha Pi To Excel To Build An Excel Trading System?

Few days back I have written How To Create Intraday Trading Excel Sheet From Sharekhan TradeTiger? That post has got very good response from my readers and I have got many request from my Zerodha clients for posting know how on creating simiter excel trading system connecting Zerodha Pi to excel. If you dont have Zerodha Pi, you can apply for a Zerodha account by clicking HERE.

First login to your Zerodha Pi terminal. Once Pi is logged in open the Nifty50 all scrips market watch by clicking File

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

error: Content is protected !!