The quote function is simple, powerful, and flexible. The function string is comprised of required elements as well as optional elements.
Required Elements
=QuoteIDC( <Array of Symbols>,<Array of Fields>)
The array of symbols, or fields must be a range in Excel, e.g. A1:A20
Optional Elements
=QuoteIDC(<Array of Symbols>,<Array of Fields>,”Optional Element1”,”Optional Element2”,…,”Optional ElementN”)
The quote function can take optional elements that effect output, formatting, and other aspects of the request. The optional elements for the quote table are listed below. Please note that all optional elements must be enveloped by double-quotes, e.g. =QuoteIDC(A1:A2,B1:B2,”Title=My Quotes”,”Snapshot=True”)
Optional Elements |
|
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 |