I'm looking to integrate quotes from the ThinkorSwim client provided by an RTD or DDE call. The format of the calls if done from excel seems trivial enough:
=RTD("Tos.RTD", , "DELTA", ".NDX161216C3880")
OR
=DDE("TOS";"DELTA";".NDX161216C3920")
I've done quite a bit of searching on the web and can't seem to find an example of this type of call, although I have seem several posts that j-Interop would be a good tool for this requirement. While I have a solid understanding of Java, my COM knowledge is pretty lacking and I'm having a hard time figuring out where to begin, specifically the parameters to use in establishing the connection to the server, making the request and then parsing the results. Any pointers are greatly appreciated.