Traderji.com - Discussion forum for Stocks Commodities & Forex


How to get NSE Live data in Excel !

Discuss How to get NSE Live data in Excel ! at the Intraday within the Traderji.com - Discussion forum for Stocks Commodities & Forex; Friends, Can somebody help with downloading Live data in Excel... eg.I want to have all ...


Go Back   Traderji.com - Discussion forum for Stocks Commodities & Forex > TOOLS & RESOURCES > Data Feeds > Intraday



Reply
 
Thread Tools
  #1  
Old 21st March 2012, 01:48 PM
Member
 
Join Date: Mar 2009
Posts: 129
Thanks: 300
Thanked 47 Times in 32 Posts
lasty66 will become famous soon enough
Default 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



Reply With Quote
Sponsored Links
  #2  
Old 21st March 2012, 02:18 PM
Banned
 
Join Date: Mar 2012
Posts: 148
Thanks: 223
Thanked 40 Times in 36 Posts
chandra1 is on a distinguished road
Default Re: How to get NSE Live data in Excel !

Quote:
Originally Posted by lasty66 View Post
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.
Reply With Quote
  #3  
Old 21st March 2012, 02:21 PM
Member
 
Join Date: Mar 2009
Posts: 129
Thanks: 300
Thanked 47 Times in 32 Posts
lasty66 will become famous soon enough
Default Re: How to get NSE Live data in Excel !

Quote:
Originally Posted by chandra1 View Post
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
Reply With Quote
  #4  
Old 21st March 2012, 02:49 PM
Banned
 
Join Date: Mar 2012
Posts: 148
Thanks: 223
Thanked 40 Times in 36 Posts
chandra1 is on a distinguished road
Default Re: How to get NSE Live data in Excel !

Quote:
Originally Posted by lasty66 View Post
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.
Reply With Quote
  #5  
Old 21st March 2012, 02:59 PM
sleeping_chld's Avatar
Member
 
Join Date: Mar 2012
Location: Mumbai
Posts: 11
Thanks: 0
Thanked 4 Times in 3 Posts
sleeping_chld is on a distinguished road
Default Re: How to get NSE Live data in Excel !

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.
Reply With Quote
The Following 2 Users Say Thank You to sleeping_chld For This Useful Post:
chandra1 (21st March 2012), lasty66 (21st March 2012)
  #6  
Old 21st March 2012, 07:18 PM
Member
 
Join Date: Nov 2007
Posts: 129
Thanks: 79
Thanked 30 Times in 25 Posts
anantharaaman will become famous soon enough
Default Re: How to get NSE Live data in Excel !

will u pls explain how it is pls
Reply With Quote
  #7  
Old 21st March 2012, 07:24 PM
Member
 
Join Date: Jun 2011
Posts: 31
Thanks: 0
Thanked 1 Time in 1 Post
cap21 is on a distinguished road
Default Re: How to get NSE Live data in Excel for odin diet client

how to get real time free data from odin diet client!
Reply With Quote
  #8  
Old 21st March 2012, 07:36 PM
Banned
 
Join Date: Mar 2012
Posts: 148
Thanks: 223
Thanked 40 Times in 36 Posts
chandra1 is on a distinguished road
Default Re: How to get NSE Live data in Excel !

Quote:
Originally Posted by sleeping_chld View Post
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
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
Reply With Quote
  #9  
Old 22nd March 2012, 10:15 AM
sleeping_chld's Avatar
Member
 
Join Date: Mar 2012
Location: Mumbai
Posts: 11
Thanks: 0
Thanked 4 Times in 3 Posts
sleeping_chld is on a distinguished road
Default Re: How to get NSE Live data in Excel !

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/...es-into-excel/
Reply With Quote
The Following User Says Thank You to sleeping_chld For This Useful Post:
chandra1 (23rd March 2012)
  #10  
Old 22nd March 2012, 12:32 PM
Member
 
Join Date: Jun 2010
Posts: 107
Thanks: 77
Thanked 39 Times in 27 Posts
smarttrade is on a distinguished road
Default Re: How to get NSE Live data in Excel !

Quote:
Originally Posted by lasty66 View Post
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
Dear lasty66,
View this Post .
http://www.traderji.com/intraday/681...tml#post661677


Reply With Quote
The Following User Says Thank You to smarttrade For This Useful Post:
chandra1 (22nd March 2012)
Reply

Bookmarks


Advertise Here


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads for: How to get NSE Live data in Excel !
Thread Thread Starter Forum Replies Last Post
Can my Odin execute orders which i place in excel ?? can excel sync ths data ? abhisin111 Software 4 2nd February 2013 11:06 AM
Live FnO Data on Excel. hitman007 Software 3 12th November 2012 04:13 PM
How To Push Live Data From Excel Sheet To Amibroker ?? ggshah Data Feeds 16 3rd August 2012 06:15 PM
Convert Excel RTDTo DDE or Import Live data from Excel barnzee AmiBroker 9 25th September 2009 04:35 PM
How Can I Convert Live Data From Indiabulls To Excel as156 Development of Software Utilities 0 4th August 2007 10:42 AM


All times are GMT +5.5. The time now is 03:12 AM.

Indemnity, Disclaimer & Disclosure Notice:
By visiting Traderji.com you automatically indicate that you agree to our Forum Rules, Indemnity, Disclaimer & Disclosure Notice and General Content Disclaimer Notice and indemnify Traderji.com, its associates and related parties of all claims howsoever resulting from the usage of the forum/site.
Disclaimer: Trading or investing in stocks & commodities is a high risk activity. Any action you choose to take in the markets is totally your own responsibility. You are recommended to make appropriate enquiries and seek appropriate advise before sending money, incurring any expenses, acting on recommendations or entering into any commitment in relation to any advertisement published here. Traderji.com does not vouch for any claims made by the advertisers of products and services. Traderji.com will not be held liable for any consequences in the event such claims are not honoured by the advertisers. Traderji.com will not be liable for any, direct or indirect, consequential or incidental damages or loss arising out of the use of any information by anybody mentioned anywhere on this site.
Disclosure: The information in this forum is neither an offer to sell nor solicitation to buy any of the securities mentioned herein. The writers may or may not be trading in the securities mentioned.
All names or products mentioned are trademarks or registered trademarks of their respective owners.
General Content Disclaimer Notice:
In light of our policy of encouraging candid, open exchanges of views and the rapid distribution of information originating from many sources, Traderji.com cannot determine the accuracy or legality of any information that may be uploaded to the forum. Opinions, advice and all other information expressed by participants in discussions are those of the author. You rely on such information at your own risk. You are urged to seek professional advice for specific, individual situations and not rely solely on advice or opinions given in the discussions. Since Traderji.com is an open and free discussion forum, any comments made by members of this forum in their posts reflect their own views and not of the owner or administrator of Traderji.com. Thus the owner/administrator indemnify themselves of all claims whatsoever and will not be liable or responsible for any members comments/views in this forum Traderji.com. Although we constantly delete all irrelevant content and/or SPAM, if you should find any objectionable or offensive posts made by members of this forum which you would like to bring to our notice for removal then please Contact Us.
 


Copyright © www.Traderji.com 2001 - , All rights reserved.

Recommended Websites - www.TradersEdgeIndia.com - www.TradingPicks.com - www.MasterOfTrading.com

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243