How to get NSE Live data in Excel !

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

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.

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

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.

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.

will u pls explain how it is pls

Re: How to get NSE Live data in Excel for odin diet client

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

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

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/

Dear lasty66,
View this Post .
http://www.traderji.com/intraday/68...broker-without-any-software-2.html#post661677