Home > Forum Home > Analyzing Corporate Financial Data > Business Data, Analysis and Niche Generation Share

Business Data, Analysis and Niche Generation

Excel Help for Business Data, Analysis And Niche Generation in Analyzing Corporate Financial Data


Forum TopicPost Reply Login

Business Data, Analysis And Niche Generation

Rate this:
(3/5 from 1 vote)
ConfusedHey guys,

Just a quick question seeing as you guys seem to be quite knowledgeable in this area.  I recently found a pretty useful Niche Generator and business data site at http://findabusiness.org. I was just wondering, the owners said they are going to be putting up a lot of demographic data and income data. How would you suggest I scrape into an excel file?

 Kind Regards, 
 John
 Posted by on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most Recent | Chronological | Highest Rated
Fedup
Rate this:
(3/5 from 1 vote)
The site simply uses Google and Yahoo APIs to return business information based on key words and location.

To scrape the results to Excel, you can use a web query.  Construct the URL and pass it to a web query.  For excample the URL structure for the key words "Microsoft Excel" in New York is http://findabusiness.org/search.php?business=microsoft+excel&location=new+york.

To load the web query with the key words and location from Excel cells as well as extracting a section of the page, record a macro when running the web query and modify accordingly along the same lines as the VBA in this post.

 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Excel templates and solutions matched for Business Data, Analysis and Niche Generation:

Solutions: OLAP Reporting Advanced Data Reporting Data Envelope Analysis