Hi,
I’m totally new to KDB (only learned about the basic syntax and haven’t put it into practice) and have a problem when trying to start my first practice.
I have a price series stored in KDB and it is updated in sync with the stock exchange. Now I want to pass the price series from KDB to VBA (not the whole series, just the latest 200 data points) to conduct further calculation. As the price series keeps being updated, the final result displayed in a cell should be dynamic.
I tried Charlie’s K4RTDServer, with which I can only get the latest price rather that a part of the price series. But without Charlie’s function, I don’t know how to get a dynamic result in excel.
Ideally, I want to write a excel function by VBA and get a computed result in the return.For example a VBA function:
result = KDBCalculator(kdbserver, dataset,number of data point)
Is it possible to do so? Thank you so much!