|
|
| Discuss EOD Price for Selected scripts in excel sheet at the Software 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 ... |
|
|||||||
| Notices |
| Software Charting, trading & technical analysis software, trading system development and backtesting. |
 |
|
|
Thread Tools |
| Sponsored Links |
|
#1
28th November 2007, 07:54 PM
|
|||
|
|||
EOD Price for Selected scripts in excel sheet
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 am attaching my present data sheet whih i am using to update the prices for reference Thanks 
|
|
#2
30th November 2007, 10:29 AM
|
|||
|
|||
|
Re: EOD Price for Selected scripts in excel sheet
I have got the solution
Cheers
|
|
#4
1st December 2007, 10:47 AM
|
|||
|
|||
|
Re: EOD Price for Selected scripts in excel sheet
Hi
In the cell that you want the prices Go import external data-web query and give the following query http://download.finance.*****.com/d/...i-flex.ns&f=l1 Change the name of the script for every script u want in the new cell The above example is for I-flex The script code has to be as per ***** code Bye
|
| Sponsored Links |
|
|
|
| Bookmarks |
| Thread Tools | |
|
|
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.
