|
| Discuss help required in importing data at the Fundamental Analysis within the Traderji.com - Discussion forum for Stocks Commodities & Forex; Dear friends, I want to import company results from nse into a.csv file(atleast ... |
|
|||||||
| Register | Blogs | FAQ | Chat Room [4] | Search | Today's Posts | Mark Forums Read |
| Fundamental Analysis Discuss all about fundamental analysis and valuation. The world of PEs, free cash flow, ratio analysis, multiples and accounting numbers. |
|
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. |
 |
|
|
Thread Tools |
|
#2
24th June 2007, 03:14 PM
|
|||
|
|||
Re: help required in importing data
ths may be not elegant solution but try this
park this macro in personal.xls file open an excel spread sheet run the macro from personal.xls. you have to input the name of the scrip. in the saving folder modify to suit you. the macro is Code:
Sub announcements()
Dim scrip As String
Application.DisplayAlerts = False
scrip = InputBox("type nse code of the scrip")
With ActiveSheet.QueryTables.Add(Connection:= _
"URL;http://nseindia.com/marketinfo/companyinfo/eod/announcements.jsp?symbol=" & scrip _
, Destination:=Range("A1"))
.Name = "announcements.jsp?symbol=cipla"
.Refresh BackgroundQuery:=False
End With
ActiveWorkbook.SaveAs Filename:= _
"C:\Documents and Settings\VENKAT\My Documents\" & scrip & " announcements.csv", _
FileFormat:=xlCSV, CreateBackup:=False
Application.DisplayAlerts = True
End Sub
|
|
| Thread Tools | |
|
|
Similar Threads for: help required in importing data
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Importing data into FC Charts | roneeth | Software | 6 | 1st December 2007 11:20 PM |
| Importing Data into Spacejock Fcharts. | shrees | Data Feeds | 88 | 27th November 2007 02:15 AM |
| importing intraday data not working | alexonias | Data Feeds | 3 | 23rd September 2007 02:40 PM |
| importing intraday data to amibroker | alexonias | Data Feeds | 30 | 8th September 2007 09:21 AM |
| Importing NSE Real time Data into Excel | sunil saranjame | Data Feeds | 2 | 26th May 2007 06:23 PM |
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.
