Import Live Data from Angel Speed Pro to Microsoft Excel

Angel Speed Pro To Microsoft Excel

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

Angel Speed Pro Open In Excel

A small window will pop up asking which sheet to populate the data. Select the default option Sheet 1.

Speed Pro Select Sheet

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.

Angel Speed Pro Arbitrage Xls

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

Is Angel Broking Speed Pro free?

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.

How do I retrieve live data from NSE to Excel?

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.

How do you automatically update stock prices in Excel?

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.

How do I link nest data in 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.


Discover more from StockManiacs

Subscribe to get the latest posts sent to your email.

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Scroll to Top