BDP Formula

[qwertzuiop18]

I have a BDP formula from Excel which I want to convert to tia.

What is the way to go there? I want to get the field 'CDS_QUOTED_PRICE' for a CDS Index

Thanks!

[dpsugasa]

This field only has current data for generic tickers in BBG. Use LocalTerminal.get_reference_data() in tia. For CDS tickers, you need to use the value 'BBID' value. You can see this by using the 'DES' function or hovering over the security with your mouse. For example, SNRFIN CDS is 'ITRXESE Index'.

…

On Wed, Oct 17, 2018 at 12:36 PM qwertzuiop18 ***@***.***> wrote: I have a BDP formula from Excel which I want to convert to tia. What is the way to go there? I want to get the field 'CDS_QUOTED_PRICE' for a CDS Index Thanks! — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#47>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AZekSEH5FKUU96PeQ4gynhrivQjQBqZPks5ulxYlgaJpZM4Xjtqc> .

[qwertzuiop18]

Using get_reference_data() I get ann error when using .as_frame()
.as_map() is working
Is this a known issue?

Thanks!

[qwertzuiop18]

The error is
TypeError: reindex() got an unexpected keyword argument "axis"

in the statement

frame = frame.reindex(self.request.fields, axis=1)

[dpsugasa]

Can you post the full code?

…

On Wed, 17 Oct 2018, 12:56 qwertzuiop18, ***@***.***> wrote: The error is TypeError: reindex() got an unexpected keyword argument "axis" in the statement frame = frame.reindex(self.request.fields, axis=1) — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#47 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AZekSE4ArG8l7TSqUly6qdGJx29b25fQks5ulxsAgaJpZM4Xjtqc> .

[qwertzuiop18]

from tia.bbg import LocalTerminal
resp = LocalTerminal.get_reference_data('MSFT US EQUITY', ['PX_LAST', 'GICS_SECTOR_NAME', 'VOLATILITY_30D'])
resp.as_map()

[qwertzuiop18]

Sorry, that was the working one. Now the not working one:

from tia.bbg import LocalTerminal
resp = LocalTerminal.get_reference_data('MSFT US EQUITY', ['PX_LAST', 'GICS_SECTOR_NAME', 'VOLATILITY_30D'])
resp.as_frame()

[dpsugasa]

OK that works for me without issue. Do you have an older version of pandas perhaps?

…

On Wed, Oct 17, 2018 at 1:40 PM qwertzuiop18 ***@***.***> wrote: Sorry, that was the working one. Now the not working one: from tia.bbg import LocalTerminal resp = LocalTerminal.get_reference_data('MSFT US EQUITY', ['PX_LAST', 'GICS_SECTOR_NAME', 'VOLATILITY_30D']) resp.as_frame() — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#47 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AZekSCXQw6rIlwPtGCYKcd-NQND6MgoKks5ulyUsgaJpZM4Xjtqc> .