Total_data = pd.DataFrame({"ticker":[],
                        "cash": [],
                         "short_term_inv":[],
                         "receivables":[],
                          "inventories":[],
                          "total_current_assets":[],
                          "paybables": [],
                          "short_term_debt":[],
                          "total_current_liabilities":[],
                          "long_term_debt":[],
                          "total_debt":[],
                          "deferred_revenue":[],
                          "tax_liabilities":[],
                          "deposit_liabilities":[],
                          "total_non_current_liabilities":[],
                          "total_liabilities":[],
                          "market_low":[],
                          "Country":[],
                          "Industry":[],
                          "rob_number":[],
                          "delta": []})


i = 0
bar = progressbar.ProgressBar(maxval=len(stocks), \
widgets=[progressbar.Bar('=', '[', ']'), ' ', progressbar.Percentage()])
bar.start()
errors = ""
for stock in stocks:


    try:
        data = calculateRobNumber(pullStock(stock), stock)

        Total_data = Total_data.append({"ticker": stock,
                        "cash": data[0],
                         "short_term_inv":data[1],
                         "receivables":data[2],
                          "inventories":data[3],
                          "total_current_assets":data[4],
                          "paybables": data[5],
                          "short_term_debt":data[6],
                          "total_current_liabilities":data[7],
                          "long_term_debt":data[8],
                          "total_debt":data[9],
                          "deferred_revenue":data[10],
                          "tax_liabilities":data[11],
                          "deposit_liabilities":data[12],
                          "total_non_current_liabilities":data[13],
                          "total_liabilities":data[14],
                          "market_low":data[15],
                          "Country":data[16],
                          "Industry":data[17],
                          "rob_number":data[18],
                          "delta": data[19]
                                       },ignore_index=1)


    except Exception as e:
#         errors = errors + " " + stock
        print(e)

    bar.update(i+1)
    sleep(0.1)

    i+=1
bar.finish()
#export
Total_data.to_excel("Stock Data.xlsx", index=False)
print("Finished")
print("Errored on: " + errors)