Rajandran R Telecom Engineer turned Full-time Derivative Trader. Mostly Trading Nifty, Banknifty, USDINR and High Liquid Stock Derivatives. Trading the Markets Since 2006 onwards. Using Market Profile and Orderflow for more than a decade. Designed and published 100+ open source trading systems on various trading tools. Strongly believe that market understanding and robust trading frameworks are the key to the trading success. Writing about Markets, Trading System Design, Market Sentiment, Trading Softwares & Trading Nuances since 2007 onwards. Author of Marketcalls.in)

How to Extract Data from Nseinda.com using Google Docs

11 sec read

httpv://www.youtube.com/watch?v=ovOpb6q8d2c
[wp_ad_camp_5]

 
Here is a short and very simple video tutorial about how to extract remote data from a webpage(nseindia.com) into your google spreadsheet. It also describes how to share the Extracted table content to the external world.

Rajandran R Telecom Engineer turned Full-time Derivative Trader. Mostly Trading Nifty, Banknifty, USDINR and High Liquid Stock Derivatives. Trading the Markets Since 2006 onwards. Using Market Profile and Orderflow for more than a decade. Designed and published 100+ open source trading systems on various trading tools. Strongly believe that market understanding and robust trading frameworks are the key to the trading success. Writing about Markets, Trading System Design, Market Sentiment, Trading Softwares & Trading Nuances since 2007 onwards. Author of Marketcalls.in)

How to Get Futures and Options Data and Commodities…

In this blog, we will explore how to use Algomojo to get futures and options data and commodities data into Google Spreadsheet, step by...
Rajandran R
4 min read

Algomojo Google Spreadsheet to Transmit Basket Orders, Larger Orders,…

Algomojo, the leading algorithmic trading platform, is proud to announce the launch of its latest feature - the Google Spreadsheet Module. The new module...
Rajandran R
1 min read

What is Retail Digital Rupee?

The retail digital rupee will be introduced on December 1 as part of a pilot programme, the Reserve Bank of India (RBI) stated in...
Rajandran R
1 min read

41 Replies to “How to Extract Data from Nseinda.com using Google Docs”

  1. Hi Rajandran ,
    I would like to know how to get – The Foundation by Southwind v-13.00 Int AFL Code on my PC , please tell from the scratch in simple language . thx.

  2. Really Rajendaran, good video help us in publishing, blogging. Thanks to introduce us for this new knowledge.

    Thanks, and keep it up.

    Regards:
    Sourabh

  3. Dear Mr. Rajendran,

    Very useful video. Thanks for the same.

    and Southwind v-13.00 – wrking fien, but how to use it, if any manual ava, pls share the link.

    Thank you,
    sat

  4. Dear Rajandran

    A very interesting bit of information watching this video on “importing” data from nse. I am facing a problem. Could you please help. When I write “importhtml….nothing happens..ie no options of url/query etc pop up. Am I missing something out. Please advise.Thanks and Regards.

  5. Rajandran,
    You are gr8…as always.Thanx for introducing newer technologies to novices like us.Ur simple style of explaination is awsome.
    Regards

  6. Thank Rajendran for nice video. I use excel extensively in my trading but u have just exposed me to great feature of google docs.

    Thanks again.. and keep up the great work.

    1. Hi vineet… If the data size is very huge then it updates only when you open the speadsheet. If the data size is small then it updates every 30 minutes.
      Real time is not possible 🙂

  7. Thanks for the data. If I apply this formula, I get an error message. I am not able to retrieve the data. Please can you help.

  8. Hi,

    This does not work with the new version of the NSE website.

    Are you able to import to google docs?

    Thanks,
    Keerthi

  9. Dear Rajendran…

    Is there any provision to get real time stock data into Excel…
    atleast that for NSE stocks…??

    1. Dear Rajandran
      We got very interesting information watching this video on “importing” data from nse. I am facing a problem. If i apply this formula, i am not able to retrieve the data from the new version of the NSE website. Please help…

  10. Thanks for posting this useful tutorial.
    Can you please help me to extract data from NSE or ODIN for currency rates into google docs
    Regards and Thanks again.

  11. I want to get the stock prices of peer companies for various dates in excel sheet from nseindia.com. Could you please help me out. for example
    20/3/2013 12/3/2012
    L&T 1003 870
    Adani 15 30

  12. hi,

    very helpful website. thanks.

    i have a problem downloading using web queries from nseindia.com. How can one download data through excel web query when the said site has dropdown menus. To understand my problem better, try downloading 8100c for the month of sep14 through webqueries.and then refresh. is there is a way to work around drop down menu selection? something from vba.

    thanks

  13. Hello Rajendran,

    Could this spreadsheet be used for creating screens for few selected parameters. For example, I wish to know all scrips listed in NSE whose market cap is less than the previous years total sales or say a list companies whose total debt is less than 10 Cr. and so on. If not, then is there a way it can be done for both NSE and/or BSE. Kindly opine. Thank you.

      1. Thanks, Rajandran. I know about that site but did not find the search parameters for debt screening and ratios of market cap in relation to total sales and similar stuff. No sure, maybe I might have overlooked something.

  14. hi rajandra,

    your website has been extremely useful to me. thanks. i wonder if you suggest some software/freeware for accounting of digital contract notes. updating everyday in excel sheet based on type of trade i.e. fno, cash intraday, short term trade, long term, etc is becoming cumbersome. what may be the way out?

    thanks in advance.

  15. Hi Rajendran,

    I am not able to pull NSE data in google docs. Though the same is working fine when I try to import NSE data at the desktop EXCEL file.

    Same is not working when applying to Google Docs.

    Please help

  16. I have tried

    =importhtml(“http://nseindia.com/live_market/dynaContent/live_watch/option_chain/optionKeys.jsp?symbolCode=-10006&symbol=NIFTY&symbol=NIFTY&instrument=-&date=-&segmentLink=17&symbolCount=2&segmentLink=17″,”Table”,2}

  17. the below link is working in google spreadsheet.
    =IMPORTHTML(“http://nse-india.com/live_market/dynaContent/live_watch/option_chain/optionKeys.jsp?&symbol=NIFTY&date=24SEP2015″,”table”,3)

    regards,

    sathesh

  18. Thank Rajendran for nice video. I use excel extensively in my trading but u have just exposed me to great feature of google docs.

    Thanks again.. and keep up the great work. Ravi

  19. Thank you for the informative video. I have been trying for a considerable time to extract data from google sheets into ninjatrader 7. If you have any advice with this I would truly appreciate it.

  20. Hii sir i want to know how to extract query link from nseindia.com please let me know….?

Leave a Reply

Get Notifications, Alerts on Market Updates, Trading Tools, Automation & More