Comments:
Bloomberg offers several types of real time links:
1. Multi-cell DDE links
2. Single cell DDE links
3. Multi-cell BLP function (cell referencing)
4. Single cell BLP function (cell referencing)
5. Snapshot
You could use VBA code to enter formulas for the DDE links but I see no need to use VBA code to enter the BLP cell referencing functions.
If you want to automate the process with VBA all you would need to do would be to have your code change the values in the cells which are referenced by the BLP function rather than having the code enter the entire formula.
For further details I suggest you query the Help section which comes with the Bloomberg’s Excel add-in. It provides extensive details on Bloomberg’s various real-time functions.
|
