Account & Portfolio
warning
The features of this page will be removed in the future.
Account Margin¶
In
api.get_account_margin?
Out
Signature: api.get_account_margin(currency='NTD', margin_type='1', account={})
Docstring:
query margin currency: {NTX, USX, NTD, USD, HKD, EUR, JPY, GBP}
the margin calculate in which currency
- NTX: 約當台幣
- USX: 約當美金
- NTD: 新台幣
- USD: 美元
- HKD: 港幣
- EUR: 歐元
- JPY: 日幣
- GBP: 英鎊
margin_type: {'1', '2'}
query margin type
- 1 : 即時
- 2 : 風險
In
account_margin = api.get_account_margin()
account_margin
Out
AccountMargin
Currency: NTD
Account: F0020009104000
Detail:
OrderPSecurity: 207000.0
ProfitAccCount: 207000.0
FProfit: 0.0
FMissConProfit: 0.0
OMissConProfit: 0.0
OColse: 0.0
OMarketPrice: 0.0
OTodayDiff: 0.0
HandCharge: 0.0
TradeTax: 0.0
Security: 0.0
StartSecurity: 0.0
UpKeepSecurity: 0.0
Statistics: 99999.0
Flow: 999.0
orderBid: 0.0
orderAsk: 0.0
Conclusionbid: 0.0
Conclusionask: 0.0
YesterdayBalance: 207000.0
PayMoney: 0.0
Equity: 207000.0
Ogain: 0.0
exrate: 1.0
xgdamt: 0.0
agtamt: 0.0
YesterdayEquity: 207000.0
Munet: 0.0
Cashamt: 207000.0
Bapamt: 0.0
Sapamt: 0.0
Adps: 0.0
Adamt: 0.0
Ybaln: 207000.0
directly pass our AccountMargin object to pandas to using your model
In
df_margin = pd.DataFrame(account_margin.data())
df_margin
Adamt | Adps | Bapamt | Cashamt | Conclusionask | Conclusionbid | Equity | FMissConProfit | FProfit | Flow | ... | TradeTax | UpKeepSecurity | Ybaln | YesterdayBalance | YesterdayEquity | agtamt | exrate | orderAsk | orderBid | xgdamt | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | 0.0 | 0.0 | 0.0 | 207000.0 | 0.0 | 0.0 | 207000.0 | 0.0 | 0.0 | 999.0 | ... | 0.0 | 0.0 | 207000.0 | 207000.0 | 207000.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 |
Get Open Position¶
In
api.get_account_openposition?
Out
Signature: api.get_account_openposition(product_type='0', query_type='0', account={})
Docstring:
query open position
product_type: {0, 1, 2, 3}
filter product type of open position
- 0: all
- 1: future
- 2: option
- 3: usd base
query_type: {0, 1}
query return with detail or summary
- 0: detail
- 1: summary
In
positions = api.get_account_openposition(query_type='1', account=api.futopt_account)
positions
AccountOpenPosition¶
In
df_positions = pd.DataFrame(positions.data())
df_positions
Account | Code | CodeName | ContractAverPrice | Currency | Date | FlowProfitLoss | MTAMT | OTAMT | OrderBS | OrderNum | OrderType | RealPrice | SettlePrice | SettleProfitLoss | StartSecurity | UpKeepSecurity | Volume | paddingByte | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | FF0020009104000 | TXFA9 | 台指期貨 01 | 9508.4137 | NTD | 00000000 | 4795201.620000 | 6438000.000000 | 8352000.000000 | B | 9784.0 | 9784.00 | 4795201.620000 | 8352000.000000 | 6438000.000000 | 87.000000 |
Get Settle ProfitLoss¶
In
api.get_account_settle_profitloss?
Out
Signature: api.get_account_settle_profitloss(product_type='0', summary='Y', start_date='', end_date='', currency='', account={})
Docstring:
query settlement profit loss
product_type: {0, 1, 2}
filter product type of open position
- 0: all
- 1: future
- 2: option
summary: {Y, N}
query return with detail or summary
- Y: summary
- N: detail
start_date: str
the start date of query range format with %Y%m%d
ex: 20180101
end_date: str
the end date of query range format with %Y%m%d
ex: 20180201
currency: {NTD, USD, HKD, EUR, CAD, BAS}
the profit loss calculate in which currency
- NTD: 新台幣
- USD: 美元
- HKD: 港幣
- EUR: 歐元
- CAD: 加幣
- BAS: 基幣
AccountSettleProfitLoss¶
In
st_date = (date.today() - timedelta(days=60)).strftime('%Y%m%d')
settle_profitloss = api.get_account_settle_profitloss(summary='Y', start_date=st_date)
settle_profitloss
df_profitloss = pd.DataFrame(settle_profitloss.data())
df_profitloss
account | averagePrice | code | codeName | currency | floatProfitLoss | handCharge | ord_bs | ord_type | ordno | ordno_b | settleAvgPrc | settleDate | settleVolume | tFlag | tdate | tradeProfitLoss | tradeTax | unVolume | volume | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | F0020009104000 | 9900.0 | TXFK8 | 台指期貨 11 | NTD | 460.000000 | 60.000000 | S | 00 | kY002 | kY003 | 9897.0 | 20181022 | 1.000000 | 1 | 20181022 | 600.000000 | 80.000000 | 0.000000 | 1.000000 |