Capturing the P&L for the closed trade

[sat7134]

Hi All

The below code works as expeceted, whenever there is a buy or sell then the record gets successfully inserted in the DB.

    if order.status in [order.Completed]:
        if order.isbuy():
            # self.con.execute("insert into results(Symbol,Trade_Exe_Date,Trade_Type,Action,Price,Added_On) values(?,?,?,?,?,?)",
            #             (self.stock, str(self.datas[0].datetime.date(0)),"Enter Long", "Buy", order.executed.price,str(dt.datetime.today())))
            # self.con.commit()
            self.con.execute(
                "insert into results(Symbol,Trade_Exe_Date,Trade_Type,Action,Price,Added_On) values(?,?,?,?,?,?)",
                (self.stock, str(self.datas[0].datetime.date(0)), "Enter Long", "Buy",
                 round(order.executed.price,2), str(dt.datetime.today())))
            self.con.commit()

        elif order.issell():  # Sell
            self.con.execute(
                "insert into results(Symbol,Trade_Exe_Date,Trade_Type,Action,Price,Added_On) values(?,?,?,?,?,?)",
                (self.stock, str(self.datas[0].datetime.date(0)), "Enter Short", "Sell",
                 round(order.executed.price,2), str(dt.datetime.today())))
            self.con.commit()

But when I tried to update the P&L as below, the P&L for the last trade is getting updated for all the trades. I want the P&L to be attached to the closed trade that corresponds to the Opened trade. Can someone please help me how to achieve this?

def notify_trade(self, trade):
    if not trade.isclosed:
        return

    elif trade.isclosed:
    #self.con.execute("update results set Profit = ? where Symbol = ?",(trade.pnl, self.stock))
    #self.con.commit()