question

Upvotes
Accepted
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.

1 Answer

· Write an Answer
Upvotes
Accepted
81.3k 267 53 76

@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.