Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

HOW I CAN AUTOMATICALLY DOWNLOAD DATA FROM WEBSITE AND CONVERT

  Asked By: Sherry    Date: Sep 26    Category: MS Office    Views: 6140
  

I want to download some data from
NSEINDIA.COM and BSEINDIA .COM daily . FOLLOWING IS THE SEQUENCE FOR
DOWNLOADING AND CONVERTING DATA. WILL ANY BODY WILL HELP AND GUIDE ME.

step-1 - It should automatically go to www.NSEINDIA.COM > eQUITY >
MARKET TODAY > BHAVCOPY DOWNLOAD
> THERE ARE TWO BHAVCOPIES AVAILABLE FOR DOWNLOAD ONE IN *.DBF FORMAT
AND OTHER IS IN *.CSV FORMAT ,
WE HAVE TO DOWNLOAD BHAVCOPY IN *.CSV FORMAT
IF THERE IS NO BHAVCOPY IT SHOULD GIVE MESSAGE"NO BHAVCOPY FOR THE
DAY", IF THERE IS ONE FOR THE DAY IT SHOULD DOWNLOAD AND CONVERT THE
SAME IN THE TEXT FORMAT AND SAVE IT,
2) ON BSE WEBSITE AT WWW.BSEINDIA.COM THE DOWNLOADER SHOULD GO TO >
DAILY BHAVCOPY ON RIGHT HAND SIDE > DOWNLOAD
BHAVCOPY IN *.CSV FORMAT AND CONVERT THE SAME IN *.TEXT FORMAT.
THE HEADER SEQUENCE IN FILES SHOULD BE < TICKER > <DATE> <OPEN>
<HIGH> <LOW> <CLOSE> <VOLUME>

Share: 

 

3 Answers Found

 
Answer #1    Answered By: Daw Boonliang     Answered On: Sep 26


I think the first thing you can do is stop writing in all caps.

Have you tried googling on some relevant phrases, like "internet
explorer automation" ? I found this great link with sample code:

http://www.codeproject.com/KB/vb/kirangoka.aspx

Do you have any code written at all?

 
Answer #2    Answered By: Christie Bradley     Answered On: Sep 26

Will u help me to develop this downloader . I have no knowledge of coding ,
but I have intermediate knowledge of excel.

 
Answer #3    Answered By: Wendy Harrison     Answered On: Sep 26

I can provide you with sample code and advice on how to code the
application, but I can't write it for you. If you need some code to
solve a specific problem

 




Tagged: