Forum Discussion
Yahoo Finance Power Query Link Not Working
(Symbol as text,min_date as text, max_date as text) as table =>
let
Source = Json.Document(Web.Contents("https://query2.finance.yahoo.com", [RelativePath = "/v8/finance/chart/" & Symbol & "?period1=" & min_date & "&period2=" & max_date & "&interval=1d&events=history&includeAdjustedClose=true"])),
// Extract the relevant parts of the JSON response
ChartData = Source[chart][result]{0},
Timestamps = ChartData[timestamp],
Quotes = ChartData[indicators][quote]{0},
// Convert the JSON into a table
CombinedData = Table.FromColumns({
List.Transform(Timestamps, each Text.From(_)),
Quotes[open],
Quotes[high],
Quotes[low],
Quotes[close],
Quotes[volume]
}, {"DateUnix", "Open", "High", "Low", "Close", "Volume"}),
#"Changed Type" = Table.TransformColumnTypes(CombinedData,{{"DateUnix", Int64.Type}}),
#"Added Custom" = Table.AddColumn(#"Changed Type", "Date.1", each DateTimeZone.SwitchZone(
#datetimezone(1970, 1, 1, 0, 0, 0, 0, 0) + #duration(0, 0, 0, [DateUnix] ),
2, 0
)),
#"Renamed Columns" = Table.RenameColumns(#"Added Custom",{{"Date.1", "Date"}}),
#"Removed Columns" = Table.RemoveColumns(#"Renamed Columns",{"DateUnix"})
in
#"Removed Columns"
this work