IM
Size: a a a
IM
dk
С
dk
С
С
С
let
api = "api.marketstack.com/v1/tickers",
key = "access_key=6c875baceba44d1191f036c0276bad11",
tickers = Json.Document(Web.Contents(api & "?" & key)),
latest = (symbol) => Json.Document(Web.Contents(api & "/" & symbol & "/intraday/latest?" & key))[last],
history = (symbol) => Json.Document(Web.Contents(api & "/" & symbol & "/eod/2021-01-21?" & key))[close],
t1 = Table.FromList(tickers[data],Splitter.SplitByNothing(), null, null, ExtraValues.Error),
t2 = Table.ExpandRecordColumn(t1, "Column1", {"name", "symbol"}),
addHistory = Table.AddColumn(t2, "2021-01-21", each history([symbol])),
addLatest = Table.AddColumn(addHistory, "latest", each latest([symbol])),
addChange = Table.AddColumn(addLatest, "change", each [latest]/[#"2021-01-21"]-1, Percentage.Type),
table = Table.RemoveRowsWithErrors(addChange)
in
table
ЕМ
А
ЕМ
А
SB
SB
С
ЕМ
ЕМ
dk
С
С
А