Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Create new column to get stock prices with API

Good morning all, Hope someone can help me. I need to create a new column that shows the price of a specific asset trough an API. API link is like this: https://api.binance.com/api/v3/ticker/price...
Tips and Tricks
  • lbendlin's avatar
    lbendlin
    1 year ago

    Something like this.  Note that access is restricted so you will need to provide authentication in the code.

     

     

    let
  Source = #table({"Coin"}, {{"BTC"}, {"ETH"}, {"SOL"}}), 
  #"Added Custom" = Table.AddColumn(
    Source, 
    "Data", 
    each Web.Contents(
      "https://api.binance.com/api/v3/ticker/price", 
      [Query = [symbols = [Coin] & "USDT"]]
    )
  )
in
  #"Added Custom"

     

lbendlin's avatar
lbendlin
Super User
1 year ago

Something like this.  Note that access is restricted so you will need to provide authentication in the code.

 

 

let
  Source = #table({"Coin"}, {{"BTC"}, {"ETH"}, {"SOL"}}), 
  #"Added Custom" = Table.AddColumn(
    Source, 
    "Data", 
    each Web.Contents(
      "https://api.binance.com/api/v3/ticker/price", 
      [Query = [symbols = [Coin] & "USDT"]]
    )
  )
in
  #"Added Custom"