PTBV is missing to get P/B

MHP · December 2024

I'm trying to get P/B using the API, but I can't get the data even if I request PTBV. Specifically,
I'm using DatastreamPy to get the data with the following code:
ds.get_data(tickers='J:TYMO', fields=['PTBV'], freq="D", kind=0)

I would be grateful if you could tell me how to get the data.

[Deleted User] · December 2024

Hi @MHP ,

I had a test myself on the Navigator:

https://product.datastream.com/browse/search.aspx?dsid=ZRQW955&AppGroup=DSAddin&q=J%3ATYMO&prev=99_

and in Python:

import DatastreamPy as ds


# We can use our LSEG's Datastream API keys that allows us to be identified by LSEG's back-end services and enables us to request (and fetch) data: Credentials are placed in a text file so that it may be used in this code without showing it itself.

ds_username = open("Datastream_username.txt", "r")

ds_password = open("Datastream_password.txt", "r")


ds = ds.DataClient(

    config=None,

    username=str(ds_username.read()),

    password=str(ds_password.read()),

    proxies=None,

    sslVerify=None,

    sslCert=None)


# It is best to close the files we opened in order to make sure that we don't stop any other services/programs from accessing them if they need to.

ds_username.close()

ds_password.close()



# # Alternatively one can use the following:

# import getpass

# dsusername = input()

# dspassword = getpass.getpass()

# ds = dsws.Datastream(username = dsusername, password = dspassword)


ds.get_data(tickers='J:TYMO', fields=['PTBV'], freq="D", kind=1).T