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 time range. Is there a way to change this? How do I adjust this selection to 1 year, 3 years, or 10 years? 

 

The M code below is where I believe the answer to my question is. I just don't know how to edit it so that it changes the date selection.

 

let
Source = Web.Page(Web.Contents("https://www.investing.com/rates-bonds/chile-10-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"

 

Thank you for any help on this!

Power Query

2 Replies

  • 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 ?