kc3031
New Contributor
since ‎2017.03.31
‎2021.06.14

User Statistics

  • 18 Posts
  • 0 Solutions
  • 0 Kudos given
  • 0 Kudos received

User Activity

Hi,I want to rank a list of numbers: 1 2 3 4 5 3 3 3In kdb+/q, by using rank function, the result is 0 1 2 6 7 3 4 5. The duplicates do not get the same ranking results.Ideally, I want to have: 0 1 3.5 6 7 3.5 3.5 3.5Any help would be greatly appreci...
Greetings,Is there a way to connect KDB with FTP with username and password and retrieve data back to KDB?I tried: system "curl ftp://username:password@xxx/path/to/.csv" but it failed.Any help would be greatly appreciated!Best,Kelly
Greetings,I'm trying to calculate the log return of price.For example,datetime | price | return9:30 709:45 80 log(80/70)10:00 85 log(85/80)10:15 78 log(78/85)Is there a quick way to calculate based on fields in different rows?Many thanks!Best,Kelly
Hello experts,I am trying to use asof join to join the stock return, sector return and market return.My table looks as follows:stock (TABLE):stock | datetime | stockReturn | sectorAAPL 2017.04.03T09:30:00.00 0.00151 TECsector_market (TABLE):sector | ...
Hello,I am trying to have two functions run automatically. For example, for function 1, I want it to run once a day; for function 2, I want it to run every 10 minutes.Can anyone guide me how to set up a timer and make it run as scheduled? Many thanks...