Functions

As you will notice, the quote table is generated similar to an Excel function.  In ICE XL, the quote function is a string comprised of the following required elements as well as optional elements.

Required Elements

=ICEQuotes( <Array of Symbols>,<Array of Fields>)

  • The array of symbols and/or fields must be a standard Excel range, e.g. A1:A20
  • Example: 
    =@ICEQuotes(B3:B6,C2:F2)


Optional Elements
=ICEQuotes( <Array of Symbols>,<Array of Fields>, “OptionalElement1”, “OptionalElement2”, etc)

  • Example: 
    =@ICEQuotes(B3:B6,C2:F2, "Title=My Quotes","Snapshot=True")

Optional Element Parameters

Title= Any string that follows will be set as the title for that function
Snapshot=
  • TRUE returns downloaded values
  • FALSE (or omitted) returns default live values
Plot= 
  • Vertical returns a vertical plot
  • Horizontal (or omitted) returns default horizontal plot
UseReference= 
  • False turns off any cell referencing
  • True (or omitted) returns default cell referencing