Excel RTD

Community Support
1

hi, 

From what i understand, after RTD installation, whenever i open excel, it will automatically connect to the host configured in the file

K4RtdServer.dll.config

however i can’t see there is any process (subscriber) listening to the host/ticker plant from checking .z.W

What should I do to use RTD? Is there any step by step example?

thanks

Chao

2

Hi,

assuming you’re referring to

http://code.kx.com/wiki/Cookbook/IntegratingWithExcel

and more specifically

http://code.kx.com/wsvn/code/contrib/cskelton/excelrtd/K4RtdServer

are you really connecting to a ticker plant process (i.e. one that has loaded tick.q)?

are you using authentication on your ticker plant process? If so, can you specify username/password in config file.

is there any useful info in the rtd log file?

you could hook .z.po and .z.pc to show whether it connects/disconnects.

thanks

3

Hi Charles,

referring to 

https://code.kx.com/v2/interfaces/excel-client-for-q/

https://github.com/CharlesSkelton/excelrtd

Attached a screenshot, tried with .z.po 

  1. and the excel is not appearing as a connection

  2. where does plant1 appear in tick.q ?

Please can provide more steps to use the Excel tool?

Thanks!