Time and Sales Direct Function Call
The user interface can be bypassed by directly creating a Time and Sales function in an Excel spreadsheet cell.
Format:
=ICETimeSales(<symbol>,<Array of Fields>,,Start Date, End date, Index)
The parameters are as follows:
| Start Date Only | Returns that date only |
| End Date Only | Returns that date only |
| Start Date & Index | Returns index values after that start date |
| End Date & Index | Returns index values before that end date |
| Start Date & End Date | Returns the values between those two dates |
| Index Only | Returns the most recent values |
| Start Date & End Date & Index | Returns the values between those two dates and disregards the index value |
Optional Elements:
| TypeFilter= | Sets the main filter |
| PriceFilter= | Sets the price filter or price range |
| ValueFilter= | Sets the value filter or value range |
| SizeFilter= | Sets the size filter or size range |
| BrokerID= | Sets the broker ID filter |
| ConditionsFilter= | Sets the condition code filter elements |
| Precision= | Sets the excel formatting on the output |
| View= | Defines the Short or Long view option |