Rajandran R Founder of Marketcalls and Co-Founder Algomojo. Full-Time Derivative Trader. Expert in Designing Trading Systems (Amibroker, Ninjatrader, Metatrader, Python, Pinescript). Trading the markets since 2006. Mentoring Traders on Trading System Designing, Market Profile, Orderflow and Trade Automation.

How to Extract Data from Nseinda.com using Google Docs

11 sec read

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

 
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 Founder of Marketcalls and Co-Founder Algomojo. Full-Time Derivative Trader. Expert in Designing Trading Systems (Amibroker, Ninjatrader, Metatrader, Python, Pinescript). Trading the markets since 2006. Mentoring Traders on Trading System Designing, Market Profile, Orderflow and Trade Automation.

How to Send Automated Orders from Tradingview to Algomojo…

This tutorial explores how to send automated orders from Tradingview using webhook method to Algomojo Trading Platform. Webhook is a unique way of communicating...
Rajandran R
2 min read

TradersKart – One Stop Shop for Traders

TradersKart offers One-Stop E-commerce Solution for all the traders, where traders will get access to their trading needs. Traderskart provides the necessary tools required...
Rajandran R
53 sec read

New Margin Framework for Options Trading and Market Outlook…

In this tutorial, we covered detailed indepth insights on the current market structure and the outlook for June 2020. Also New Margin Framework which...
Rajandran R
22 sec read

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

Leave a Reply

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