Power Query URL Change

[msarfaraz]

let
Source = Csv.Document(Web.Contents("https://query1.finance.yahoo.com/v7/finance/download/" & "BTC-USD" & "?period1=1581415348&period2=1613037748&interval=1d&events=history&includeAdjustedClose=true"),[Delimiter=",", Columns=7, Encoding=1252, QuoteStyle=QuoteStyle.None]),
#"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Date", type date}, {"Open", type number}, {"High", type number}, {"Low", type number}, {"Close", type number}, {"Adj Close", type number}, {"Volume", Int64.Type}})
in
#"Changed Type"



How I can change the above query instead of "BTC-USD" I want a column (Text field) to pick the dynamically.

 

[JustynaMK]

Can you paste your Power Query for me at that stage?
Something's not right with your URL, it is literally parsing word "ticker" instead of the entries of column "Ticker".
Also, paste the Power Query for your formula query as it might be constructed incorrectly (although I doubt it, since you already tested it for a smaller sample and it was all working fine).

 

[msarfaraz]

(Ticker as text) as table =>

let
Source = Csv.Document(Web.Contents("https://query1.finance.yahoo.com/v7/finance/download/" & "Ticker" & "?period1=1581415348&period2=1613037748&interval=1d&events=history&includeAdjustedClose=true"),[Delimiter=",", Columns=7, Encoding=1252, QuoteStyle=QuoteStyle.None]),
#"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Date", type date}, {"Open", type number}, {"High", type number}, {"Low", type number}, {"Close", type number}, {"Adj Close", type number}, {"Volume", Int64.Type}})
in
#"Changed Type"

 

[JustynaMK]

Can you remove double quote around Ticker? I.e.

Source = Csv.Document(Web.Contents("https://query1.finance.yahoo.com/v7/finance/download/" & Ticker & "?

instead of

Source = Csv.Document(Web.Contents("https://query1.finance.yahoo.com/v7/finance/download/" & "Ticker" & "?

 

[msarfaraz]

Can you remove double quote around Ticker? I.e.

Source = Csv.Document(Web.Contents("https://query1.finance.yahoo.com/v7/finance/download/" & Ticker & "?

instead of

Source = Csv.Document(Web.Contents("https://query1.finance.yahoo.com/v7/finance/download/" & "Ticker" & "?

Amazing, its work... Thank you so much

 

[JustynaMK]

You're most welcome take care.