Historical price-to-book ratio

dusan_miletic · 2025-03-22T19:28:24+00:00

There was an error rendering this rich post.

Hi,
I'm using the following code to import historical data for a stock in Python:

ld.get_data(universe = "ABBN.S", fields = ['TR.CLOSEPRICE.DATE', 'TR.CompanyMarketCapitalization'], parameters = {'SDate': Start_Date, 'EDate': End_Date, 'Frq': 'D'})

Now I would like to import the price-to-book ratio.
What is the best way to get it — ideally not per share, but the total price-to-book for the company?

Thanks in advance!

Find more posts tagged with

#content

Accepted answers

All comments

raksina.samasiri

Hi @dusan_miletic ,

Thank you for your participation in the forum. However, the moderators on this forum do not have deep expertise in every type of content available through LSEG products. Such expertise is available through the Helpdesk. If the Helpdesk can show you how to retrieve the data using =@TR formula in Workspace Excel, then the moderators on this forum can help you translate it into get_data method in the Data Library call. The Helpdesk can be reached via https://myaccount.lseg.com/content/mytr/en/helpandsupport.html

EXPLORE OUR SITES