Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Eikon Data APIs /
avatar image
Question by matthew.ang · Jan 28, 2020 at 04:11 PM · closeprice

Get historical daily prices, 5-15 minutes before close

I would like to obtain daily historical prices, but n minutes before market close (where n is a user-definedd parameter). Would that be possible?

It would be greatly appreciated if I could obtain something similar for prices after market open.

Thank you!

People who like this

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

2 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Gurpreet · Jan 28, 2020 at 06:21 PM

I don't think Eikon provides this data. You can get historical timeseries for the official Close price.

Other products like Datascope Tick History might be better suited for your query. There, you will be able to download all market activity and pick the datapoint at the time of interest.


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 28, 2020 at 09:22 PM

I totally agree with Gurpreet that Tick History product and REST API are better suited for this requirement.

If you only have Eikon and are limited to using Eikon Data API, you may be able to get away with the following hardly graceful approach:

ricList = ['IBM.N','T.N','B.N']  
ek.get_timeseries(ricList, start_date = "2020-01-27T16:15:00",               
   end_date = "2020-01-27T16:25:00", interval="tick",count=1)

instruments on the list IBM.N, T.N and B.N are NYSE, with market close at 4:30 = 16:30, so we literally ask for a single data point 5-15 min prior to market close.

And in order to get it as daily, you may loop through the dates:

from datetime import datetime
from dateutil.rrule import rrule, DAILY

l = list(rrule(DAILY, dtstart=datetime(2020, 1, 2), until=datetime(2020,1,27)))

ricList = ['IBM.N','T.N','B.N']

for i in l: 
    point_start_date = i.strftime("%Y/%m/%d") + "T16:15:00"
    point_end_date = i.strftime("%Y/%m/%d") + "T16:25:00"
    print(point_start_date, '-',point_end_date)
    try : 
        dat = ek.get_timeseries(ricList, start_date = point_start_date,
            end_date = point_end_date, interval="tick",count=1)
        print(dat)
    except :
        print("Not trading ")

20200128.gif (9.4 KiB)
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 >
12 People are following this question.

Related Questions

What is the field for official close price?

I am trying to get daily close price data using RIC list and the eikon get_data api is only able to return result for 2000 odd rics and throws Backend error 400 Bad Request for remaining.Is there a way to get close price data for some 6000 rics?

How do I get the closing prices of the 10-first trading days for all stocks listed at german stock exchange for the last 20 years in eikon?

Close Price Not Available

Pulling TR.CLOSEPRICE weekly

  • 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