Guest User

Untitled

a guest
May 24th, 2018
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.59 KB | None | 0 0
  1. let
  2. Parameter = Excel.CurrentWorkbook(){[Name="Table3"]}[Content],
  3. URL= Parameter{1}[Value],
  4. Source = Web.Page(Web.Contents(URL)),
  5. Data0 = Source{0}[Data],
  6. #"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}}),
  7. #"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"Market Cap", "Open", "High", "Low"}),
  8. #"Sorted Rows" = Table.Sort(#"Removed Columns",{{"Date", Order.Ascending}})
  9. in
  10. #"Sorted Rows"
Add Comment
Please, Sign In to add comment