http://www.nasdaq.com/markets/ipos/activity.aspx?tab=upcomingunder each of the company name is a html link to another page. How do I import that html link into Google sheets?
Google sheets, how to grab a html link from a table
google spreadsheets
You can pull in those links with this formula:=IMPORTXML(http://www.nasdaq.com/markets/ipos/activity.aspx?tab=upcoming,//tr/td[1]/a/@href)