|
|
| Discuss REQUEST : pib market watch to excel importing at the Software within the Traderji.com - Discussion forum for Stocks Commodities & Forex; Hi friends, can anyone please help me how can i continuously import data from pib ... |
|
|||||||
| Notices |
| Software Charting, trading & technical analysis software, trading system development and backtesting. |
 |
|
|
Thread Tools |
| Sponsored Links |
|
#1
28th September 2007, 12:37 AM
|
|||
|
|||
REQUEST : pib market watch to excel importing
Hi friends,
can anyone please help me how can i continuously import data from pib market watch to excel sheet . It doesnt matter even if excel data is over written by pib latest data while importing. please help me . 
|
| Sponsored Links |
|
#2
28th September 2007, 01:39 AM
|
|||
|
|||
|
Re: REQUEST : pib market watch to excel importing
Quote:
Thats very easy indeed. Send me mail on ****@***.com Choose from, credit card / paypal / wire transfer Send me Rs.****/- only I'll tell you the solution.  OR Open Excel, go to Data>Import External Data>New database query> give there path for your csv files of PIB data . i.e. your PIB data folder. say Add Double click on <New Data Source> Fill following Info 1> PIB 2> Select first option for csv & txt 3> connect>options>csv>ok 4> no need to fill say OK Now PIB should be their in the list say OK Query Wizard will open On left, there will be file names of the scrips. click on + of a file. add every item to right. click Next>next>Next>finish click ok Data will be there Whenever want to refresh, go to Data>refresh or make macro for that. Omkar 
Last edited by omkarmango; 28th September 2007 at 01:49 AM.
|
|
#3
28th September 2007, 10:07 AM
|
|||
|
|||
|
Re: REQUEST : pib market watch to excel importing
Hi omkar ,
Thanks a lot for giving me valuable information. this is knowledge update to me . But actually i didnt me that .(excuse me if i couldn't express in right way) My problem is when we open pib and our maket watch in pib . we press ctrl+s to export data in csv format , i want to export data to csv file( in data folder) from pib market watch continously . everytime i press ctrl+s to export which should be avoided . Please suggest me some method or any utlity which do this . Thanks
|
|
#4
28th September 2007, 11:05 AM
|
|||
|
|||
|
Re: REQUEST : pib market watch to excel importing
hhhmm, pib is dde enabled, it would be much better if one uses the same. the problem is i dont know the link items. it will go like this; =PROGMAN|PROGMAN!(missing input) search the net to find the missing inputs or send a mail to helpdesk, for the link items. and ofcourse if you get to know do let me know
|
| 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.
