wTable
wTable is a solution for accessing real-time data in Microsoft Excel.
Whenever you change the symbols or fields in your spreadsheet models,
wTable automatically detects your changes and
updates your real-time formulas to match. You can even change data
sources on the fly. If one data vendor is down, simply switch to a back-up,
without losing access to models, calculations, and reports.
|
Description
wTable adds cell-referencing functionality to tables of DDE
formulas in Microsoft Excel. That is, whenever a symbol or field
changes, the DDE formulas automatically change to match the new labels. In addition,
wTable provides the automatic translation of symbols and fields
between different data vendors. Should data from the customer's
primary data vendor be interrupted, the wTable function can automatically
translate all real-time formulas from that vendor to real-time formulas
of a backup vendor. This renders your workbook models data independent,
since it no longer matters if the the workbook is being fed data
from Reuters, Bloomberg, or Bridge.
|
|
|
|
Features
- wTable works for several data sources
including Bloomberg, Bridge, and Reuters.
- Table layout is flexible. Tables can
be organized with a symbol in each row or a symbol in each
column. Field and symbol labels can be on the top, bottom,
left or right side of the table.
- Tables need not be a single rectangular
worksheet range. Multi-area ranges are supported.
- According to the user's preference,
wTable can create tables of single-cell DDE links, DDE arrays
grouped by symbol, or values only data "snapshots".
- Change your wTable data source to
a different vendor to automatically access that vendor's DDE
links in your workbook.
- The customer can specify a default
vendor. This is the vendor whose field names and symbol names
willl be used in the workbook.
- wTable uses a combination of database
lookups and rules to translate instruments from one data vendor
to another.
Performance
wTable provides excellent performance. CPU usage is a fraction
of other real-time data functions. Additionally, wTable does
not interfere with Excel worksheet navigation, data entry,
data copying and pasting, and macro execution the way some
other real-time worksheet functions do.
Technical Details
wTable is comprised of 3 components, wTable.xla, WillowTable.dll,
and wTable.mdb. Most of the code for creating and managing real-time
tables is contained in the XLA. The DLL provides special functionality
that is not allowed in the Excel process. The wTable.mdb file is a
database containing data vendor translation tables. An additional component,
the database editor, allows you do define instrument and field conversion
rules from one vendor to another. This database editor can
be located locally or on a network server for centralizing maintenance.
How It Works
When wTable is pasted into a worksheet cell, the symbols range is
scanned for new symbols. If the symbols are not already in the
wTable database, they are added at this time.
When wTable's data source changes from the default data source,
the database is scanned for stored symbol translations. If a
translation is found in the database, it is used. If a translation
is not found for a particular symbol, the symbol is converted using
translation rules stored in the wTable database. New symbol
translation rules can be written to the database at anytime.
|
|
