read token from file


  • @admin @administrators @admin123 please help me regarding reading of multiple tokens of futres and options form file instead of manualy putting it in token list.

    manual token_list1 = [{"exchangeType": 2, "tokens": ["35003","42697","35015","60217","60221","60225","60229","60233","60237","60241","39967","60247","60218","60222","60226","60230","60234","60238","60242","39968","60248","47007","47011","47016","47027","47039","47043","47049","47056","47062","47008","47013","47017","47033","47040","47044","47050","47057","47063"]}]

    instead of token numbers , how to read token from any excel file cells like A1, A2 and so on .......
    wb_tokens = wb.sheets('tokens')
    f1=str(wb_tokens.range("B2").value)
    f2=str(wb_tokens.range("B3").value)
    f3=str(wb_tokens.range("B4").value)
    t1=str(wb_tokens.range("A2").value)
    file token_list1 = [{"exchangeType": 2, "tokens": [f1,f2,f3,t1,t2,t3,t4,t5,t6,t7,t8,t9,t10,t11,t12,t13,t14,t15,t16,t17,t18]}] but this is not working , please help