One application of XLInputs is to write data to Excel

See a video demonstration by clicking on the picture below.

In the demonstration, data is being written to a specified Excel workbook with a worksheet named according to the left chart symbol, SPY.

The data being written is Date, Time, Open, High, Low, Close and Volume.

A precise BarID is recorded in the left-most column. This allows the data to be read from Excel by another application.

Even though the BarID is a number, it is written to Excel as text. This is to enable searching for a BarID in Excel, using standard XLInputs functionality, without having to worry about Excel number formatting.

In this way, one can record data to Excel like a database. Extensive record sets may be collected.

We hope you enjoy the demonstration. Let us know if you have any questions.