Historical price-to-book ratio

dusan_miletic

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!

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