date range web query help

[baltibeginner]

Hello - I am looking to query the IPO data from here (https://www.nasdaq.com/markets/ipos/activity.aspx?tab=pricings&month=2018-01) I can pull individual dates, but I can't figure out how to iterate and take the data from multiple months and years. I've seen some examples, but can't seem to figure it out.

Thank you.

[v-qiuyu-msft]

Hi @baltibeginner,

Based on my test, you can refer to below steps:
1.Get data from web and use the advanced function, divide your URL into two paragraphs like the picture below.

   

2.Choose the Table 0 and click the edit.

3.Open the Advanced Editor and insert the "(para as text) as table =>" before the word "let" and use the "para" to replace the "2018-01" like the  picture below.

4.Click "done" you can get a function window. When you enter the different date, you can get the result links with the data.

Best Regards,
Qiuyun Yu 

[baltibeginner]

Thank you @v-qiuyu-msft. This was very helpful. Instead of inputting each date. Am I able to pull a range of dates at once?

[v-qiuyu-msft · Accepted solution]

Hi @baltibeginner,

You can create a new table via Enter Data: 

Then Invoke Custom Function, add a new column. Click on highlighted button can expand rows: 

Best Regards,
Qiuyun Yu