Using formulas directly

QuoteIN uses the following fundamental formulas to get the data from the feeds. These can be also directly used or pasted in the cells with any valid automated method

P formula (price) =RTD(“quotein.rtd”,, <symbol>, <field>, [<feed>])

Where <feed> is a feed abbreviation parameter and it is optional. It specifies the feed where to request the data. Multiple feeds can be used simultaneously. The available feeds must be previously configured!: (read Configuring data feeds). When omitted the feed that as been configured as the default data feed is used. The P formula gets the current value and starts updates for the given field using the specified feed or the default feed if the <feed> argument has been omitted.

Some examples:

=RTD("quotein.rtd",,"CSCO", "LAST") gets CSCO, LAST using the default feed
=RTD("quotein.rtd",,"CSCO", "LAST", "IQ") gets CSCO, LAST using IQ Data Feed

Listing all the fields available for a feed:

  • right button click on a cell containing a symbol or a QuoteIN formula
  • select menu Full Quote
  • a new window will appear listing all fields for all feeds
  • you may Drag & Drop the field names or the formulas from the window into the spreadsheet