Source code for tradeexecutor.strategy.alpha_model

"""Alpha model and portfolio construction model related logic."""
import datetime
import heapq
import logging
from _decimal import Decimal

from dataclasses import dataclass, field
from io import StringIO
from types import NoneType
from typing import Optional, Dict, Iterable, List

import pandas as pd
import numpy as np
from dataclasses_json import dataclass_json
from tradingstrategy.types import PrimaryKey

from tradeexecutor.state.identifier import TradingPairIdentifier
from tradeexecutor.state.portfolio import Portfolio
from tradeexecutor.state.trade import TradeExecution, TradeType
from tradeexecutor.state.types import PairInternalId, USDollarAmount, Percent, LeverageMultiplier

from tradeexecutor.strategy.pandas_trader.position_manager import PositionManager
from tradeexecutor.strategy.weighting import weight_by_1_slash_n, check_normalised_weights, normalise_weights, Signal

logger = logging.getLogger(__name__)


#: Use in-process running counter id to debug signal
_signal_id_counter = 0

def _get_next_id():
    global _signal_id_counter
    _signal_id_counter += 1
    return _signal_id_counter


[docs]@dataclass_json @dataclass(slots=True) class TradingPairSignal: """Present one asset in alpha model weighting. - The life cycle of the instance is one strategy cycle and it is part of :py:class:`AlphaModel` - Asset is represented as a trading pair, as that is how we internally present assets - We capture all the calculations and intermediate values for a single asset in one instance (row) per each trading strategy cycle, making investigations for alpha model strategies easy - Required variables (pair, signal) are =input from `decide_trades()` function in a strategy - Optional variables are calculated and filled in the various phases of alpha model processing, as the model moves from abstract weightings to actual trade execution and dollar amounts - When we need to close old positions, we automatically generate :py:attr:`old_weight` and negative :py:attr:`position_adjust` for them - Data here is serialisable for visualisation a a part of the strategy state visualisation and also for console logging diagnostics """ #: For which pair is this alpha weight. #: #: Always the spot pair, the determines the asset price. #: For lending protocol leveraged trading this is the underlying trading pair. #: #: See also :py:attr`leveraged_pair`. #: pair: TradingPairIdentifier #: Raw signal. #: #: E.g. raw value of the momentum. #: #: Negative signal indicates short. #: #: Can be any number between ]-inf, inf[ #: #: Set zero for pairs that are discarded, e.g. due to risk assessment. #: signal: Signal #: Running counter signal ids #: #: - Useful for internal debugging onyl #: - Signal ids are not stable - only for single process debugging #: signal_id: int = field(default_factory=_get_next_id) #: Stop loss for this position. #: #: Used for the risk management. #: #: 0.98 means 2% stop loss over mid price at open. #: #: Set to `None` to disable stop loss. stop_loss: Optional[Percent] = None #: Take profit for this position #: #: Used for the risk management. #: #: 1.02 means 2% take profit over mid price at open. #: #: Set to `None` to disable stop loss. take_profit: Optional[Percent] = None #: Trailing stop loss for this position #: #: See :py:attr:`tradeexecutor.state.position.TradingPosition.trailing_stop_loss_pct` for details. #: trailing_stop_loss: Optional[Percent] = None #: Raw portfolio weight #: #: Represents USD allocated to this position. #: #: Each raw signal is assigned to a weight based on some methodology, #: e.g. 1/N where the highest signal gets 50% of portfolio weight. #: #: Negative signals have positive weight. #: raw_weight: Percent = 0.0 #: Weight 0...1 so that all portfolio weights sum to 1 #: #: Represents USD allocated to this position. #: #: Negative signals have positive weight. #: normalised_weight: Percent = 0.0 #: Old weight of this pair from the previous cycle. #: #: If this asset was part of the portfolio at previous :term:`strategy cycle` #: then this is the value of the previous cycle weight. #: The old weight is always normalised. #: #: This can be dynamically calculated from the :py:class:`tradeexecutor.state.portfolio.Portfolio` state. old_weight: Percent = 0.0 #: Old US Dollar value of this value from the previous cycle. #: #: If this asset was part of the portfolio at previous :term:`strategy cycle` #: then this is the value of the previous cycle weight. #: old_value: USDollarAmount = 0.0 #: Which trading pair this signal was using before. #: #: Allows us to switch between spot, leveraged long, leveraged short. #: old_pair: TradingPairIdentifier | None = None #: How many dollars we plan to invest on trading pair. #: #: Calculated by portfolio total investment equity * normalised weight * price. position_target: USDollarAmount = 0.0 #: How much we are going to increase/decrease the position on this strategy cycle. #: #: Used when the position increases and we need to know how #: many dollars we need to spend to buy more. #: #: If this is a positive, then we need to make a buy trade for this amount to #: reach out target position for this cycle. If negative then we need #: to decrease our position. #: position_adjust_usd: USDollarAmount = 0.0 #: How much we are going to increase/decrease the position on this strategy cycle. #: #: Used when the position decreases and we need to know #: how many units of asset we need to sell to get to the :py:attr:`position_target`. #: #: At the momeny always negative and available only when decreasing a position. #: #: Note that this value is not used when closing position (weight=0), #: due to rounding and epsilon errors. #: position_adjust_quantity: float = 0.0 #: Trading position that is controlled by this signal. #: #: Query with :py:meth:`tradeexecutor.state.portfolio.Portfolio.get_position_by_id` #: #: After open, any position will live until it is fully closed. #: After that a new position will be opened. position_id: Optional[PrimaryKey] = None #: No rebalancing trades was executed for this position adjust. #: #: This is because the resulting trade is under the minimum trade threshold. position_adjust_ignored: bool = False #: What was the profit of the position of this signal. #: #: Record the historical profit as the part of the signal model. #: Makes building alpha model visualisation easier later, #: so that we can show the profitability of the position of the signal. #: #: Calculate the position profit before any trades were executed. profit_before_trades: USDollarAmount = 0 #: What was the profit of the position of this signal. #: #: Record the historical profit as the part of the signal model. #: Makes building alpha model visualisation easier later, #: so that we can show the profitability of the position of the signal. #: #: Calculate the position profit before any trades were executed. profit_before_trades_pct: Percent = 0 #: For leveraged and spot positions, the pair we use to construct the position. #: #: This is the leveraged pair derived from :py:attr:`pair`. #: Can be leveraged long, leveraged shor or directly the underlying #: spot pair. #: #: This information is not available until the trades have been calculated #: in :py:meth:`AlphaModel.generate_rebalance_trades_and_triggers`. #: #: For spot pairs, this is the pair itself. #: synthetic_pair: TradingPairIdentifier | None = None #: How much leverage we dare to take with this signal #: #: Unset for spot. #: leverage: LeverageMultiplier | None = None def __post_init__(self): assert isinstance(self.pair, TradingPairIdentifier) if type(self.signal) != float: # Convert from numpy.float64 self.signal = float(self.signal) assert self.pair.is_spot(), "Signals must be identified by their spot pairs" if self.leverage: assert type(self.leverage) == float assert self.leverage > 0 def __repr__(self): return f"Signal #{self.signal_id} pair:{self.pair.get_ticker()} old weight:{self.old_weight:.4f} old value:{self.old_value:,} raw signal:{self.signal:.4f} normalised weight:{self.normalised_weight:.4f} new value:{self.position_target:,} adjust:{self.position_adjust_usd:,}"
[docs] def has_trades(self) -> bool: """Did/should this signal cause any trades to be executed. - We have trades if we need to rebalance (old weight != new weight) - Even if the weight does not change we might still rebalance because the prices change - Some adjustments might be too small and then we just ignore any trades and have :py:attr:position_adjust_ignored` flag set """ return (self.normalised_weight or self.old_weight) and not self.position_adjust_ignored
[docs] def is_short(self) -> bool: """Is the underlying trading activity for this signal to short the asset. See also py:attr:`leveraged_pair`. """ assert self.synthetic_pair, "Trades have not been generated yet" if not self.synthetic_pair: return False return self.synthetic_pair.is_short()
[docs] def is_spot(self) -> bool: """Is the underlying trading activity for this signal buy spot asset. See also py:attr:`is_short`. """ assert self.synthetic_pair, "Trades have not been generated yet" return self.synthetic_pair.is_spot()
[docs] def is_new(self) -> bool: """The asset did not have any trades (long/short) open on the previous cycle.""" return self.old_weight == 0
def is_closing(self) -> bool: return self.normalised_weight == 0
[docs] def is_flipping(self) -> bool: """On this cycle, are we flipping between long and short. - Closing the position to zero does not count as flipping - If there was no signal on the previous signal, it's not flipping either :return: True if the pair is going to flip """ if self.normalised_weight == 0: return False if self.old_pair is None: return False if self.signal < 0: return self.old_pair.is_long() or self.old_pair.is_spot() elif self.signal > 0: return self.old_pair.is_short() else: return False
[docs] def get_flip_label(self) -> str: """Get flip label""" if self.old_pair is None: if self.signal > 0: return "none -> spot" elif self.signal < 0: return "none -> short" elif self.signal == 0: return "spot -> close" else: return "no flip" elif self.old_pair.is_spot(): if self.signal < 0: return "spot -> short" elif self.signal == 0: return "spot -> close" else: return "no flip" elif self.old_pair.is_short(): if self.signal > 0: return "short -> spot" elif self.signal == 0: return "short -> close" else: return "no flip" else: raise AssertionError(f"Unsupported")
[docs]@dataclass_json @dataclass(slots=True) class AlphaModel: """Capture alpha model state for one strategy cycle. - A helper class for portfolio construction models and such - Converts portfolio weightings to rebalancing trades - Supports stop loss and passing through other trade execution parameters - Each :term:`strategy cycle` creates its own :py:class:`AlphaModel` instance in `decide_trades()` function of the strategy - Stores the intermediate results of the calculationsn between raw weights and the final investment amount - We are serializable as JSON, so we can pass the calculations as data around in :py:attr:`tradeexecutor.state.visualisation.Visualisation.calculations` and then later visualise alph model progress over time with other analytic diagrams """ #: Timestamp of the strategy cycle for which this alpha model was calculated #: timestamp: Optional[datetime.datetime] = None #: Calculated signals for all trading pairs. #: #: Pair internal id -> trading signal data. #: #: For all trading pairs in the model. #: #: Set by :py:meth:`set_signal` #: raw_signals: Dict[PairInternalId, TradingPairSignal] = field(default_factory=dict) #: The chosen top signals. #: #: Pair internal id -> trading signal data. #: #: For signals chosen for the rebalance, e.g. top 5 long signals. #: #: #: Set by :py:meth:`select_top_signals` #: signals: Dict[PairInternalId, TradingPairSignal] = field(default_factory=dict) #: How much we can afford to invest on this cycle investable_equity: Optional[USDollarAmount] = 0.0 #: Determine the lower threshold for a position weight. #: #: Clean up "dust" by explicitly closing positions if they fall too small. #: #: If position weight is less than 0.5% always close it close_position_weight_epsilon: Percent = 0.005 #: Allow set_signal() to override stop loss set for the position earlier #: override_stop_loss = False def __post_init__(self): if self.timestamp is not None: if isinstance(self.timestamp, pd.Timestamp): # need to make serializable self.timestamp = self.timestamp.to_pydatetime() assert isinstance(self.timestamp, datetime.datetime)
[docs] def iterate_signals(self) -> Iterable[TradingPairSignal]: """Iterate over all recorded signals.""" yield from self.signals.values()
[docs] def get_signal_by_pair_id(self, pair_id: PairInternalId) -> Optional[TradingPairSignal]: """Get a trading pair signal instance for one pair. Use integer id lookup. """ return self.signals.get(pair_id)
[docs] def get_signal_by_pair(self, pair: TradingPairIdentifier) -> Optional[TradingPairSignal]: """Get a trading pair signal instance for one pair. Use verbose :py:class:`TradingPairIdentifier` lookup. """ return self.get_signal_by_pair_id(pair.internal_id)
[docs] def get_signals_sorted_by_weight(self) -> Iterable[TradingPairSignal]: """Get the signals sorted by the weight. Return the highest weight first. """ return sorted(self.signals.values(), key=lambda s: s.raw_weight, reverse=True)
[docs] def get_debug_print(self) -> str: """Present the alpha model in a format suitable for the console.""" buf = StringIO() print(f"Alpha model for {self.timestamp}, for USD {self.investable_equity:,} investments", file=buf) for idx, signal in enumerate(self.get_signals_sorted_by_weight(), start=1): print(f" Signal #{idx} {signal}", file=buf) return buf.getvalue()
[docs] def set_signal( self, pair: TradingPairIdentifier, alpha: float | np.float32, stop_loss: Percent | NoneType = None, take_profit: Percent | NoneType = None, trailing_stop_loss: Percent | NoneType = None, leverage: LeverageMultiplier | NoneType = None, ): """Set trading pair alpha to a value. If called repeatatle for the same trading pair, remember the last value. :param pair: Trading pair. Always the underlying spot pair. :param alpha: How much alpha signal this trading pair carries. Set to zero to have the pair excluded out after a risk assessment :param stop_loss: Stop loss threshold for this pair. As the percentage of the position value. `0.98` means 2% stop loss. :param take_profit: Stop loss threshold for this pair. As the percentage of the position value. `1.02` means 2% take profit. :param trailing_stop_loss: Trailing stop loss threshold for this pair. As the percentage of the position value. `0.98` means 2% trailing stop loss. :param leverage: Position leverage. Must be set for short and leveraged long. If not set assume spot. """ assert pair.is_spot(), f"Signals are tracked by their spot pairs. got {pair}" # Don't let Numpy values beyond this point, as # they cause havoc in serialisation if isinstance(alpha, np.float32): alpha = float(alpha) if alpha < 0: assert leverage is not None, f"Leverage must be set for short, received signal {alpha} for pair {pair.get_human_description(describe_type=True)}" if alpha == 0: # Zero signal. # Delete the pair from the signal mappings so that the pair so that it does not get any further computations if pair.internal_id in self.raw_signals: del self.raw_signals[pair.internal_id] else: signal = TradingPairSignal( pair=pair, signal=alpha, stop_loss=stop_loss, take_profit=take_profit, trailing_stop_loss=trailing_stop_loss, leverage=leverage, ) self.raw_signals[pair.internal_id] = signal
[docs] def set_old_weight( self, pair: TradingPairIdentifier, old_weight: float, old_value: USDollarAmount, old_synthetic_pair: TradingPairIdentifier, ): """Set the weights for the8 current portfolio trading positions before rebalance. :param pair: The spot pair we are trading. """ assert pair is not None assert pair.is_spot() if pair.internal_id in self.signals: self.signals[pair.internal_id].old_weight = old_weight self.signals[pair.internal_id].old_value = old_value self.signals[pair.internal_id].old_pair = old_synthetic_pair else: self.signals[pair.internal_id] = TradingPairSignal( pair=pair, signal=0, old_weight=old_weight, old_value=old_value, old_pair=old_synthetic_pair, )
[docs] def select_top_signals(self, count: int, threshold=0.0, ): """Chooses top signals. Choose trading pairs to the next rebalance by their signal strength. Sets :py:attr:`signals` attribute of the model Example: .. code-block:: python alpha_model.select_top_signals( count=5, # Pick top 5 trading pairs threshold=0.01, # Need at least 1% signal certainty to be eligible ) :param count: How many signals to pick. :param threshold: If the raw signal value is lower than this threshold then don't pick the signal. .. note :: It's better to filter signals in your `decide_trades()` functinos before calling this, as this allows you have to different thresholds for long and short signals. Inclusive. `0.01 = 1%` signal strenght. """ filtered_signals = [s for s in self.raw_signals.values() if abs(s.signal) >= threshold] top_signals = heapq.nlargest(count, filtered_signals, key=lambda s: s.raw_weight) self.signals = {s.pair.internal_id: s for s in top_signals}
def normalise_weights(self): raw_weights = {s.pair.internal_id: s.raw_weight for s in self.signals.values()} normalised = normalise_weights(raw_weights) for pair_id, normal_weight in normalised.items(): self.signals[pair_id].normalised_weight = normal_weight
[docs] def assign_weights(self, method=weight_by_1_slash_n): """Convert raw signals to their portfolio weight counterparts. Update :py:attr:`TradingPairSignal.raw_weight` attribute to our target trading pairs. :param method: What method we use to convert a trading signal to a portfolio weights """ raw_signals = {s.pair.internal_id: s.signal for s in self.signals.values()} weights = method(raw_signals) for pair_id, raw_weight in weights.items(): self.signals[pair_id].raw_weight = raw_weight
[docs] def update_old_weights(self, portfolio: Portfolio): """Update the old weights of the last strategy cycle to the alpha model. - Update % of portfolio weight of an asset - Update USD portfolio value of an asset """ total = portfolio.get_position_equity_and_loan_nav() for position in portfolio.open_positions.values(): value = position.get_value() weight = value / total self.set_old_weight( position.pair.get_pricing_pair(), weight, value, position.pair, )
[docs] def calculate_weight_diffs(self) -> Dict[PairInternalId, float]: """Calculate how much % asset weight has changed between strategy cycles. :return: Pair id, weight delta dict """ new_weights = {s.pair.internal_id: s.normalised_weight for s in self.signals.values()} existing_weights = {s.pair.internal_id: s.old_weight for s in self.signals.values()} # Check that both inputs are sane check_normalised_weights(new_weights) check_normalised_weights(existing_weights) diffs = {} for id, new_weight in new_weights.items(): diffs[id] = new_weight - existing_weights.get(id, 0) # Refill gaps of old assets that did not appear # in the new portfolio for id, old_weight in existing_weights.items(): if id not in diffs: # Sell all diffs[id] = -old_weight return diffs
[docs] def calculate_target_positions(self, position_manager: PositionManager, investable_equity: USDollarAmount): """Calculate individual dollar amount for each position based on its normalised weight. - Sets the dollar value of the position - Adjusts the existing dollar value of positions - Map the signal to a trading pair (spot, synthetic short pair, etc.) """ # dollar_values = {pair_id: weight * investable_equity for pair_id, weight in diffs.items()} self.investable_equity = investable_equity for s in self.iterate_signals(): s.position_target = s.normalised_weight * investable_equity s.synthetic_pair = self.map_pair_for_signal(position_manager, s) if s.is_flipping(): # When we go between short/long/spot # we close the previous position and the # adjust the full size of the new position s.position_adjust_usd = s.position_target else: # s.position_adjust_usd = s.position_target - s.old_value if s.position_adjust_usd < 0: # Decreasing positions by selling the token # A lot of options here how to go about this. # We might get some minor position size skew here because fees not included # for these transactions s.position_adjust_quantity = position_manager.estimate_asset_quantity(s.pair, s.position_adjust_usd) assert type(s.position_adjust_quantity) == float
[docs] def map_pair_for_signal( self, position_manager: PositionManager, signal: TradingPairSignal, ) -> TradingPairIdentifier: """Figure out if we are going to trade spot, leveraged long, leveraged short.""" underlying = signal.pair strategy_universe = position_manager.strategy_universe # Spot if signal.signal > 0: return underlying elif signal.signal < 0: return strategy_universe.get_shorting_pair(underlying) else: return underlying
[docs] def generate_rebalance_trades_and_triggers( self, position_manager: PositionManager, min_trade_threshold: USDollarAmount = 10.0, use_spot_for_long=True, ) -> List[TradeExecution]: """Generate the trades that will rebalance the portfolio. This will generate - Sells for the existing assets - Buys for new assets or assets where we want to increase our position - Set up take profit/stop loss triggers for positions :param position_manager: Portfolio of our existing holdings :param min_trade_threshold: Threshold for too small trades. If the notional value of a rebalance trade is smaller than this USD amount don't make a trade, but keep whatever position we currently we have. This is to prevent doing too small trades due to fuzziness in the valuations and calculations. :param use_spot_for_long: If we go long a pair, use spot. If set False, use leveraged long. :return: List of trades we need to execute to reach the target portfolio. The sells are sorted always before buys. """ assert use_spot_for_long, "Leveraged long unsupported for now" # Generate trades trades: List[TradeExecution] = [] logger.info( "Generating alpha model rebalances. Before rebalance we have %d positions open. We got %d signals.", len(position_manager.state.portfolio.open_positions), len(self.signals), ) # TODO: Break this massive for if spagetti to sub-functions for signal in self.iterate_signals(): # Trades that we will execute for the position for this signal # Trades that we will execute for the position for this signal # A signal may cause multiple trades, as e.g. # closing a short position and opening a long when the signal goes from -1 to 1 # will cause 2 trades (close short, open long) position_rebalance_trades = [] dollar_diff = signal.position_adjust_usd quantity_diff = signal.position_adjust_quantity value = signal.position_target underlying = signal.pair synthetic = signal.synthetic_pair # Do backtesting record keeping, so that # it is later easier to display alpha model thinking current_position = None if signal.old_pair: current_position = position_manager.get_current_position_for_pair(signal.old_pair) if current_position: signal.profit_before_trades = current_position.get_total_profit_usd() signal.profit_before_trades_pct = current_position.get_total_profit_percent() else: signal.profit_before_trades = 0 logger.info("Rebalancing %s, trading as %s, signal #%d, old position %s, old weight: %f, new weight: %f, size diff: %f USD", underlying.base.token_symbol, synthetic.base.token_symbol, signal.signal_id, current_position and current_position.pair or "-", signal.old_weight, signal.normalised_weight, dollar_diff) if abs(dollar_diff) < min_trade_threshold and not signal.is_flipping(): # The value diff in the rebalance is so small that we do not care about it logger.info("Not doing anything, diff %f (value %f) below trade threshold %f", dollar_diff, value, min_trade_threshold) signal.position_adjust_ignored = True else: if signal.normalised_weight < self.close_position_weight_epsilon: # Signal too weak, get rid of any open position # Explicit close to avoid rounding issues if current_position: logger.info("Closing the position fully: %s", current_position) position_rebalance_trades += position_manager.close_position( current_position, TradeType.rebalance, notes=f"Closing position, because the signal weight is below close position weight threshold: {signal}" ) signal.position_id = current_position.position_id else: logger.info("Zero signal, but no position to close") else: # Signal is switching between short/long, # so close any old position if signal.is_flipping(): logger.info("Alpha model signal flipping for %s: %s, new strength %f", signal.pair.get_pricing_pair().base.token_symbol, signal.get_flip_label(), signal.signal) old_position = position_manager.get_current_position_for_pair(signal.old_pair) if old_position: position_rebalance_trades += position_manager.close_position( old_position, TradeType.rebalance, notes=f"Closing because switching between long/short for {signal}" ) if signal.signal < 0: # A shorting signal. # Open new short or adjust existing short. leverage = signal.leverage assert type(leverage) == float, f"Signal is short, but does not have a leverage multiplier set {signal}" if signal.is_flipping() or signal.is_new(): # Open new short, # we ignore dollar_diff and use value directly position_rebalance_trades += position_manager.open_short( underlying, value=value, leverage=leverage, take_profit_pct=signal.take_profit, stop_loss_pct=signal.stop_loss, trailing_stop_loss_pct=signal.trailing_stop_loss, notes="Rebalance opening a new short for signal {signal}", ) else: # Increase/decrease short position_rebalance_trades += position_manager.adjust_short( current_position, new_value=value, notes=f"Rebalance existing short for signal: {signal} value: {value}", ) elif signal.leverage is None: # A spot buy signal. # Open new spot or adjust existing one. # Increase or decrease the position for the target pair # Open new position if needed. logger.info("Adjusting spot position") position_rebalance_trades += position_manager.adjust_position( synthetic, dollar_diff, quantity_diff, signal.normalised_weight, stop_loss=signal.stop_loss, take_profit=signal.take_profit, trailing_stop_loss=signal.trailing_stop_loss, override_stop_loss=self.override_stop_loss, notes="Rebalance for signal {signal}" ) else: raise NotImplementedError(f"Leveraged long missing w/leverage {signal.leverage}, {signal.get_flip_label()}: {signal}") assert len(position_rebalance_trades) >= 1, "Assuming always on trade for rebalance" # Connect trading signal to its position last_trade = position_rebalance_trades[0] assert last_trade.position_id signal.position_id = last_trade.position_id if position_rebalance_trades: trade_str = ", ".join(t.get_short_label() for t in position_rebalance_trades) logger.info("Rebalance trades generated for signal #%d for %s: %s", signal.signal_id, underlying.get_ticker(), trade_str) else: logger.info("No trades generated for: %s", underlying.get_ticker()) trades += position_rebalance_trades trades.sort(key=lambda t: t.get_execution_sort_position()) # Return all rebalance trades return trades
[docs]def format_signals( alpha_model: AlphaModel, ) -> pd.DataFrame: """Debug helper used to develop the strategy. Print the signal state to the logging output. :return: DataFrame containing a table for signals on this cycle """ data = [] sorted_signals = sorted([s for s in alpha_model.signals.values()], key=lambda s: s.pair.base.token_symbol) # print(f"{timestamp} cycle signals") for s in sorted_signals: pair = s.pair synthetic_pair = s.synthetic_pair.get_ticker() old_pair = s.old_pair.get_ticker() if s.old_pair else "-" data.append((pair.get_ticker(), s.signal, s.position_adjust_usd, s.normalised_weight, s.old_weight, s.get_flip_label(), synthetic_pair, old_pair)) #print(f"Pair: {pair.get_ticker()}, signal: {s.signal}") df = pd.DataFrame(data, columns=["Core pair", "Signal", "Value adj", "Norm weight", "Old weight", "Flipping", "Trade as", "Old trade as"]) df = df.set_index("Core pair") return df