best method for getting latest closing price (US Equities)
I am trying to find out what is the best solution for getting the latest closing price for US Equities (preferably for XNAS). The requirement is that:
- One instrument is requested at a time.
- Request time can occur 0-24, even weekends.
- Closing price must be the last closing price available at the request time for the selected RIC. i.e.:
- 1) responses for requests initiated during market holidays must contain the last market closing price.
- 2) responses for requests initiated before market close time must contain the closing price of the previous day.
- 3) responses for requests initiated after market close time must contain the closing price of the actual day.
- We found that RKD GetInterdayTimeSeries_1 with DAILY Interval could be an appropriate solution but is there a better solution for this query?
- If this is the suggested solution, would it fulfil the requirements detailed in 1)-3). For example, what are the requred start and end times to set up to get a closing price for a select quote if the day of request is weekend or a national holiday? Do you have to manage a calendar on your side and ask only the required time period or simply ask for a period of one week and get the latest data from time series?
thanks for the help!
Best Answer
-
Hello @ttarnai1
I am not a data expert but I suggest you check the RKD API - TimeSeries - Interday V5 Service page on the RKD API Product website.
You can find the Data Coverage guide document, Developer Guide, interactive API playground for both SOAP WebServices and HTTP JSON interfaces.
To access the interactive API playground, please click the "DEVELOP" tab.
Please note that the Interday V5 service supports the following data fields:
- OPEN: Opening price of the period.
- HIGH: Highest price of the period.
- LOW: Lowest price of the period.
- CLOSE: Closing price of the period.
- CLOSEYIELD: Closing Yield value of the period.
- VOLUME: Number of shares transacted during the period.
- BID: Bid price of the stock.
- ASK: Ask price of the stock.
- VWAP: volume weighted average price
0
Categories
- All Categories
- 6 AHS
- 37 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛