Introduction
Nowadays, many major stockbrokers provide the facility to connect their trading terminals to Microsoft Excel. This is because you can create robust trading systems in Excel by writing your own formulas. If you can get live data for free in Microsoft Excel, your job becomes easier. Already we have seen how to get data from the trading terminal of ShareKhan and also of Zerodha, India’s leading discount broker. In this post, I will show you how to connect Angel Speed Pro to Microsoft Excel.
Benefits of Connecting Trading Terminal to Excel
There are several benefits of connecting your trading terminal to Microsoft Excel. Firstly, it allows you to create customized trading systems with your own formulas and codes. Secondly, you can easily import live data into Excel, which makes it easier to monitor the markets and make trading decisions. Finally, Excel provides powerful data analysis tools that can help you identify trading opportunities and improve your overall performance.
Preparing to Import Live Data from Angel Speed Pro to MS Excel
Before you can import live data from Angel Speed Pro to Microsoft Excel, you need to ensure that you have the following:
- Firstly, you need Angel Speed Pro installed on your computer.
- Secondly, you need Microsoft Excel installed on your computer
- Lastly, you also need a market watch containing the stocks you want to monitor
Step-by-Step Guide to Importing Live Data from Angel Speed Pro to Microsoft Excel
Here’s a step-by-step guide on how to import live data from Angel Speed Pro to Microsoft Excel:
Step 1: Run Angel Speed Pro and log in to it
The first step is to run Angel Speed Pro and log in to it using your credentials.
Step 2: Open your Market Watch
Next, open your market watch in Angel Speed Pro. I recommend you to open a market watch containing all Nifty 50 stocks.
Step 3: Right-click on the Market Watch and click Open In Excel
Right-click on the market watch and click “Open In Excel” (or press Ctrl+E).
A small window will pop up asking which sheet to populate the data. Select the default option Sheet 1.
Step 4: Select the default option Sheet 1
Select the default option Sheet 1. This will open the Excel sheet named Arbitrade.xls. You can see live data flowing into Excel. Here also, you can create your trading system on this Excel.
Creating a Trading System from Angel One Data on Microsoft Excel
To create a trading system on Microsoft Excel, you need to have a good understanding of how to use Excel formulas and functions. If you do not know how to create a trading system on Microsoft Excel, you can refer to my post on connecting the Zerodha Pi terminal to Excel for more information. From Pi, you can get both the live and Intra EOD or IEOD data.
Additional Resources
Here are some additional resources that can help you improve your trading performance:
Open High Low Same Trading Strategy For Indian Stock Market
This post provides information on a simple trading system that you can use in the Indian stock market.
Video: How To Angel Speed Pro To Excel?
The video below demonstrates importing live data from Angel Speed Pro to Microsoft Excel.
FAQ
No, Angel Broking Speed Pro is not a free platform. However, it is available to Angel Broking clients for free if they meet certain conditions, such as maintaining a minimum account balance or generating a certain amount of brokerage fees. Now Angel One platform replaced Speed Pro and that is free for all Angel One clients.
To retrieve live data from NSE to Excel, you can use various plugins or APIs available in the market. One popular option is to use the “Open in Excel” feature available in most trading terminals. Another option is to use Python and Pycharm. This feature allows you to directly import live data from the NSE exchange into an Excel sheet.
To automatically update stock prices in Excel, you can use the “Data” tab in Excel and select the “From Web” option. From there, you can enter the URL of the webpage that contains the stock prices you want to track. Excel will automatically import the data from the webpage and refresh it at regular intervals. Another option is to use APIs or plugins available in the market that allow you to directly import live data into Excel.
To link Nest data in Excel, you can use the “Open in Excel” feature available in the Omnesys Nest trading terminal. This feature allows you to directly import live data from the market watch into an Excel sheet. Alternatively, you can use various plugins or APIs available in the market that allow you to link Nest data in Excel.
Conclusion
Opening a Trading Account in Angel One
To open a trading account in Angel One company directly, you can click the link provided here.
Switching to Zerodha Kite
Lastly, I want to mention that as Angel Speed Pro is a Java-based platform, charts and other features are still not so advanced. Therefore, I recommend switching to Zerodha Kite instead.