PDA

View Full Version : How to get data from jsp web page to excel


vikasgupta7
Aug 20, 2010, 10:37 PM
Hi,

I want to download daily Stock market data from website "http://etintelligence.com/etig/researchchannels/markets/bsestockquotes.jsp" into excel. My problem is that I will have to click each alphabet on this page to get data for all stock starting with that alphabet. Which means I will have to click each of the alphabets (28 clicks) and copy paste data manually to excel.

Now is there a possibility to download all the data in one go ( one click) using some software. Excel imports data for only the face page, since the page is java enabled and uses getdata utility to bring in data for other alphabets.

Can anyone help me please??


Regards Vikas

morgaine300
Aug 21, 2010, 08:54 PM
I've moved this to a more appropriate place. Despite that it's related to stock, the question is about the website and Excel, not about a finance issue.

Jakes12345
Mar 16, 2011, 12:38 AM
Importing data to your excel sheet is not a big issue while you are using some software to import it like market data excel (http://www.livevol.com/options-excel.html), which can let your all market data from your JSP page to your desired excel sheet within a one go. I have been using this software since a long time and find great reliable when I want to transfer data form my java page to excel sheet.You can try this.