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.