GetUnrealizedGainLossDetail
未實現損益明細查詢
bool GetStkClassifyPrice(Account, MarketType, StkCode, lng)
回傳:
| Type | Description |
|---|---|
| bool | True:此功能執行成功;False:此功能執行異常(結果請從回應事件 OnResponse 接收) |
Input Parameters
| Name | Type | Description | Memo |
|---|---|---|---|
| Account | string | 帳號 | 證券:S+分公司代號(4)+帳號(7) 例如 S98875005091 註1 |
| MarketType | enumMarketType | 市場類別 | 參考列舉物件-市場類別 |
| StkCode | string | 股票代號 | |
| lng | enumLangType | 語系 | 參考列舉物件-語系 預設為 Normal- Normal:Big5 - UTF8:UTF8 - SC:簡體中文 |
Tip
註1:限證券使用
Output Parameters
UnGainLossDetailResult 未實現損益明細結果
| Name | Type | Description | Memo |
|---|---|---|---|
| UnGainLossDetailList | List<UnGainLossDetail> | 結果清單 | 註2 |
Tip
註2:不包含待沖單資訊
範例
UnGainLossDetail 未實現損益明細物件
| Name | Type | Description | Memo |
|---|---|---|---|
| Account | string | 帳號 | |
| TradeKind | int | 交易種類 | 0:現股 3:資買 4:券賣 |
| MarketNo | enumMarketType | 市場代碼 | 參考列舉物件-市場類別 |
| StkCode | string | 股票代號 | |
| StockQty | long | 股數 | |
| Price | double | 成交價 | |
| TradeDate | string | 成交日 | yyyy/MM/dd |
| Cost | double | 持有成本 | |
| Interest | long | 預估利息 | |
| ReturnAmt | double | 未實現損益 | |
| MarketAmt | double | 股票市值 | 股數*市價 |
引用元件
import os, time, datetime, struct, pathlib, sys
from datetime import datetime
from pathlib import Path
from pythonnet import load
load("coreclr")
import clr, System
##透過Clr引用系統標準函式
clr.AddReference('System.Collections')
from System.Collections.Generic import List
from System.Reflection import BindingFlags
##宣告增加模組、DLL的路徑(windows可抓取當前路徑 Linux跟MAC需指定路徑)
sys.path.append(Path(pathlib.Path(__file__).parent.resolve()))
if sys.platform == "win32":
os.add_dll_directory(Path(pathlib.Path(__file__).parent.resolve()))
##透過Clr引用YuantaSparkAPI.dll
##pythonnet引用元件不用加附檔名
try:
clr.AddReference("YuantaSparkAPI")
except Exception as e:
print(f"Error loading YuantaSparkAPI: {e}")
from YuantaOneAPI import YuantaSparkAPITrader, enumLogType, enumMarketType, enumEnvironmentMode, enumStkTickSelectType
# 建立 API 物件
objYuantaSparkAPI = YuantaSparkAPITrader()
objYuantaSparkAPI.SetLogType(enumLogType.COMMON)
using System;
using System.Collections.Generic;
using System.Text;
using System.Threading;
using YuantaOneAPI;
YuantaSparkAPITrader objYuantaSparkAPI = new YuantaSparkAPITrader();
string Account = "S98875005091";
string Password = "1234";
enumEnvironmentMode enumEvenMode = enumEnvironmentMode.UAT;
objYuantaSparkAPI.OnResponse += objApi_OnResponse;
objYuantaSparkAPI.SetLogType(enumLogType.ALL);
objYuantaSparkAPI.Open(enumEvenMode);
Thread.Sleep(1000);
objYuantaSparkAPI.Login(Account, Password);
Thread.Sleep(1000);
string stock = "2330";
objYuantaSparkAPI.GetUnrealizedGainLossDetail(Account, enumMarketType.TWSE, stock);
Thread.Sleep(2000);
Onresponse
def on_response(intMark, dwIndex, strIndex, objHandle, objValue):
try:
result = ''
match intMark:
case 0: # 系統回應資訊
result = str(objValue)
case 1: # 查詢回應資訊
match strIndex:
case 'Login':
loginResult = objValue
status = loginResult.LoginStatus
strMsgCode = status.MsgCode # 訊息代碼
strMsgContent = status.MsgContent # 訊息內容
intCount = status.Count # 筆數
result = '{0},{1},帳號筆數:{2}\r\n'.format(strMsgCode,strMsgContent, str(intCount))
if strMsgCode == '0001' or strMsgCode == '00001' or intCount > 0 :
for i in objValue.LoginList:
result += f"{i.Account},{i.Name},{i.InvestorID},{i.SellerNo}\n"
case 'GetUnrealizedGainLossDetail':
GResult = objValue
gResult = GResult.UnGainLossDetailList
result += '未實現損益明細結果:\r\n'
for item in gResult:
f = item.GetType().GetField('Cost', BindingFlags.Instance | BindingFlags.Public | BindingFlags.NonPublic | BindingFlags.DeclaredOnly)
cost = f.GetValue(item)
result += f'{item.Account},{item.TradeKind},{item.MarketNo},{item.StkCode},{item.StockQty},{item.Price},{item.TradeDate},{cost},{item.Interest},{item.ReturnAmt},{item.MarketAmt}\r\n'
if result:
print('##================================================##\n')
print(result)
except Exception as error:
print(f"處理回應時發生錯誤: {error}")
objYuantaSparkAPI.OnResponse += on_response
#測試環境帳號:UAT 正式環境:PROD
objYuantaSparkAPI.Open(enumEnvironmentMode.UAT)
time.sleep(2)
objYuantaSparkAPI.Login('S98875005091', '1234')
time.sleep(2)
objYuantaSparkAPI.GetUnrealizedGainLossDetail('S98875005091',enumMarketType.TWSE,'2885')
# 保持程式運行
while True:
time.sleep(2)
void objApi_OnResponse(int intMark, uint dwIndex, string strIndex, object objHandle, object objValue)
{
try
{
string strResult = "";
if (intMark == 0)
{
Console.WriteLine(Convert.ToString(objValue));
return;
}
if (intMark == 1)
{
if (strIndex == "Login")
{
var result = (LoginResult)objValue;
string strMsgCode = result.LoginStatus.MsgCode;
string strMsgContent = result.LoginStatus.MsgContent;
int intCount = result.LoginStatus.Count;
strResult += $"{strMsgCode}, {strMsgContent}{Environment.NewLine}";
if (strMsgCode == "0001" || strMsgCode == "00001")
{
strResult += $"帳號筆數: {intCount.ToString()}{Environment.NewLine}";
result.LoginList.ForEach(r => strResult += $"{r.Account},{r.Name},{r.InvestorID},{r.SellerNo}\r\n");
}
else
{
Account = "";
}
Console.WriteLine("\n======================");
Console.WriteLine(strResult.ToString());
Console.WriteLine("======================\n");
return;
}
if (strIndex == "GetUnrealizedGainLossDetail")
{
var result = (UnGainLossDetailResult)objValue;
try
{
strResult += $"未實現損益明細查詢:\r\n";
result.UnGainLossDetailList.ForEach(u =>
{
strResult += $"{u.Account} {u.TradeKind} {u.MarketNo} {u.StkCode} {u.StockQty} {u.Price} {u.TradeDate} {u.Cost} {u.Interest} {u.ReturnAmt} {u.MarketAmt}\r\n";
});
}
catch
{
strResult = "";
}
Console.WriteLine("\n======================");
Console.WriteLine(strResult);
Console.WriteLine("======================\n");
return;
}
}
Console.WriteLine($"[{strIndex}] {Convert.ToString(objValue)}");
}
catch (Exception exc)
{
Console.WriteLine("OnResponse Error: " + exc.Message);
}
}
Response Body
{
"Result": {
"UnGainLossDetailList": [
{
"Account": "S98875005091",
"TradeKind": "0",
"MarketNo": "TWSE",
"StkCode": "2330",
"StockQty": "1000",
"Price": "1660",
"TradeDate": "2026/01/16",
"Cost": "1662365",
"Interest": "0",
"ReturnAmt": "145056",
"MarketAmt": "1810000"
}
]
}
}