title: Binance Websocket Price Checking To Excel
body: <p>I have a code that works to bring me live coin prices but I need to have the prices in excel live as well. I tried pandas to read and stream prices to excel and I failed. Do you have any suggestions to do that?</p>
  <pre><code>import json, pandas, websocket, socket, binance
  import websockets
  import xlwings
  socket = 'wss://stream.binance.com:9443/ws/!bookTicker'
  def on_message(ws, message):
      json_message=json.loads(message)
      print(json_message['s'])
      print(json_message['a'])
      print(json_message['b'])
  def on_close(ws):
      print('closed')
  ws = websocket.WebSocketApp(socket, on_message=on_message, on_close=on_close)
  ws.run_forever()
  </code></pre>