Willow Tips

Tip #2001-1: Retrieve Real Time and Historical data in one step

Retrieve real time and historical data in one step

This worksheet retrieves TS1 historical data and real time quotes in one step.  Row 8 is filled with real time DDE requests. Row 9 and below are TS1 requests.  When the value in cell C3 changes, all formulas are updated to retrieve the new information.