Posted: Wed Nov 08, 2006 1:01 pm Post subject: downloading historical index member data from bb using excel
hi
I want to retrieve historical data on index members and related weights from bloomberg in excel. however, the function objBloomberg.BLPGetHistoricalData does not accept the field reference "INDX_MEMBERS" or s.th. similar.
does anyone know how to circumvent this problem and how to download such data using excel / vba ?
Using "MEMB", I can only download the [b]current[/b] member list and weights. But I cannot download the [b]historical [/b] member lists and weights (e.g. over the last 12 months) since one cannot use "MEMB" with blph (history).
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum