主页 / coding / 问题 / 79332423
Accepted
marital_weeping
Asked: 2025-01-06 15:50:31 +0800 CST

与更新一起使用的矢量化函数调用

  • 772
expryDt:{[ed] (2_string ed) except "."};

// generate a formatted ticker name for an option
symbol:{[tkr;expiryDate;typ;strike]
    if[not typ in `CALL`PUT`CE`PE; show "typ is not correct. it must be either CALL or PUT or CE or PE"; exit 1];
    r: $[(typ=`CALL) or (typ=`CE); string `C; string `P];
    "" sv (string tkr; expryDt[expiryDate]; r; string strike)
 };

// test
tkr:`IBM;
expiryDate:2025.01.09;
typ:`CALL;
strike:24000i;

show symbol[tkr;expiryDate;typ;strike]; // "IBM250109C24000" OK

我的格式化符号测试代码IBM250109C24000运行良好。但是，当我尝试将其应用于下表时，t它失败了，因为我的函数symbol未矢量化。我该如何让它工作？

t:([] ticker:`IBM`IBM`IBM;
      expiryDate:2025.01.09 2025.01.09 2025.01.09;
      typ:`CALL`PUT`CE;
      strike:24000 24000 24000;
      secType:`OPT`OPT`OPT);
show t;

t:update symbol:symbol[ticker;expiryDate;typ;strike] from t where secType=`OPT; // error

运行上述代码后得到以下输出：

"IBM250109C24000"
ticker expiryDate typ  strike secType
-------------------------------------
IBM    2025.01.09 CALL 24000  OPT    
IBM    2025.01.09 PUT  24000  OPT    
IBM    2025.01.09 CE   24000  OPT    
'type
  [3]  tv_options.q:5: symbol:{[tkr;expiryDate;typ;strike]
    if[not typ in `CALL`PUT`CE`PE; show "typ is not correct. it must be either CALL or PUT or CE or PE"; exit 1];
       ^
    r: $[(typ=`CALL) or (typ=`CE); string `C; string `P];
kdb+

1 个回答

  1. Best Answer

    最简单的方法是使用' https://code.kx.com/q/ref/maps/#case

    t:update symbol:symbol'[ticker;expiryDate;typ;strike] from t where secType=`OPT; // error

    但原生的矢量化函数会表现得更好。例如：

    genSymbols:{[tkr;expiryDate;typ;strike]
    if[any not typ in `CALL`PUT`CE`PE;
       '"typ is not correct. it must be either CALL or PUT or CE or PE"];
    r: ?[(typ=`CALL) or (typ=`CE);`C;`P];
    raze each (string tkr; expryDt each expiryDate;string r; string strike)
 };

    t:update symbol:genSymbols[ticker;expiryDate;typ;strike] from t where secType=`OPT;

    如果expryDt each expiryDate没有太多独特的价值，expiryDate那么您会看到改进.Q.fu[expryDt;expiryDate]

    • 2

相关问题