Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Elektron /
avatar image
Question by jzhao · Jul 31, 2018 at 10:54 PM · market pricemarket dataauctioncloseprice

How to get closing trade price for European markets

We're using ELEKTRON to get European market data. What is the best way to get closing trade price before closing auction? We know there is "OFF_CLOSE" but it comes to late (15 - 30 minutes after close). We're attempting to use CLS_AUC as the last trade price of the day. Is that reliable? what if there is no close auction for the symbol (example, USCO.S)? We know there are different rules for different exchanges. However we'd like to handle it the best we can. thanks,

Tim Smith

People who like this

1 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

7 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Tim Smith · Aug 01, 2018 at 05:22 AM

OFF_CLOSE is updated as fast as we can officially confirm the closing price, so it may be based on a flag from the venue or from the closing price coming down the feed to say we can now snap the close.

CLS_AUC holds the evening auction final uncrossing price, which is often the closing price for European equity Exchanges for liquid stocks. For less liquid stocks there often isn't an auction run, and for some exchanges there isn't an auction process at all. You can use this field and it will update as soon as the final uncrossing price is received though and that is very timly. It will work for a number of the larger stocks on the larger european exchanges eg VOD.L on the LSE or PEUP.PA on Euronext, but not for stocks like SIXH.L that are smaller stocks on the LSE, for example.

In some cases VWAPs, last trades and/or hidden algorithms determine the closing price so what you are proposing could help go some way to get a faster close for some stocks on some exchanges depending on what you want to do or are looking at, but there are a lot of caveats to consider anhd it would have to be a venue-by-venue check.

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
Answer by towim · Jan 23, 2019 at 09:13 AM

And whats the difference between OFF_CLOSE and SETTLE?

Comment
Tim Smith

People who like this

1 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
REFINITIV
Answer by Tim Smith · Jan 23, 2019 at 10:04 AM

Not much difference really. SETTLE is specifically for futures and options and is usually a calculated price by the exchange. In mist cases the OFF_CLOSE and SETTLE are the same, but it might be that a venue publishes a SETTLE and uses an actual traded price or such like for the OFF_CLOSE.

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
Answer by towim · Jan 23, 2019 at 10:41 AM

Many thanks!

Whats the corresponding date and time field for TRDPRC_1? Is that TRADE_DATE and TRDTIM_1?

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
REFINITIV
Answer by Tim Smith · Jan 23, 2019 at 11:07 AM

Well it does depend somewhat on the market, but in general TRADE_DATE and SALTIM (either SALTIM_MS or SALTIM_NS) are the main fields to use with TRDPRC_1

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
Answer by towim · Jan 24, 2019 at 02:47 AM

Thats really confusing. Is there anywhere a overview of which fields are available for a specific ric/market including the meaning of that field?

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
REFINITIV
Answer by zoya.farberov · Jan 24, 2019 at 09:41 AM

@3352edee-c7b3-42de-95ff-77348a2fc138,

To browse the fields that are made available by exchanges, per ric/market, with full descriptions, please go to the front page of developers portal and select

Resources ->Data Model Discovery

or follow this link Data Model Discovery Tool

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
9 People are following this question.

Related Questions

How do I find right MP number that includes all the FIDs of the RIC?

Flags/time periods for suspended/auction trade

trailing junk characters in market price data

State: Closed/Suspect/Login rejected, exceeded maximum number of mounts per user - text: "Exceeded maximum number of mounts per user.

Incorrect timestamps from MP feeds for Taiwan

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges