How can i download Tobins q ?

I want to do a esg performance analye and i want to measure the performance with tobins q, but i cant find it by refinitiv eikon

Find more posts tagged with

eikon

performance

esg

workspace

eikon-data-api

refinitiv-dataplatform-eikon

refinitiv-data-platform

#content

Accepted answers

jason.ramchandani01

@christopher.almeling Thanks for your question - you can calculate Tobin's Q ratio using the following:

import refinitiv.data as rd

rd.open_session()

df = rd.get_data(
    universe=['VOD.L'],
    fields=['TR.F.MktCap.date','TR.F.MktCap','TR.F.TotAssets'],
    parameters = {'SDate': -10,'EDate':0,'FRQ':'FY'}
)

df['TobinQ'] = df['Market Capitalization'] / df['Total Assets']
df

I hope this can help.

All comments

jason.ramchandani01

@christopher.almeling Thanks for your question - you can calculate Tobin's Q ratio using the following:

import refinitiv.data as rd

rd.open_session()

df = rd.get_data(
    universe=['VOD.L'],
    fields=['TR.F.MktCap.date','TR.F.MktCap','TR.F.TotAssets'],
    parameters = {'SDate': -10,'EDate':0,'FRQ':'FY'}
)

df['TobinQ'] = df['Market Capitalization'] / df['Total Assets']
df

I hope this can help.

christopher.almeling

Thank you but i dont really unterstand. Do i have to do this in excel?

adrien.dedieu

Hi, I followed your instruction but for 40 different companies. Eventually I got this output but I cannot figure out a way to export the entire table to excel. Any tips. thank you so much

EXPLORE OUR SITES