Q. I installed CDXStreamer™ but don't see the toolbar when I start Excel. Where is it?
-
In Excel 2007 the CDXStreamer™ toolbar is under the "Add-ins" menu. In other versions the toolbar displays directly. Please see our support article
CDXStreamer Toolbar Location in Excel 2007.
How does the CDXStreamer™ interface work?
-
After starting Microsoft Excel, click the CDXStreamer™ button located on the CDXStreamer™
toolbar to request data. In Excel 2007 this toolbar is under the "Add-ins" menu. The CDXStreamer™ interface appears:
Just input your requirements - data feed selection, the starting cell address of your index list (such as five digit zip codes),
formatting options, data variables to import - then click on “Get Data” and
CDXStreamer™ does the rest. Here is the result:
You can also specify the use of custom functions that automatically update the
data with one click, and you can save your CDXStreamer™ settings for future
use.
The CDXStreamer™ toolbar loads automatically in Excel so you can continue to easily access the interface and other
functions directly from the worksheet.
Q. What do you mean by the term "index"?
-
CDXStreamer™ uses a single unique identifier to refer to a specific data item.
Using the Zip code feeds, enter the 5 digit zip code. For state data use the two character abbreviation and for area codes using the 3 digit numerical value. Enter all the indices you wish to retrieve in either rows or columns in your spreadsheet and then run CDXStreamer to retrieve the associated data.
If your zip code starts with a zero enter start your entry in Excel with an apostrophe "'" to treat the value as a string.
Q. What’s the difference between CDXStreamer™ and CDXZipStream™?
-
CDXZipStream™ is dedicated to the analysis of zip code and other demographic data and contains advanced geocoding functions. The data is a one time purchase along with the product and stored locally on your computer. CDXStreamer accesses demographic and other data thru web services, is monthly subscription based, and offers additional web services.
CDXZipStream is recommended for use in corporate environments where security restrictions do not allow access to web services or where there are other firewall issues.
Use CDXStreamer where this isn’t an issue and you need the most accurate data available on a monthly basis. If you just need a quick answer to a small set of data CDXStreamer is also a lower cost alternative. You can simply cancel the subscription after use.
Since CDXZipStream stores data locally it is a much faster solution if you are doing bulk data requests at one time. It’s also lower cost if you expect to use the product continuously over a long period of time. CDXZipStream also includes Zip Code Distance and Radius calculations that CDXStreamer does not support because of the lack of a local database. Data updates are available as separate purchases when you need them.
Q. How does CDXStreamer™ link directly to a data source?
-
CDXStreamer™ can link directly to a data source by inserting “custom functions”
in Microsoft Excel wherever you need data. Custom functions provide a dynamic
link to the source of data so that data is automatically refreshed whenever the
application is opened. Custom functions eliminate the need to repeatedly run
CDXStreamer™ settings or manually refresh the data, and are recommended for
instances where maintaining a data history is not required.
Q. What data does CDXStreamer™ provide?
-
CDXStreamer™ returns the following data feeds:
- CDXZipCodeData - available fields:
- CDXPremiumZipCodeData - available fields:
- 109thCongressionalDistrict
- 109thCongressionalLandArea
- CDXStateData - available fields:
- CDXAreacodeData - available fields:
- CDXWhoisLookup - available fields:
Q. What are the system requirements?
-
CDXStreamer™ is compatible with Excel 2002,2003(XP),2007 for Windows. Please contact
us about customizing CDXStreamer™ for other Microsoft Office applications.
Q. How do I get started with CDXStreamer™?
-
Download a free 7-day trial of
CDXStreamer™ now for instant access to all our data.
Please contact our technical support department if you have any questions about CDXStreamer™: