|
 |
| |
Willow Solutions partners with Insightful to build
Excel-based solutions using Insightful’s powerful statistical
analytics.
If you’re a sophisticated financial market professional
who is serious about building financial models to analyze
your trading and investment strategies you need access
to powerful statistical functions. With your real-time
and historical data already in Excel you can now call
upon S-PLUS statistical functions to analyze complex
financial relationships. S-PLUS forms a direct link
to Excel. You can move a range of data into S-PLUS application
or you can stay in Excel and call all the powerful statistical
functions offered by S-PLUS.
Click here to read how
to do it.
|
| |
| |
| |
Real Time Data (RTD) function in Office XP
Microsoft Excel XP (also known as Excel 2002
or version 10) provides a new worksheet function
called RTD that allows the retrieval of
data in real time. This function is specifically
designed to access real-time data from market
data vendors, such as Reuters and Bloomberg. In
previous versions of Excel, this was accomplished
by using DDE (Dynamic Data Exchange) or
through custom developed worksheet functions,
such as BLP (Bloomberg) or RTGet
(Reuters). While these methods have been used
successfully, they have limitations and are not
always as robust as one would like. It seems likely
that Microsoft intends to replace DDE with
RTD as the preferred method of bringing
real-time data into Excel. Microsoft claims that
RTD is superior to DDE in robustness,
reliability, and convenience.
Read Willow's initial
analysis of Excel XP's new RTD function.
|
|
| |
| |
| |
Willow Solutions Financial Model Workbook Standards
Many of our spreadsheet applications are used as important
decision making tools. They have to be reliable, user
friendly and optimized for performance. From our work
with spreadsheets we have come up with some standards
and procedures which we use when designing spreadsheet
solutions for our clients. We have summarized the best
of these rules of good spreadsheet design along with
some useful tips and tricks in our Financial Model Workbook
Standards document.
Whether you are an Excel power user or have just begun
to use spreadsheets for financial modeling with real-time
data, you should benefit from the concepts and techniques
discussed in this paper.
Click
here to download this whitepaper.
|
|
|
Willow Solutions Partners with Harco Technology to Reduce Real-Time Data Costs
Willow Solutions frequently partners with
companies that analyze and optimize the use of real-time market
data. One such company, Harco Technology,
provides its clients with products that optimize their expenditure on market data by
evaluating actual consumption as opposed to simply tracking cost. Willow has
worked with Harco to help identify redundant expenditures and reduce
unnecessary costs to significantly impact client's performance and their bottom line.
Click here to read more.
|
| |
|
|
| |
Reuter Tools Available for Excel XP
Willow Solutions developed the Reuters Tools a number of years ago - to make
it easier to access and manipulate real-time and historical data from within Excel.
Although Reuters no longer sells or supports this product, we have received a number
of requests from subscribers who would like to continue to use this product.
These subscribers prefer the simplicity and ease of use of the Reuters Tools, and have
come to rely on the Scheduler, Data Series and Page tools, which are not available in
Reuters more recent Excel offerings.
To meet this demand, Willow Solutions has recently begun marketing an Excel XP upgrade
version for existing users of the Reuters Tools. This new version is identical to the
old one; no new functionality has been added. The only difference is that the tools
now work with Office XP (Excel 10.) If you are interested in purchasing an upgrade
to the Reuters Tools, please contact us at rtools@willowsolutions.com.
For more information on Reuters Tools, visit the Reuter Tools Products page.
|
| |
|
|
| |
Download a FREE Trial Demo of Willow Table
Willow Table (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.
For more information on wTable, visit the wTable Products page.
|
|
