index route, pset7 Finance

@app.route("/")
@login_required
def index():
    users_info = db.execute("SELECT * FROM users WHERE id=:uid", uid=session["user_id"])
    transactions_info = db.execute("SELECT * FROM user_stocks WHERE user_id=:uid GROUP BY stock_symbol ORDER BY id", uid=session["user_id"])
    grand_total = 0
    total_price = []
    for i in range(len(users_info)):
        grand_total = users_info[i]["cash"]
    no_of_shares_dict = {}
    current_price_dict = {}
    stock_names_dict = {}
    if len(transactions_info) != 0:
        for i in range(len(transactions_info)):
            for j in range(len(users_info)):
                cash = users_info[j]["cash"]

        total_shares = 0
        for i in range(len(transactions_info)):
            if transactions_info[i]["stock_symbol"] not in no_of_shares_dict:
                for j in range(i, len(transactions_info)):
                    if transactions_info[i]["stock_symbol"] == transactions_info[j]["stock_symbol"]:
                        total_shares += transactions_info[j]["no_of_shares"]
                no_of_shares_dict.update({
                    transactions_info[i]["stock_symbol"]: total_shares
                })
                total_shares = 0

        for key in no_of_shares_dict:
            current_price_dict.update({
                key: lookup(key)["price"]
            })

        for key in no_of_shares_dict:
            stock_names_dict.update({
                key: lookup(key)["name"]
            })

        for key in no_of_shares_dict:
            total_price.append(lookup(key)["price"] * no_of_shares_dict.get(key))

        for i in range(len(total_price)):
            grand_total += total_price[i]

    return render_template("index.html", users_info=users_info, current_price_dict=current_price_dict, grand_total=grand_total,
    no_of_shares_dict=no_of_shares_dict, stock_names_dict=stock_names_dict, total_price=total_price)