How to get NSE Live data in Excel !

Discussion in 'Intraday' started by lasty66, Mar 21, 2012.

  1. lasty66

    lasty66 Active Member

    Joined:
    Mar 22, 2009
    Messages:
    162
    Likes Received:
    59
    Trophy Points:
    28
    Friends,
    Can somebody help with downloading Live data in Excel... eg.I want to have all nifty stocks in excel worksheet with live data updated every minute. :)

    Thanks
    Vijay
     
  2. chandra1

    chandra1 Active Member

    Joined:
    Mar 13, 2012
    Messages:
    145
    Likes Received:
    38
    Trophy Points:
    28
    Hi friend
    I have searched in TJ. There are many links in TJ but none is working. Either attached files are no longer there (deleted or removed), or links are dead/expired.
     
  3. lasty66

    lasty66 Active Member

    Joined:
    Mar 22, 2009
    Messages:
    162
    Likes Received:
    59
    Trophy Points:
    28
    Hi Chandra,
    Actually I had such a utility some time back.....but unknowingly I formatted my hardisk and lost it.....i tried searching TJ ...but no avail
     
  4. chandra1

    chandra1 Active Member

    Joined:
    Mar 13, 2012
    Messages:
    145
    Likes Received:
    38
    Trophy Points:
    28
    I can help you, if you have any idea about its name etc. or any other detail.
    BTW if you get the link please do help me.
     
  5. sleeping_chld

    sleeping_chld New Member

    Joined:
    Mar 13, 2012
    Messages:
    11
    Likes Received:
    4
    Trophy Points:
    3
    Location:
    Mumbai
    Two options:
    1. If you have NOW of Odin Diet, you can get live prices in excel.
    2. Use the Import External Data>New Web Query feature in Excel and get the data using yahoo as a source. You can set it to update every minute. You will first have to login to yahoo otherwise the data might be delayed

    I had done this long ago so know this is one approach. I haven't tried the logging in part though.
     
    chandra1 and lasty66 like this.
  6. anantharaaman

    anantharaaman Active Member

    Joined:
    Nov 1, 2007
    Messages:
    130
    Likes Received:
    30
    Trophy Points:
    28
    will u pls explain how it is pls
     

  7. cap21

    cap21 Member

    Joined:
    Jun 9, 2011
    Messages:
    31
    Likes Received:
    1
    Trophy Points:
    8
    Re: How to get NSE Live data in Excel for odin diet client

    how to get real time free data from odin diet client!
     
  8. chandra1

    chandra1 Active Member

    Joined:
    Mar 13, 2012
    Messages:
    145
    Likes Received:
    38
    Trophy Points:
    28
    Please explain the procedure in detail, if possible. It will be a great help to we non techie people.

    I remember doing this feature IMPORT EXTERNAL DATA in MS Excel 2007 as mentioned in a website, a few weeks back (i do not remember the whole procedure, how I did it) but I remember I left the project as there was no option to update the sheet or some macro problem or something like this.

    Thanks
     
  9. sleeping_chld

    sleeping_chld New Member

    Joined:
    Mar 13, 2012
    Messages:
    11
    Likes Received:
    4
    Trophy Points:
    3
    Location:
    Mumbai
    Odin Diet feature has to be allowed by your broker. If not allowed, I'm not sure whether you'll even see the option or not.
    If your broker provides NOW that would be recommended.

    For Excel, please refer to the below links. As you'll see in the screenshots on these websites, refresh option is there. I have not tried any macros on this but I think that should also work.

    http://www.mrexcel.com/tip103.shtml
    http://allfinancialmatters.com/2006/11/15/how-to-insert-refreshable-stock-quotes-into-excel/
     
    chandra1 likes this.
  10. smarttrade

    smarttrade Active Member

    Joined:
    Jun 18, 2010
    Messages:
    111
    Likes Received:
    39
    Trophy Points:
    28
    chandra1 likes this.
Loading...

Share This Page