Comments:
The Merger Arbitrage Model, Willow Tip 2002-1, monitors the spread between the final merged value and the current merged value.
You are asking whether you can monitor, the spread between the recently announced take over of Pharmacia by Pfizer. I was able to easily enter the instrument codes for Pfizer and Pharmacia and monitor the spread. The instrument code I entered for Pharmacia was PFA which provides you with the price for the ADR which trades on the NYSE.
If you want to calculate the spread for Pharmacia which trades in Sweden, you will need to make some modifications to the model. You will need to get the real time price for Pharmacia in Sweden as well as the real-time price of the local currency. Then convert the price from its local currency into dollars so that you can calculate the spread. To do this you would need to edit the formula in cell N6, which calculates the spread value.
In answer to your second question, the Merger Arbitrage model will work with Bloomberg, Bridge or Reuters DDE formulas. The merger model will not work with Marketmind. If Marketmind has a self updating DDE formula, you can modify the model and replace one of the existing data vendors with Marketmind.
|
