Generate historical adjusted closing prices in R

Hi,
I am using the R package to pull data and would like to pull historical data fields for specified dates like adjusted closing prices and volumes. I have tried:
get_timeseries(list("MSFT.O","VOD.L","IBM.N"),list("*"),"2016-01-01T15:04:05","2016-01-10T15:04:05","daily")
and included the TR.PriceClose field but it fails.
Thanks.
Best Answer
-
Typically, the get_timeseries method supports HIGH, CLOSE, LOW, OPEN, COUNT, and VOLUME fields.
It doesn't support TR.xxx fields. To retrieve TR.xxx fields, you need to use the get_data method.
get_data(list("MSFT.O","VOD.L","IBM.N"),
fields=list('TR.ClosePrice.Date','TR.ClosePrice'),
parameters=list('SDate'='2016-01-01','EDate'='2016-01-10'))
0
Answers
-
May I ask:
(i) what package are you using? The ahmedmohamedali one, or the GreenGrassBlueOcean one? Please use the latter, because it is the only one being kept up to date.
(ii) what error message are you getting?
(iii) is your instance of Eikon or Workspace running? Because it needs to be in order for this Eikon Data API to work.
(iv) are you able to collect this data in CodeBook? This last question is not necessary for us to investigate your issue, but it would be preferable to know in aiding said investigation.
0 -
Thank you for your feedback. I have one last question - how would I pull ESG scores with the date the score was updated and for which financial period?
0 -
You can use the get_data method to pull ESG scores.
For example:
get_data(list("MSFT.O","VOD.L","IBM.N"),
fields=list('TR.TRESGCScoreGrade.Date','TR.TRESGCScoreGrade'),
parameters=list('SDate'='0','EDate'='-4'))The output is:
You can use the Data Item Browser tool to view all available fields in the ESG category.
0 -
Thank you. I have switched over to the Refinitv package - would I use the EikonGetData function to pull the same as above? Could you please repeat the example with the Refinitiv package?
0 -
@Charlotte.vanTiddens
Please let me know which Refintiiv package you are using.
0 -
0
-
I think it is https://github.com/GreenGrassBlueOcean/RefinitivR.
The code looks like this:
library(Refinitiv)
Eikon <- EikonConnect(Eikonapplication_id = "<app key>", Eikonapplication_port = 9060L)
data <- EikonGetData( EikonObject = Eikon, rics = c("MSFT.O","VOD.L","IBM.N")
, Eikonformulas = c('TR.TRESGCScoreGrade.Date','TR.TRESGCScoreGrade')
, Parameters = list('SDate'='0','EDate'='-4')
)
data$PostProcessedEikonGetDataThe output is:
0 -
0
-
I checked in Eikon and found that it is Period End Date. However, you need to contact the content support team via MyRefinitiv to confirm it.
There are other fields available in the TR.TRESGCScoreGrade field. You can use the Data Item Browser tool to view all available fields in the ESG category.
You can compare the data with Eikon to ensure that all score data is pulled or contact the content support team to verify it.
0
Categories
- All Categories
- 3 Polls
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 685 Datastream
- 1.4K DSS
- 620 Eikon COM
- 5.2K Eikon Data APIs
- 10 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 254 ETA
- 557 WebSocket API
- 38 FX Venues
- 14 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 23 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 276 Open PermID
- 44 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 22 RDMS
- 1.9K Refinitiv Data Platform
- 662 Refinitiv Data Platform Libraries
- 4 LSEG Due Diligence
- LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 27 DACS Station
- 121 Open DACS
- 1.1K RFA
- 104 UPA
- 193 TREP Infrastructure
- 229 TRKD
- 917 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 90 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 46 中文论坛