Query Account Information

from tigeropen.tiger_open_config import TigerOpenClientConfig
from tigeropen.trade.trade_client import TradeClient

client_config = TigerOpenClientConfig(props_path='your_config_directory_path')
trade_client = TradeClient(client_config)

accounts = trade_client.get_managed_accounts()
# View attributes of the first account
account1 = accounts[0]
print(account1.account)  # Account number
print(account1.account_type)  # Account category (prime/paper trading)
print(account1.capability)  # Account capability (cash/margin)

portfolio_account = trade_client.get_prime_assets(base_currency='USD')  # Can set base currency
print(portfolio_account)

# Example of viewing account attributes
print(portfolio_account.account)   # Account ID
print(portfolio_account.segments['S'].buying_power)  # Securities account buying power
print(portfolio_account.segments['S'].cash_balance)  # Securities account cash value
print(portfolio_account.segments['S'].unrealized_pl)   # Unrealized P&L
print(portfolio_account.segments['S'].currency_assets['USD'].gross_position_value)  # Total securities value in USD
print(portfolio_account.segments['S'].currency_assets['HKD'].gross_position_value)  # Total securities value in HKD
print(portfolio_account.segments['S'].currency_assets['HKD'].cash_balance)  # Cash value in HKD

print(portfolio_account.segments['C'].init_margin)  # Futures account initial margin
print(portfolio_account.segments['C'].maintain_margin)  # Futures account maintenance margin
print(portfolio_account.segments['C'].currency_assets['USD'].cash_balance)  # Futures account cash value in USD

 PortfolioAccount(
  {
	'account': '1234567',
	'update_timestamp': 1638949616442,
	'segments': {
		'S': Segment({
			'currency': 'USD',
			'capability': 'RegTMargin',
			'category': 'S',
			'cash_balance': 111978.7160247,
			'cash_available_for_trade': 123905.775195,
			'cash_available_for_withdrawal': 123905.775195,
			'gross_position_value': 22113.5652986,
			'equity_with_loan': 134092.2813233,
			'net_liquidation': 135457.2802984,
			'init_margin': 9992.3764097,
			'maintain_margin': 8832.4423281,
			'overnight_margin': 11607.5876493,
			'unrealized_pl': -1121.0821891,
			'realized_pl': -3256.0,
			'excess_liquidation': 125259.8389952,
			'overnight_liquidation': 122484.693674,
			'buying_power': 495623.1007801,
			'leverage': 0.164693,
			'currency_assets': {
				'USD': CurrencyAsset({
					'currency': 'USD',
					'cash_balance': 123844.77,
					'cash_available_for_trade': 123792.77
				}),
				'HKD': CurrencyAsset({
					'currency': 'HKD',
					'cash_balance': -92554.07,
					'cash_available_for_trade': -93664.15
				}),
				'CNH': CurrencyAsset({
					'currency': 'CNH',
					'cash_balance': 0.0,
					'cash_available_for_trade': 0.0
				})
			}
		}),
		'C': Segment({
			'currency': 'USD',
			'capability': 'RegTMargin',
			'category': 'C',
			'cash_balance': 3483681.32,
			'cash_available_for_trade': 3481701.32,
			'cash_available_for_withdrawal': 3481701.32,
			'gross_position_value': 1000000.0,
			'equity_with_loan': 3481881.32,
			'net_liquidation': 3483681.32,
			'init_margin': 1980.0,
			'maintain_margin': 1800.0,
			'overnight_margin': 1800.0,
			'unrealized_pl': 932722.41,
			'realized_pl': -30.7,
			'excess_liquidation': 3481881.32,
			'overnight_liquidation': 3481881.32,
			'buying_power': 0.0,
			'leverage': 0.0,
			'currency_assets': {
				'USD': CurrencyAsset({
					'currency': 'USD',
					'cash_balance': 3483681.32,
					'cash_available_for_trade': 3483681.32
				}),
				'HKD': CurrencyAsset({
					'currency': 'HKD',
					'cash_balance': 0.0,
					'cash_available_for_trade': 0.0
				}),
				'CNH': CurrencyAsset({
					'currency': 'CNH',
					'cash_balance': 0.0,
					'cash_available_for_trade': 0.0
				})
			}
		})
	}
})

portfolio_account = trade_client.get_assets(segment=True, market_value=True)
print(portfolio_account)

# View attributes of the first portfolio
portfolio1 = portfolio_account[0]
print(portfolio1.account)  # Account ID
print(portfolio1.segments['S'].available_funds)  # Available funds in securities account
print(portfolio1.segments['S'].gross_position_value)  # Market value of securities account
print(portfolio1.segments['C'].available_funds)  # Available funds in futures account (only has value if futures account is opened)
print(portfolio1.summary.buying_power)  # Buying power
print(portfolio1.summary.cash)  # Cash

[PortfolioAccount({'account': 'DU111111', 
                    'summary': Account({'accrued_cash': 0, 'accrued_dividend': 0, 'available_funds': 948.69, 
                                        'buying_power': 948.69, 'cash': 948.81, 'currency': 'USD', 'cushion': 0.5944, 
                                        'day_trades_remaining': 3, 'equity_with_loan': 1255.69, 'excess_liquidity': 948.81, 
                                        'gross_position_value': 647.53, 'initial_margin_requirement': 307, 
                                        'maintenance_margin_requirement': 307, 'net_liquidation': 1596.34, 
                                        'realized_pnl': 0, 'regt_equity': 1255.81, 
                                        'regt_margin': 153.5, 'sma': 3512.56, 
                                        'timestamp': 1561529631, 'unrealized_pnl': -885.36}), 

                    'segments': defaultdict(<class 'tigeropen.trade.domain.account.Account'>, 
                            {'C': CommoditySegment({'accrued_cash': 0, 'accrued_dividend': 0, 
                                                    'available_funds': 0, 'cash': 0, 'equity_with_loan': 0, 'excess_liquidity': 0, 
                                                    'initial_margin_requirement': 0, 'maintenance_margin_requirement': 0, 
                                                    'net_liquidation': 0, 'timestamp': 1544393719}), 
                            'S': SecuritySegment({'accrued_cash': 0, 'accrued_dividend': 0, 
                                                'available_funds': 120.73, 'cash': 120.73, 'equity_with_loan': 1292.04, 
                                                'excess_liquidity': 120.73, 'gross_position_value': 1171.31, 
                                                'initial_margin_requirement': 1171.31, 'leverage': 0.91, 
                                                'maintenance_margin_requirement': 1171.31, 'net_liquidation': 1292.04, 
                                                'regt_equity': 1292.04, 'regt_margin': 585.66, 'sma': 1973.39, 'timestamp': 1545206069})
                            }), 

                    'market_values': defaultdict(<class 'tigeropen.trade.domain.account.MarketValue'>, 
                            {'CNH': MarketValue({'currency': 'CNH', 'net_liquidation': 0, 'cash_balance': 0, 
                                '               stock_market_value': 0, 'option_market_value': 0, 
                                                'warrant_value': 0, 'futures_pnl': 0, 'unrealized_pnl': 0, 
                                                'realized_pnl': 0, 'exchange_rate': 0.14506, 
                                                'net_dividend': 0, 'timestamp': 1544078822}), 
                            'HKD': MarketValue({'currency': 'HKD', 'net_liquidation': 0, 'cash_balance': 0, 
                                                'stock_market_value': 0, 'option_market_value': 0, 
                                                'warrant_value': 0, 'futures_pnl': 0, 'unrealized_pnl': 0, 
                                                'realized_pnl': 0, 'exchange_rate': 0.12743, 
                                                'net_dividend': 0, 'timestamp': 1550158606}), 
                            'USD': MarketValue({'currency': 'USD', 'net_liquidation': 1596.34, 
                                                'cash_balance': 948.81, 'stock_market_value': 307, 
                                                'option_market_value': 340.53, 'warrant_value': 0, 
                                                'futures_pnl': 0, 'unrealized_pnl': -885.36, 
                                                'realized_pnl': 0, 'exchange_rate': 1, 
                                                'net_dividend': 0, 'timestamp': 1561519773})}
                            )}
                    )]

from tigeropen.common.consts import Currency, Market, SecurityType

positions = trade_client.get_positions(sec_type=SecurityType.STK, currency=Currency.ALL, market=Market.ALL)
position = positions[0]
print(position.contract.symbol)
print(position.average_cost)
print(position.quantity)
print(position.unrealized_pnl)

[contract: BABA/STK/USD, quantity: 1, average_cost: 178.99, market_price: 176.77,
 contract: BIDU/STK/USD, quantity: 3, average_cost: 265.4633, market_price: 153.45]

from tigeropen.common.consts import SegmentType

result = trade_client.get_analytics_asset(start_date='2021-12-01', end_date='2021-12-07', seg_type=SegmentType.SEC)
print(result['summary']['pnl'])
for item in result['history']:
    print(item['dt'], item['pnl'])

{
  'summary': {
    'pnl': 691.18,
    'pnl_percentage': 0.0,
    'annualized_return': 0.0,
    'over_user_percentage': 0.0
  },
  'history': [
    {
      'date': 1638334800000,
      'dt': '2021-12-01',
      'pnl': 0.0,
      'pnl_percentage': 0.0,
      'asset': 48827609.65,
      'cash_balance': 48811698.59,
      'gross_position_value': 15911.06,
      'deposit': 0.0,
      'withdrawal': 0.0
    },
    {
      'date': 1638421200000,
      'dt': '2021-12-02',
      'pnl': 78.04,
      'pnl_percentage': 0.0,
      'asset': 48827687.69,
      'cash_balance': 48811698.59,
      'gross_position_value': 15989.1,
      'deposit': 0.0,
      'withdrawal': 0.0
    }
  ]
}

available = trade_client.get_segment_fund_available(from_segment='SEC', currency='HKD')
print(available[0].amount)

[SegmentFundAvailableItem({'from_segment': 'SEC', 'currency': 'HKD', 'amount': 718859.79})]

result = trade_client.transfer_segment_fund(from_segment='SEC', to_segment='FUT', amount=100, currency='USD')
print(result)

SegmentFundItem({'id': 30322815980011520, 'from_segment': 'SEC', 'to_segment': 'FUT',
 'currency': 'USD', 'amount': 100.0, 'status': 'NEW', 'status_desc': 'Submitted',
 'message': None, 'settled_at': None, 'updated_at': 1680243926131,
 'created_at': 1680243926131})

result = trade_client.cancel_segment_fund(id=30322815980011520)
print(result)

SegmentFundItem({'id': 30322815980011520, 'from_segment': 'SEC', 'to_segment': 'FUT',
 'currency': 'USD', 'amount': 100.0, 'status': 'CANC', 'status_desc': 'Cancelled',
 'message': None, 'settled_at': None, 'updated_at': 1680243926131,
 'created_at': 1680243926131})

from tigeropen.common.consts import SecurityType, Currency, Market
history = trade_client.get_segment_fund_history()
print(history)

from tigeropen.common.consts import SecurityType, Currency, Market
from tigeropen.common.util.contract_utils import stock_contract
from tigeropen.common.util.order_utils import limit_order
contract = stock_contract(symbol='MSFT', currency='USD')
order = limit_order(account=client_config.account, contract=contract, action='BUY', limit_price=50, quantity=1)
res = trade_client.get_estimate_tradable_quantity(order)
print(res)

from tigeropen.common.consts import SecurityType, Currency, Market
res = trade_client.get_funding_history()
print(res)

        id           ref_id  type type_desc currency   amount business_date  completed_status     updated_at     created_at
0  3000000               26     1    Deposit      USD   484.88    2017/08/24              True  1503574430000  1503574430000
1  3000001              123     1    Deposit      USD  2000.00    2017/12/15              True  1513308908000  1513308908000

from tigeropen.common.consts import SecurityType, Currency, Market
result = trade_client.get_fund_details(
	seg_types=[SegmentType.SEC, SegmentType.FUT],
	start= 0,
	limit = 50,
	start_date='2025-03-28',
	end_date='2025-04-04',
	fund_type='ALL',
	# currency = Currency.USD,
	# lang = Language.en_US,
)
print(result)


# Paginated retrieval of all data
start = 0
limit = 50
final_result = pd.DataFrame()
while True:
    res = trade_client.get_fund_details(seg_types=[SegmentType.SEC, SegmentType.FUT], start=start, limit=limit,start_date='2025-01-01', end_date='2025-05-01')
    if res.empty:
        break
    start += limit
    final_result = pd.concat([final_result, res], ignore_index=True)
print(final_result)
	

                  id currency          type               desc contract_name seg_type  amount business_date     updated_at  page  limit  item_count  page_count      timestamp
0  24924145889681231      USD  Corporate Action Fee  VFS-DIVIDEND                    SEC   -0.10    2025-04-04  1743762173000     1     50           8           1  1745581047814
1  24924145889681229      USD       Dividend  VFS-DIVIDEND                    SEC    0.10    2025-04-04  1743762173000     1     50           8           1  1745581047814
2  24924145889681217      USD  Corporate Action Fee  VFS-DIVIDEND                    SEC    0.09    2025-04-04  1743762171000     1     50           8           1  1745581047814
3  24924145889681215      USD      Dividend Tax  VFS-DIVIDEND                    SEC    0.01    2025-04-04  1743762171000     1     50           8           1  1745581047814
4  24924145889681213      USD       Dividend  VFS-DIVIDEND                    SEC   -0.10    2025-04-04  1743762171000     1     50           8           1  1745581047814
5  24924145889678880      USD  Corporate Action Fee  VFS-DIVIDEND                    SEC   -0.09    2025-03-28  1743392460000     1     50           8           1  1745581047814
6  24924145889678878      USD      Dividend Tax  VFS-DIVIDEND                    SEC   -0.01    2025-03-28  1743392460000     1     50           8           1  1745581047814
7  24924145889678876      USD       Dividend  VFS-DIVIDEND                    SEC    0.10    2025-03-28  1743392460000     1     50           8           1  1745581047814