New posts are disabled while we improve the user experience.

You can browse the site, or for urgent issues, raise a query at MyAccount.

question

Upvotes
Accepted
saravana13493 avatar image
3 ●0 ●0 ●0

how to get historic Settlement price for Florida Gas Zone 3 using python ek.getdata?

Hi,

I am trying to get Florida Gas Zone 3 Historic settlement prices but I couldn't get the data.

I am able to get for HH using the ticker 'NGc1' as in below python code

data = ek.get_data('NGc1', ['TR.SETTLEMENTPRICE.Date', 'TR.SETTLEMENTPRICE'], parameters = {"SDate":"2015-01-01","EDate":str(datetime.now().date())})

But when I try for FGZ-3, which has ticker 'OTGASFIXMc1', the data returning NULL. I'm not sure about this ticker but I could see the data for future prices with 'OTGASFIXMK20','OTGASFIXML20' and so on.

Your help is much appreciated here.

Thanks.

eikoneikon-data-apipythonworkspacerefinitiv-dataplatform-eikonworkspace-data-apipricingsettlement
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.

2 Answers

· Write an Answer
Upvote
Accepted
chavalit-jintamalit avatar image
18.2k ●21 ●13 ●21

Hi @saravana13493

Is this the data you are looking for ?


ahs.jpg (70.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.

saravana13493 avatar image saravana13493

Thank you. This data can be equivalent to the settlement prices which I obtained in other RIC. Though It's weird that the data is not coming through get_data as it worked for other RIC. Thanks a lot for the help.

Upvote
umer.nalla avatar image
25.4k ●90 ●13 ●26

Hi @saravana13493

Given that the API returns valid data for the other RICS, I recommend you contact Eikon support to identify the correct RIC for your requirement and/or query the lack of data for that particular RIC code.

You can contact Eikon Support directly through the Eikon App or via MyRefinitiv. I recommend you create a Content Query for Eikon.

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.

saravana13493 avatar image saravana13493

Thanks for your response. I contacted the Eikon support team and they responded back saying that the RIC 'OTGASFIXMc1' was not in the exchange trade. That's why data it's not there in get_data.


Also, the above response from @chavalit.jintamalit yields an equivalent result which I'm looking for. Thank you all.

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.