Options for headings, formatting, and custom functions are specified in the CDXStreamerTM settings interface:
Headings
If you select the headings option, CDXStreamerTM will automatically insert data headings for your selected data fields.
Please make sure you leave an empty row above your index list (if indices are listed in a column), or an empty column to the left of your symbol list (if symbols are listed in a row) to ensure there is space for headings.
Formatting
If you select the formatting option, CDXStreamerTM will automatically format the returned data.
Custom Functions
If you select the custom functions option, CDXStreamerTM will insert the CDX custom function in the worksheet cells:
In this case, the State for 06830 is "CT" obtained by the cell formula
=CDXStreamer(B6,"CDXPremiumZipCodeData", "State")
where B6 is the cell address of the index 06830, CDXPremiumZipCodeData is the data feed and "State" is the requested data field.
If the custom function option had not been selected, there would be no formula; the cell value would simply the state.
The advantage of using custom functions is that it permanently links a worksheet cell to the CDX database. You can also enter this same data manually in other cells. There is no need to run the CDXStreamerTM settings interface again to update cell values. Please refer to the section on the Update command on the CDXStreamer commandbar for further details.