Access historical data from other applications

You can write Excel macros to extract data from a HistData file. The HistData program responds to the INITIATE, POKE, and TERMINATE functions within the macro. The POKE function with a keyword (an internal database item) sets the parameters that define a query. After the query is properly specified, run the macro to request the selected historical data from the HistData file.

The following example shows a macro written with VBA:

In the example above, the data to be poked is in Sheet1. The following example shows the data to be poked: