Investing / Trading

How do I download BSE and NSE stock prices in Excel in real time?

Kapil Marwaha · 18 July 2016 · 282 Comments
Share
NSE Stock Prices in Excel in Real Time - Microsoft Excel is a super software capable of doing a lot of calculations and providing results easily, some of which many Technical Analysis Applications would fail to provide.

Getting real-time data into Excel can be a very powerful tool, as the possibilities in excel are huge and only limited by your imagination.

[caption id="attachment_317" align="alignnone" width="1366"]NSE Real Time Charts in Excel, NIFTY Open Interest, NIFTY Excel Nifty-I Open Charts & Pricing in Excel[/caption]

With only a little knowledge of Excel, you can implement new strategies/ideas, back-test them and even paper trade these strategies before going live.

Excel can sometimes do things which many technical analysis applications may not be able to. For eg..:—

  • Create complex trading systems and conduct technical analysis calculations directly in your worksheets.
  • Build and backtest your strategies involving more than 1 scrip eg. pair trading strategies
  • Very useful for tracking a large number of options simultaneously eg. Tracking their open interest/price variations, while studying the put/call ratios & option Max Pain analysis

Real Time NSE Data in Excel ,Real Time BSE Data in Excel    Open Interest Strategy at Work In Excel

  • Can even help you with data mining and pattern exploration studies
  • Keeping track of complex options strategies where a number of options need to be tracked at the same time
  • Just simply tracking your portfolio in real time
  • .. and a lot more...
[symple_heading style="" title="How can we achieve this ?" type="h2" font_size="" text_align="left" margin_top="18" margin_bottom="18" color="undefined" icon_left="" icon_right=""]

To be able to enable this ability and more, you will need to exploit the Excel's RTD Function. The RTD function is an excellent way to retrieve real-time data from a program that supports COM automation.

Some older applications used DDE to import real-time data into Excel but this is now a thing of the past as we have the more powerful and versatile RTD function in Excel.

TrueData.Velocity.2.0 is one such software which can provide you with NSE Stock Prices in Excel. This application can help you analyse 200 - 500 NSE Equities, Indices, ETFs, Futures & Options in Real-time in Excel at the same time

With Velocity, also using Excel's ADD IN functionality to add forms, you would be able to also download Tick, 1, 5, 15, 60 min & EOD Historical Data.

[caption id="attachment_327" align="alignnone" width="787"]Max Pain Options Max Pain Chart in Excel[/caption]

If you would like to know more about this integration you can get it from this Article here. [2]

Footnotes

[1] TrueData™ | Real Time Data | Real Time NSE Data | Tick Data

[2] Excel Integration with Velocity 2.0 (RT + Historical)

Kapil Marwaha

Kapil Marwaha is the Founder & Managing Director of TrueData Financial Information Pvt. Ltd..

His aim - "To make TrueData the Best Trading Decision Support company in the country." TrueData's flagship product Velocity 2.0 has already become immensely popular and is used by a large audience through out the country.

Comments (282)
Kapil Marwaha
February 26, 2017

Thank you & Go ahead !

JYupWMLW
February 19, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

Kapil Marwaha
February 26, 2017

Glad you liked it !

JYupWMLW
February 19, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

DARSHNA SONI
March 17, 2017

hi, can we get the ABSOLUTE VALUE OF CHART , EG, MACD VALUE ONLINE IN THE EXCEL FORMAT OR JAVA FORMAT, PLS DO REPLY, THANK YOU

Kapil Marwaha
August 01, 2017

It's possible, but not from the server. you will need to derive these by calculating the same, by either doing it directly in the excel spreadsheets (if possible) or else by developing a specific macro for the same. I guess you would need to connect with some macro experts who could help you with this.

JYupWMLW
February 19, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 19, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

sreenivas
May 03, 2017

Hi Kapil, Is it possible to read some of the data directly from BSE site into Excel ? I’m looking for fields like 52 week low,52 week high, last quarter sales amount, Total number of shares available ? Especially total number of shares, number of shares pledged,dividend for last year.. Want to create some formulas base don these values. Thanks for all the useful information and help.

Kapil Marwaha
August 01, 2017

I am not sure about having this done from the BSE site, however, we would be trying to get this functionality in the future.

JYupWMLW
February 19, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 19, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 22, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 22, 2024

1

Raja
May 15, 2017

I am using Amibroker with Truedata. Can i still use Excel plugin in the same account

Kapil Marwaha
August 01, 2017

Yes ! All at the same time, same PC, same data subscription! TrueData Velocity 2.0, connects to Microsoft Excel (Real time & Historical), Amibroker, NinjaTrader 7 & 8, Updata Analytics, Python, C#.NET, Metastock, Multicharts, Advanced Get 9,0 RT Dashboard Edition, Arthachitra and many more TA, at the same time, same PC, same data subscription.

JYupWMLW
February 19, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 19, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 22, 2024

1

JYupWMLW
February 20, 2024

1

VIVEK KUMAR SINGH
June 18, 2017

i was searching for how to get real time data in excel and read your post it is really great... thanks

Kapil Marwaha
August 01, 2017

Really glad you liked it ! :-)

JYupWMLW
February 19, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 22, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 22, 2024

1

JYupWMLW
February 19, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 22, 2024

1

JYupWMLW
February 20, 2024

1

Satyajeet
June 21, 2017

where can i get the historic data in .csv or excel format

Kapil Marwaha
August 01, 2017

The TrueData Excel Plugin provides you with an Add-in in Excel, which enables you to download Historical data directly into excel. You can get data for the date range you need for Tick, 1 min, 5 min, 15 min, 60 min & EOD. All the data is adjusted. The tick data is provided as is and not changed.

Kapil Marwaha
August 01, 2017

Also, it is possible to get data in '.txt' & '.csv' format directly from velocity 2.0. You can select a bunch of files and download the IEOD data directly on your desktop.

JYupWMLW
February 19, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 22, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 22, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 22, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 19, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 22, 2024

1

JYupWMLW
February 19, 2024

1

JYupWMLW
February 20, 2024

1

Keshav
June 25, 2017

What's d cost of Velocity?

Kapil Marwaha
August 01, 2017

PLease visit the pricing page and follow the steps 1 through 4 to calculate the pricing as desired by you. TrueData Pricing > http://j.mp/30YlJxB You can also see the comparison pages prior to understanding the pricing'' Velocity Plans > http://j.mp/2RW8bP3 Velocity Plus Plans > http://j.mp/2O0OrIT Hope it helps!

JYupWMLW
February 19, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 19, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 22, 2024

1

surface
November 20, 2017

Gr?at art?cle.

Kapil Marwaha
October 09, 2018

Glad you like it !

JYupWMLW
February 19, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 19, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 21, 2024

1

Richi kumar sandil
March 23, 2018

Hello sir Is it possible to use ur data for my website or mobile application ? I need tick data

Kapil Marwaha
October 09, 2018

Yes, get in touch with our support and we will give you the best solution for your requirements.

JYupWMLW
February 19, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 19, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 21, 2024

1

visit Sikkim
April 04, 2018

Hello. Great article.

Kapil Marwaha
October 09, 2018

Thank you so much !

JYupWMLW
February 19, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 19, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 21, 2024

1

Dilip sarda
April 24, 2018

I am interested true real time data in excel Can you please provide.

Kapil Marwaha
January 21, 2019

Please register for a Trial and then you can see it for yourself. We help you for all the set up. Only thing is that you require Excel 2013 & above + the TrueData Velocity Optima version.

JYupWMLW
February 19, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 19, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 21, 2024

1

eebest8 best
June 17, 2018

"I appreciate you sharing this article post.Really thank you! Much obliged."

Kapil Marwaha
October 09, 2018

Glad you liked it !

JYupWMLW
February 19, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 19, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 21, 2024

1

Sudheer
August 08, 2018

Do you offer any service to provide present(live) day Equity and FNO 1/5/15 minute OHLC data feed into Excel? I mean, I just require previous 1/5/15 minute OHLC data of live session for multiple scripts.. Is it possible. please let me know..

Kapil Marwaha
January 21, 2019

For now, we provide this as historical data from Excel and also directly from Velocity. For Live snapshot updates of 1 / 5 / 15 min updates we have APIs but not for Excel. We are working to get this functionality into Excel in the near future.

JYupWMLW
February 19, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 19, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 21, 2024

1

JYupWMLW
February 20, 2024

1

JYupWMLW
February 21, 2024

1