Posts Tagged ‘RTD servers’
Creating an Excel Stock Information RTD server using the Yahoo Finance API
Pieter van der Westhuizen | September 25th, 2014
In today's article, we'll write an Excel RTD server that returns the latest stock prices and other information. In case you're not familiar with Excel RTD servers, it is used to communicate with a real-time data source, such as stock quotes and provide the user with a constant flow of changing data... Read the rest of this entry →
Excel 2013 add-ins in Visual Studio 2012: Getting started for VSTO developers
Pieter van der Westhuizen | April 8th, 2013
In this article we'll have a look at how you, as a VSTO developer, can get started developing add-ins for Excel using Add-in Express and Visual Studio 2012.... Read the rest of this entry →
Office 2013 add-ins & Visual Studio 2012: Getting started for VSTO developers
Pieter van der Westhuizen | March 18th, 2013
So you've been using Visual Studio Tools for Office (VSTO) for some time now and luckily you've discovered a better and easier way to develop Office add-ins, namely Add-in Express. Ready to start a new happier life of creating awesome Office Outlook extensions you excitedly fire up Visual Studio and hit File, New Project... Read the rest of this entry →
Building integrated Excel extensions: COM Add-in, RTD Server and XLL in one C# project
Pieter van der Westhuizen | June 12th, 2012
Add-in Express for Office and .net makes building Microsoft Excel extensions easy. We provide you with a collection of tools and components to get that world-class Excel add-in out of the door and into the world in record time.
... Read the rest of this entry →
How to use Evaluate to invoke an Excel UDF programmatically
Andrei Smolin | October 3rd, 2011
Whether your UDF is a VBA macro or an Excel Automation add-in or even an XLL add-in, you can invoke any method it provides to the user. To do this, you need to get or create an Excel.Application object and invoke ExcelApp.Evaluate() supplying it with the correct syntax for your method and its parameters.... Read the rest of this entry →
Video: Building an Excel RTD server
Ty Anderson | September 8th, 2011
Using Add-in Express you have the tools you need to rapidly start building a Real-Time Data (RTD) Server for Excel. This video shows you to use ADX to build a simple RTD... Read the rest of this entry →
Creating integrated Office solutions with Add-in Express
Pieter van der Westhuizen | June 7th, 2011
Add-in Express enables you as a developer to quickly and easily create, not just MS Office add-ins but also Excel XLL add-ins, Excel Real-time data (RTD) servers and smart tags. In this post I'll demonstrate how you could include all this functionality in one Visual Studio project. Start by creating a new ADX COM Add-in project in Visual Studio... Read the rest of this entry →
Building a Real-Time Data server: Utility functions; building help, part 12
Maurice Calvert | January 27th, 2011
Hoping again for re-use, I created a little utility library which contains some general-purpose functions that you may find useful... Read the rest of this entry →
Building a Real Time Data server: Changing the Excel RTD Throttle Interval, part 11
Maurice Calvert | January 26th, 2011
By default, Excel won't call RefreshData more often than every 2 seconds (the Throttle Interval). For financial data that's arriving fast and furiously, this is reasonable, but for GeodesiX it makes the interface seem rather slow... Read the rest of this entry →
Building a Real Time Data server for Excel: Creating the Setup project, part 10
Maurice Calvert | January 25th, 2011
In part 2: Avoiding VSTO, I lauded Add-in Express for having such an easy interface to create a Steup Project. I stand by what I said, but GeodesiX goes a fair bit further than just implementing a few Excel UDFs. The problem that have to address is... Read the rest of this entry →
Building a Real Time Data server: Embedding a GoogleMap page in an Excel Task Pane, part 9
Maurice Calvert | January 24th, 2011
Another short subject, but worthy of a few remarks. The GoogleMaps taskpane is implemented in a separate project, hopefully re-usable. The task pane is created in Geodesix.AddinModule #27#, which also contains the event handlers
... Read the rest of this entry →
Building a Real Time Data for Excel: Avoiding Application Domain misery, part 8
Maurice Calvert | January 21st, 2011
This is a short but important subject (assuming you're using Addin Express for Office and .net). There are 3 types of Add-in Express module used in Geodesix
... Read the rest of this entry →
Building a Real Time Data server for Excel: Talking to the GoogleMaps APIs, part 7
Maurice Calvert | January 20th, 2011
This subject is already extremely well documented here, so I'll just point you to the relevant code. The call to GoogleMaps is at #7# in Geodesic.Resolve.Resolve... Read the rest of this entry →
Building an Excel Real Time Data server: Providing easy-to-read function names, part 6
Maurice Calvert | January 19th, 2011
Geeks like us have no qualms about typing =RTD("Geodesix.RTD",,"geocode","status","Tokyo") in an Excel cell to get a value. Normal people find this a bit clumsy, and it would be nice to humour them. Excel provides a way to this quite simply
... Read the rest of this entry →
Building a Real Time Data: Excel, multithreading and callbacks, part 5
Maurice Calvert | January 18th, 2011
Excel's muilti-threading is a strange beast. As we saw in part 4: Building a Real Time Data for Excel: Architecture, Excel calls happily but won't receive unsolicited calls. This is perfectly reasonable once you understand the Windows message pump, if the UI thread is waiting on a Dialog box, it can't accept other work... Read the rest of this entry →
Building a Real Time Data for Excel: Architecture, part 4
Maurice Calvert | January 17th, 2011
This is part 4 of the tutorial that describes the techniques necessary to build an Excel RTD server. If you have just come to this page, I suggest you read all parts in order, here is Building a Real Time Data for Excel, part 1. Putting together an RTD server is not particularly difficult… once you […]... Read the rest of this entry →