Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- let
- Parameter = Excel.CurrentWorkbook(){[Name="Table3"]}[Content],
- URL= Parameter{1}[Value],
- Source = Web.Page(Web.Contents(URL)),
- Data0 = Source{0}[Data],
- #"Changed Type" = Table.TransformColumnTypes(Data0,{{"Date", type date}, {"Open", type number}, {"High", type number}, {"Low", type number}, {"Close", type number}, {"Volume", type number}, {"Market Cap", type number}}),
- #"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"Market Cap", "Open", "High", "Low"}),
- #"Sorted Rows" = Table.Sort(#"Removed Columns",{{"Date", Order.Ascending}})
- in
- #"Sorted Rows"
Add Comment
Please, Sign In to add comment