help required in importing data

S

santo

Member
#1
#1
Dear friends,
I want to import company results from nse into a.csv file(atleast 200 srips).How to automate this process?Please help...
thanx ..
santo...
 
V

venkat1926

Member
#2
#2
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
 
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
B Help required:Minimum Maximum scaling option of Amibroker AmiBroker 0
B Required help for Buy/Sell signal Supertrend Software 4
P Help required - How to retrieve intraday value at a specific time of a daily MA? Welcome 0
D AFL required - Please help. Algo & Automated Trading 0
P HELP REQUIRED FOR EDITING AFL Previous Day Range Breakout Day Trading 8

Similar threads