Sounds like you could set the RTD up as a web service, which Excel can consume using web queries, as described by Bob.The RTD itself could also be Excel. There is a little used and practically unknown feature in Excel for Mac where you can set Excel up to build a dynamic web page. In File Save As choose format Single File Web Page (.mht) and in the Save As dialog clickthe Automate button that lets you set a schedule for when the web site automatically updates, the idea being that the saved.mht file resides on a web server that is accessible to your consuming Excel clients via a web query.Here's a quick tutorial on using web queries in Excel on the Mac. There is example code on how to perform web queries using VBA. Not mentioned is that you can tell VBA to run on a schedule:I am an unpaid volunteer and do not work for Microsoft. 'Independent Advisors' work for contractors hired by Microsoft.
![]() ![]() ![]()
'Microsoft Agents' work for Microsoft Support.
The RTD itself could also be Excel. There is a little used and practically unknown feature in Excel for Mac where you can set Excel up to build a dynamic web page. In File Save As choose format Single File Web Page (.mht) and in the Save As dialog click the Automate button that lets you set a schedule for when. An RTD Server is explicitly for Excel and won't help you in C#. You could decompile it I suppose and look to see how it gets it data from ThinkOrSwim, but I would imagine they have an API you could use already if you look around more.
![]() Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |