Importing EOD Data in Excel sheet for selected scripts

Discuss Importing EOD Data in Excel sheet for selected scripts at the Data Feeds within the Traderji.com - Discussion forum for Stocks Commodities & Forex; Hi I keep track of about 100 Scripts. I want to import the EOD prices ...


Go Back   Traderji.com - Discussion forum for Stocks Commodities & Forex > TOOLS & RESOURCES > Data Feeds
Register Blogs FAQ Chat Room Search Today's Posts Mark Forums Read

Data Feeds Real time and end-of-day data feeds.


Welcome to the Traderji.com - Discussion forum for Stocks Commodities & Forex.

You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features.

By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features.

Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please read the FAQ.

Reply
 
Thread Tools
Sponsored Links
  #1  
Old 29th November 2007, 10:55 AM
Member
 
Join Date: Mar 2006
Posts: 13
shravank30 is on a distinguished road
Default Importing EOD Data in Excel sheet for selected scripts



Hi

I keep track of about 100 Scripts.
I want to import the EOD prices for my selected 100 companies in my excel sheet every evening from BSE/NSE.
I shall be grateful if the members can recommend a method to do the same
I am presently doing it using the Web data query function of Excel and then giving the link to the ***** finance site but for the past few days i am getting an error message saying that it is an invalid web query for most of the scripts.
I do now want any fancy analysis or historical data, just plain simple closing prices for my scripts.
I shall be grateful if the members can suggest a method for doing the same in Excel
Thanks

Reply With Quote
  #2  
Old 30th November 2007, 10:27 AM
Member
 
Join Date: Mar 2006
Posts: 13
shravank30 is on a distinguished road
Default Re: Importing EOD Data in Excel sheet for selected scripts

I have got the solution

Cheers

Reply With Quote
  #3  
Old 30th November 2007, 11:33 AM
Member
 
Join Date: Nov 2007
Posts: 2
onlyruchi is on a distinguished road
Default Re: Importing EOD Data in Excel sheet for selected scripts

Hi.. If we want to get the real time data from BSE and NSE, then how it is possible? Because only brokers terminal have the rights to access it, so how to get the data from brokers terminal into our excel sheet?

Reply With Quote
  #4  
Old 30th November 2007, 12:13 PM
Member
 
Join Date: Mar 2006
Posts: 13
shravank30 is on a distinguished road
Default Re: Importing EOD Data in Excel sheet for selected scripts

In indiabulls, the data for all the scripts you have in your market watch is written in excel sheet in your portfolio folder
If you acess that folder you can see the prices for the scripts you are interested

Cheers

Reply With Quote
Sponsored Links


Reply


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

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



All times are GMT +5.5. The time now is 09:47 AM.

Indemnity, Disclaimer & Disclosure Notice:
• By visiting Traderji.com you indicate your acceptance of our Forum Rules Disclaimer & Disclosure and indemnify Traderji.com, its associates and related parties of all claims howsoever resulting from the usage of the forum.
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. Traderji.com will not be liable for any, direct or indirect, consequential or incidental damages or loss arising out of the use of this information.
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 of 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. If you 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 © 2001 - 2008, Traderji.com All Rights Reserved.

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