question

Upvotes
Accepted
f.e.m.vdrsanden avatar image
1 ●0 ●0 ●0

Emissions data and estimation method: reporting data

Dear all,

I am using Workspace add-in in Excel. I have several companies from which I would like to retrieve scope 1 and 2 emissions as a time series. I managed to do that using Datastream formula builder. Behind the emissions is an estimation method. I can retrieve this estimation method using the historical data in the formula builder on the left of the panel. When selecting this variable (TR.CO2EstimationMethod), I would like to know when it was computed:

That is, I would like to know when the company reported their values. I would perhaps suggest at the end of a fiscal year or at the end of the year. I can select a 'Date' under the output toggle but not sure which one to select.

Thank you in advance.

Best,

Floor

workspace#product#contenttime-seriesesg
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

wasin.w avatar image   wasin.w

Hello @f.e.m.vdrsanden

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?


If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.

Thanks,


AHS

raksina.samasiri avatar image   raksina.samasiri

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,
AHS

1 Answer

· Write an Answer
Upvotes
Accepted
Jirapongse avatar image
79.2k ●251 ●52 ●74

@f.e.m.vdrsanden

Thank you for reaching to us.

The TR.CO2EstimationMethod field contains several sub-fields. You can list and access those sub-fields via the formula builder, such as TR.CO2EstimationMethod.calcdate.

1699871055835.png

However, you can contact the helpdesk team directly via MyRefinitiv to get that correct fields that can be used to retrieve the required data.

I hope that this information is of help.


1699871055835.png (65.5 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.