I'm new to Bloomberg terminals (a paper I'm reading uses data from a terminal - my first exposure) and I'm having trouble figuring out how to download a few different time series: (1) daily closing exchange rates for a set of currency pairs for both London and New York, and (2) daily closing government yield data, again for both London and New York.
The paper I'm reading refers to "bloomberg dataseries" in the following formats (using Australia as an example):
- AUD/USD for London close: "AUDUSD CMPL Curncy".
- AUD/USD for New York close: "AUDUSD CMPN Curncy".
- AUD for London close: "ADSW2 CMPL Curncy".
- AUD for London close: "ADSW2 CMPN Curncy".
I know that CMPL and CMPN refers to the pricing source (Composite London, and Composite New York, respectively). However, I'm having trouble finding any reference as to how to download these particular data series, using the Bloomberg Excel add-on or otherwise. Any help would be appreciated.