Using Streaming Data

A number of services offer live streaming data into your spreadsheet. These services use a technology such as DDE to automatically pipe information directly into cells in your worksheet. Although these services require a monthly subscription, it is pretty amazing to watch your spreadsheet automatically change every second with real-time stock prices.

These real-time DDE services typically use a formula that identifies the external .exe program, then a pipe character (|), and data for the external program to use.

In Figure 14.6, the formula in cell A2 is calling the MktLink.exe program to return price data for stock symbol AA.

Figure 14.6

The MktLink.exe service allows live streaming data to be piped into cells on the spreadsheet.

0 0

Post a comment