Upgrade from Eikon -> Workspace. Learn about programming differences.

For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 0 0 0

How to use formula builder beta in Excel to retrieve previous day's settlement price?

Hi! I'm trying to import the previous date's settlement price for different commodities futures (I believe the data item is STL), but I don't see that on the data items list. Is there a way I can pull the previous day's settlement price into Excel? I'm able to retrieve the current day's settlement, and I want to be able to easily compare the current settlement with the previous day's one.

#productexcelcommoditiesformula-buildersettlement
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
84.6k 287 53 77

@Heather.Schlitz

Thank you for reaching out to us.

This forum is dedicated to software developers using Refinitiv APIs. For questions regarind desktop applications, such as Workspace and Excel, please contact the helpdesk support team directly via MyRefinitiv.

The helpdesk support team can provide you with the Excel formula which can be used to retrieve the required data.


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.