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 1 4 8

deals screener time record was added field

hi, is there a field in the deals screener for the timestamp the deal was added to the refinitiv dataset?

i know about

"TR.MnAAnnDate"

and i am looking for something more precise.

if there isn't a timestamp for date(time) added, maybe i can use a sequence number or something?..

thanks

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

<AHS>

Case 11158112 is closed with the following resolution:

Upon working with our Specialist group I was advised that we do have a field called " Date Deal was Last Updated " on the SCREENER app and that is the closest we have

Data item: TR.MnADateDealWasLastUpdated 

Hi @mjg,

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

Hello @mjg

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

@mjg

Hi,

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

Thanks,

AHS

Upvote
Accepted
14.2k 30 5 10

hi @mjg ,

as a reference, here's the message from the support team in the ticket,

Upon working with our Specialist group I was advised that we do have a field called " Date Deal was Last Updated " on SCREENER app and that is the closest we have

Data item: TR.MnADateDealWasLastUpdated

Hope this helps

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.

Upvotes
5.7k 21 2 6

Hi @mjg ,


Have you had a look for this field on the DIB? (Please try and opening that link in an incognito browser window if it fails otherwise. We were made aware of an issue viewing this video resolved via incognito browsing.)

If that tool does not provide you with the answer you are after, please note that this forum is for API questions only, but you can ask content questions, such as this one, on my.refinitiv.

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.

Upvotes
1 1 4 8

isn't the place to look for DEALS SCREENER potential valid fields inside the DEALS SCREENER window in eikon, specifically the 'data item library'?


i thought the DIB isn't applicable to finding valid fields for a SCREENER or DEALS SCREENER. am i mistaken?

this is where i think valid fields for a deals screener exist:


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.

Upvotes
1 1 4 8

i am trying to post a 500 kb screenshot that is too large

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.

Upvotes
1 1 4 8

i tried a 200kb jpeg and it says 'parsing response failed' lol

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.

Upvotes
5.7k 21 2 6

Hi @mjg ,


My apologies for the image attaching issues you are experiencing. I have risen it to our Forum Website team.

Would you have an example of an instrument for which you are looking for the 'timestamp the deal was added'?

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.

Upvotes
1 1 4 8

for example yesterday with musk and twitter i get back from the screener

instrument:


154087529501

date announced:


4/4/2022

target perm id:


4296301199

sdc deal no:


3898639020




instrument target:


4296301199

do these datapoints help you answer my question about the 'record created time'? how do i know if a deal is NEW? and WHEN it became new?

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.

Upvotes
1 1 4 8

hello? can someone help?

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.

Upvotes
5.7k 21 2 6

Hi @mjg,


Is the field you're after 'Date Deal was created in SDC Database'?

If not, please note that this forum is for technical API-related questions, and this question is content-related; for such inquiries, please reach out to the helpdesk.

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.

Upvotes
1 1 4 8

i am looking for a piece of data - either a timestamp of last update, or some kind of sequence number, i am looking for the most specific data i can find that can tell me EXACTLY how new or in what order the record was added

i imagine sometimes a single deal is updated multiple times in the same day. if there is a sequence number or a timestamp, then i can tell if the record has been updated

can you find such a field for me? i have tried and can't. if you can't find such a field, can you recommend a way to programmatically understand if anything has been updated in the record to know if something has changed?

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.

Upvotes
5.7k 21 2 6

Hi @mjg,


This forum is for technical API questions. Since this is a content question, please reach out to the helpdesk.

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.

Upvotes
14.2k 30 5 10

hi @mjg,

As suggested by Jonathan, regarding content questions, as this forum is dedicated to software developers using Refinitiv APIs and the moderators on this forum do not have deep expertise in every bit of content available through Refinitiv products, which is required to answer content questions such as this one.

The best resource for content questions is the Refinitiv Helpdesk, which can be reached by either calling the Helpdesk number in your country or submitting a new ticket to the support team via MyRefinitiv.

However, for this case, ticket number 11158112 was raised on your behalf and the support team is going to contact you soon.

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.