Tip #2001-7: Price and Volume Tick Chart for Bridge Subscribers
Bridge Systems allows you to retrieve into Excel, real-time,
intra-day trading information with the entry of a single array formula. You do not need to collect the information,
as you need to do with some of the other data vendors. This feature greatly simplifies the process of getting price
ticks or time and sales data. For example, if you are a Bridge subscriber, and you would like to get
the time, price and trade volume for the last 10 trades of IBM into an Excel worksheet:
- Select the range of cells where you want
to retrieve the data, lets say B2 – D11.
- Enter the array formula:
| =BDDE|HIST!'US;IBM.INT=TICK.PRDS=10.QE=TM,LS,SZ' |
Remember after you finish typing an array formula, you need to press
Control Shift Enter for the formula to display properly.
The Bridge DDE historical formula has features similar to all DDE
formulas. It is composed of Application and Topic (BDDE, HIST).
The remainder of the formula contains the instrument code along
with some switches that determine what will be retrieved. For example,
INT=TICK means that every tick will be displayed. If you want to
retrieve the price and volume for the last 10 days for IBM you would
change TICK to DAY and press Control Shift
Enter and you would get the price and volume for the
last 10 days.
We created a mini-app that uses Bridge’s intra-day
historical array formula to retrieve real-time, updating price and volume
information. We used Excel’s powerful charting tools to create a price and
volume chart which updates automatically when the data changes. We automated
the process with some macrocode which automates the process of editing the
array formulas. All you need to do is type a new instrument code in a cell.
With Bridge you need to enter the country code and a semi colon and then the instrument code e.g.
US;IBM, rather than just IBM.
If you are a Bridge subscriber, you can download a sample worksheet.
Select Yes to update the links
and you will be able to use the application as a real-time working
model which updates continuously.
Contact us if you would like to employ our services to
help you enhance this model or help you design customized application using
Bridge data.
|
