New Contributor II
since ‎2022.04.30

User Statistics

  • 8 Posts
  • 2 Solutions
  • 2 Kudos given
  • 5 Kudos received

User Activity

Hi, Masters: Last week, I created a partition table to store fundmental data, for example, Sector A has 10 equities and Sector B has 8 equities. The data changed day by day and was loaded by a csv file which exported from Stock Exchange system. It wo...
Hi, Masters: I have a litter bit complex qSql, for example: select CntCOMP:count IND, avg Grade, COMP by IND, OptDate from (`IND xasc select RIC, COMP:link.COMPANY, BuySell, OptDate, OptPrice, Grade, Comment, IND:link.IND, LOC:link.LOC from AShare_Po...
Hi, Masters: I have a table with sym field, for example: q)show t:([]sym:(1+5?5)?\:5?`3)sym----------------,`ceo`edc`edc`edc`apa`mlf`ceo`ijl`apa`apa`mlf,`mlf How to add each sym and make it be a list, such as: `ceo`edc`edc`edc`apa`mlf`ceo`ijl`apa`apa...
Hi, Masters: Say I have a list contains dynamic sym variables: `a`b`a`b`c`d`c`b`a... How can I count each sym and get an output such as: `a:4 `b:3 `c:2 `d:1
Kudos from
Kudos given to