Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

How to increase data selection from website by date

Does anyone know how to increase the date selection when pulling data from a website? I am trying to pull bond yield data from the following link to power query. But the default is set to a 1 month t...
Power Query
v-danhe-msft's avatar
v-danhe-msft
Microsoft Employee
7 years ago

Hi Anonymous,

Based on my test, you could refer to below code in advanced editor:

(para as text) as table =>
let
Source = Web.Page(Web.Contents("https://www.investing.com/rates-bonds/chile-"&para&"-year-bond-yield-historical-data")),
Data0 = Source{0}[Data],
#"Changed Type" = Table.TransformColumnTypes(Data0,{{"Date", type date}, {"Price", type number}, {"Open", type number}, {"High", type number}, {"Low", type number}, {"Change %", Percentage.Type}})
in
#"Changed Type"

And click the “Done”, you are able to enter the parameter to change different source:

After enter the “10” number:

You could also download the pbix file to have a view.

 

Regards,

Daniel He

 

 

vicentetic's avatar
vicentetic
Frequent Visitor
2 years ago

It's very interesting and it works but I think that the original author refers to change the values of the date box inside because the number "10" is part of the name and doesn't change. This is the place I'm talking about:

In this box you can change the date and extend the period. For example, can you do it for a period from 1/1/2020 - today ?