Forum Discussion
Alex_Ooi
Helper IV
Helper IVWeb scraping to show all rows in Power Query
Hi all, I have a task of scraping the composite index historical available in Yahoo Finance. Let's take an example of NASDAQ (^IXIC) with the following URL: https://finance.yahoo.com/quote/%5EIXI...
Hi Alex, notice the download link on the right!
= Csv.Document(Web.Contents("https://query1.finance.yahoo.com/v7/finance/download/%5EIXIC?period1=1570147200&period2=1601769600&interval=1d&events=history"),[Delimiter=",", Columns=7, Encoding=1252, QuoteStyle=QuoteStyle.None])
Give the above a shot and that should pull everything in!
Hi, what if the page number is hidden in the metadata, for example: https://dailymed.nlm.nih.gov/dailymed/services/v2/ndcs
, this will only give me the first 100 records... any thoughts?