I need data of 389 companies downloaded on a daily basis in excel files on my folder. I also require historical data pulled for these companies for as long as history is available. In my opinion you have to write two macros in excel . One which pulls historical data... Data is pulled for each company individually. So basically , you can work on one company name and I believe rest all can follow suit for historical data. The second one is something peculiar. Data comes at 6 pm (IST) on NSE website. So it would be great if automatically a program runs at that time which would copy paste these data directly into the raw data sheet of each company created through the first program. We can discuss the level of automation that can be achieved.
Skills & Expertise RequiredWeb Scraping
Project closed for bidding!
Share this project with your friends