Correct way of implementing daily PnL query? about python-binance HOT 6 CLOSED

    def get_last_trade_pnl_and_percentage(self):
        # Fetch the most recent trades for the futures account
        pnl_data = self.client.futures_account_trades(symbol=self.symbol, limit=100, recvWindow=60000)

        # Fetch the current available balance
        futures_balances = self.client.futures_account_balance(recvWindow=60000)
        futures_balance_df = pd.DataFrame(futures_balances)
        current_balance = round(float(futures_balance_df[futures_balance_df['asset'] == self.config.BASE_ASSET]['availableBalance'].values[0]), 2)

        total_pnl = 0
        total_pnl_percentage = 0

        if pnl_data:
            # Convert the trade data into a DataFrame
            df = pd.DataFrame(pnl_data)

            # Ensure the 'realizedPnl' column is treated as numeric for calculations
            df['realizedPnl'] = pd.to_numeric(df['realizedPnl'])

            if not df.empty:
                # Group trades by orderId and side
                grouped = df.groupby(['orderId', 'side'])

                # Get the last orderId
                last_order_id = df['orderId'].iloc[-1]

                for group_name, group in grouped:
                    order_id, side = group_name

                    # If it's the last origOrderId, sum the realizedPnl to get the total PnL of the last trade
                    if order_id == last_order_id:
                        last_trade_pnl = round(group['realizedPnl'].sum(), 2)
                        break  # Exit the loop after finding the last trade

                # Calculate the balance before the last trade
                balance_before_last_trade = current_balance - total_pnl - last_trade_pnl

                # Calculate PnL percentage based on the balance before the last trade
                if balance_before_last_trade != 0:
                    last_trade_pnl_percentage = round((last_trade_pnl / balance_before_last_trade) * 100, 2)

        # Return the PnL of the last trade, its percentage, and the current balance
        return last_trade_pnl, last_trade_pnl_percentage, current_balance