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.
Go to Solution.
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
View solution in original post
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.
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?
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!