Hi Guys,
Urgently need help. I want to know if something is possible or not and if anyone has tried it? I want to find out the high and low of two contract prices by pulling data from bloomberg. Lets say, i want to pull out 30 days of Apple and RIMM stock prices through the vba code, check their spread on each of the 30 days and then only print the high and low of this spread on to my excel. The data pulling, high and low calcs should all happen in the background in vba.
The problem is that we have to track the high/low of a lot of spreads for some analysis. The only better way, I have till now is to create a CIX of this spread and pull in the interval high low of the spread dirrectly from bloomberg. However, this would mean creating a lot of CIX's on bbg and sharing it with everyone in the team/clients etc. If it could all be done through vba in the background, it would make life much more easy.
Any clue?
Urgently need help. I want to know if something is possible or not and if anyone has tried it? I want to find out the high and low of two contract prices by pulling data from bloomberg. Lets say, i want to pull out 30 days of Apple and RIMM stock prices through the vba code, check their spread on each of the 30 days and then only print the high and low of this spread on to my excel. The data pulling, high and low calcs should all happen in the background in vba.
The problem is that we have to track the high/low of a lot of spreads for some analysis. The only better way, I have till now is to create a CIX of this spread and pull in the interval high low of the spread dirrectly from bloomberg. However, this would mean creating a lot of CIX's on bbg and sharing it with everyone in the team/clients etc. If it could all be done through vba in the background, it would make life much more easy.
Any clue?
