Willow Solutions, Inc. Leaf graphic
Willow SOlutions, Inc. Software that thinks like you do
News
Products
Case Studies
Tips
Willow Talk
Clients
Partners
Job Openings
Home

Willow Tips

  
 

Willow Tips are a collection of hints and strategies for working with live financial data within Excel. Tips and tricks… workarounds and shortcuts... You’ll find it here! Bookmark this page and check back often for the latest techniques in getting the most out of your live data access.

Register here to be notified each time a new Willow Tip is posted.

Tip 2003-01 Bloomberg Performance Monitor
Tip 2002-12 A Macro to Calculate Returns from a Trading Strategy
Tip 2002-11 Back Testing a Trading Strategy with a Dynamic Moving Average
Tip 2002-10 Position Monitoring with Excel
Tip 2002-9 A User Defined Function To Find End Of Quarter Date
Tip 2002-8 Using Excel Web Queries to Retrieve Global Historical Data from the Internet
Tip 2002-7 Some Simple but Useful Macros
Tip 2002-6 Creating Candlestick Charts with Excel
Tip 2002-5 Spread Analysis Model for Global Fixed Income Traders
Tip 2002-4 A Better Way to Analyze Options
Tip 2002-3 Using Excel's slope Function to Calculate Beta
Tip 2002-2 Bloomberg's 200 Day Moving Average Field
Tip 2002-1 Merger Arbitrage Tick by Tick
Tip 2001-12 wTable Simplifies the Process of Performing What-If Analysis on Financial Information
Tip 2001-11 Income Statements from the Internet
Tip 2001-10 Continually Collect Bloomberg Tick Data
Tip 2001-9 Bloomberg Currency Monitor
Tip 2001-8 Portfolio Valuation Model for Bloomberg Subscribers
Tip 2001-7 Price and Volume Tick Chart for Bridge Subscribers
Tip 2001-6 FREE: Changing Yield Curve Applet
Tip 2001-5 Using Reuters Real-Time Page Information in Financial Models
Tip 2001-4 Using Excel's Conditional Formatting
Tip 2001-3 Create a scrolling news screen in Excel
Tip 2001-2 Collect tick data on more than one field
Tip 2001-1 Retrieve Real Time and Historical data in one step
Tip 2000-12 FREE Performance Comparison applet
Tip 2000-11 Change instruments and fields on the fly
Tip 2000-10 Forcing Excel to display live data in 32nds
Tip 2000-9 Getting around Reuters TS1 history date limitations
Tip 2000-8 Grab a single historical price
Tip 2000-7 Keep your DDE links running smoothly
Tip 2000-6 Opening Excel workbooks automatically on startup
Tip 2000-5 Handling blank and zero values with live Reuters data
Tip 2000-4 Formatting dates correctly with live data
Tip 2000-3 Make your Excel charts update dynamically
Tip 2000-2 Displaying color coded up/down arrows in Excel with Reuters data
Tip 2000-1 Controlling Futures contract rollover dates with Reuters data
Tip 1999-12 Using dates in Excel
  What's New | Products | Case Studies | Willow Tips | Willow Talk | Clients | Partners | Job Openings | Home
  Terms of UsePrivacy Statement
Willow Solutions, Inc.85 Willow Street, New Haven CT 06511 USA203.777.5634info@willowsolutions.com