b2 - HongKSU/bloomberg GitHub Wiki

2:18:02 VICTOR LI : I tried to run "=BDH("CUKR1U5 CBIN Curncy ","PX_LAST","20220101,""")" 22:18:07 BLOOMBERG HELP DESK : When downloading CDS price/spread data to Excel, you may experience the following issues:

Errors (#N/A N/A)
Data not matching the Terminal

These issues are due to your pricing source settings. The most common provider of CDS price/spread data on the Terminal is from CMA (CMAN, CMAL, CMAT, CMAI, and CMAQ sources). This data is NOT available in Excel without an additional subscription.

To find an alternative to CMA pricing that is available in Excel, load the CDS in the terminal and run {ALLQ }. Pricing sources like CBIN, CBIL, and CBIT are generated by Bloomberg and free in Excel. These pricing sources are not available on all tickers.

22:19:09 BLOOMBERG HELP DESK : You can use the quick reply buttons above the text entry to respond. 22:19:17 BLOOMBERG HELP DESK : A specialist will assist you soon. 22:19:47 BLOOMBERG HELP DESK : Hi! My name is Aaron Zhu and I'll be assisting you with your inquiry today. 22:20:14 VICTOR LI : I tried to pull out Ukrain CDS data by 22:20:32 VICTOR LI : =BDH("CUKR1U5 CBIN Curncy ","PX_LAST","20220101,""") 22:20:37 VICTOR LI : It does not work 22:20:53 BLOOMBERG HELP DESK : Any error message you see on your end? 22:21:15 VICTOR LI : #N/A start date 22:22:17 BLOOMBERG HELP DESK : =@BDH("CUKR1U5 CBIN Curncy ","PX_LAST","20220101","") comma should be placed after quotation mark. 22:23:35 VICTOR LI : Thank you. It works now. How could I quickly find the ticker of a CDS 22:24:22 VICTOR LI : For example, Price of Sri Lanka CDS in USD beginning 2022 22:27:50 BLOOMBERG HELP DESK : Let me check here. 22:36:56 VICTOR LI : Another question is I can not extract data from excel by using @BDH("CUKR1U1 Curncy ","PX_LAST","20220101","") 22:37:25 VICTOR LI : It shows #N/A N/A 22:37:39 VICTOR LI : But I can see data on terminal (CMA) 22:38:39 BLOOMBERG HELP DESK : Would you mind try other pricing source on ALLQ ? 22:38:49 VICTOR LI : ok 22:39:49 BLOOMBERG HELP DESK : Like =@BDH("CUKR1U1 XXXX Curncy ","PX_LAST","20220101","") where "XXXX" is the PCS code. 22:41:36 VICTOR LI : What does PCS code represent 22:41:58 BLOOMBERG HELP DESK : Pricing source code 22:42:31 VICTOR LI : PCS means the data provider? 22:42:39 VICTOR LI : Like CMA, or ALLQ 22:42:59 VICTOR LI : If I use ALLQ, what is the PCS BLOOMBERG HELP DESK 22:43:44 shared Snag_5bd86e9.png 80 KB Hide Image 22:45:12 BLOOMBERG HELP DESK : The PCS code under ALLQ which allows you to override in excel. Some CDS is not exportable which restricted by the pricing source. Please kindly test on the available sources that showing on your ALLQ ., VICTOR LI 22:48:27 shared BloombergGRIB_2022091742489.gif 43 KB Show Image 22:49:16 VICTOR LI : I can see the price under CMA. I run =@BDH("CUKR1U1 BEST Curncy ","PX_LAST","20220101",""), it gave me compeletly different data 22:49:58 VICTOR LI : In your screenshot, are 747, BET, CTCC, PRXY all data sources? 22:50:55 BLOOMBERG HELP DESK : Yes, but it not be available to you as we might have different privileges. Please kindly check your ALLQ page for availability. 22:51:34 BLOOMBERG HELP DESK : Here's the steps on searching CDS tickers:

To search for a CDS ticker, from SECF :

Select "Fixed Income" from the Category drop-down menu. Click the "CDS" sub-tab. In the amber "Search" field at the top-left of the screen, enter a company name or ticker, then press .

A list of matching CDS tickers appears. Use the filter fields, such as "Tenor" and "Curr", to narrow your search results. 22:51:51 VICTOR LI : I have 2 sources. I tried the code by using the two sources. They gave different historical data 22:56:41 BLOOMBERG HELP DESK : Because the pricing source are different. Therefore, the methodology they use might different.

For CMA (CMAN, CMAL, CMAT, CMAI, and CMAQ sources). This data is not available in Excel without an additional subscription. You may check CMA for more reference. 22:57:15 VICTOR LI : Is CBIN also a PCS? 22:57:46 BLOOMBERG HELP DESK : Yes, pricing sources like CBIN, CBIL, and CBIT are generated by Bloomberg and free in Excel. These pricing sources are not available on all tickers. 22:58:20 VICTOR LI : What are the difference between CBIN and ALLQ 22:58:36 BLOOMBERG HELP DESK : ALLQ is a function 22:58:56 BLOOMBERG HELP DESK : CBIN is a pricing source code in ALLQ function. 22:59:29 VICTOR LI : CMAN is also a PSC? 22:59:39 BLOOMBERG HELP DESK : Yes 23:00:46 VICTOR LI : Could you please call me to explain these , I am so confused 23:01:01 BLOOMBERG HELP DESK : Sure. Is "+1-330-319-3278" the correct number for me to call you? 23:01:06 VICTOR LI : yes 23:02:24 BLOOMBERG HELP DESK : Sure, calling from Shanghai. 23:02:38 VICTOR LI : thanks 23:03:51 VICTOR LI : Please call again 23:03:54 BLOOMBERG HELP DESK : Sure 23:04:59 BLOOMBERG HELP DESK : Seems unable to connect you, do you have any other number? 23:05:29 VICTOR LI : What is the response you heard from my phone 23:06:41 BLOOMBERG HELP DESK : It says you are not available. (like not picking the call) 23:07:04 VICTOR LI : I have turned "no disturb off" now 23:07:10 VICTOR LI : Please call me again. Thanks 23:07:16 BLOOMBERG HELP DESK : Okay 23:34:45 BLOOMBERG HELP DESK : Bloomberg has created the BEST CDS source to provide the broadest possible price coverage while retaining the highest quality pricing available using Bloomberg data. The source is comprised of an extensive list of other Bloomberg CDS sources selected based on a preference waterfall. Each CDS ticker is independently evaluated in a manner designed to find the most recent and most reliable price. Specifically, BEST provides the freshest available price from a list of tiered price sources. The bottom tier uses theoretical pricing sources from Bloomberg’s extensive coverage for CDS sector curves and CDS modeled spreads from Bloomberg’s Merton structural approach to default risk. 23:40:59 BLOOMBERG HELP DESK : Thanks for your time on the call. Your reference number for this chat is H#1251620048. 23:41:43 VICTOR LI : Thank you, Arron! 23:42:01 BLOOMBERG HELP DESK : My pleasure. 🙂