New posts are disabled while we improve the user experience.

You can browse the site, or for urgent issues, raise a query at MyAccount.

question

Upvotes
Accepted
HeikoRR avatar image
35 ●3 ●3 ●1

Bloomberg R user switching to Eikon/eikonapir - sample R scripts/field mappings

R, eikonapir

I switched from many years as Bloomberg R user to Eikon, installed the R eikonapir library and used get_timeseries() to retrieve historical data mainly equity related.

My problem: Mapping of Bloomberg fields to Eikon. I use the Eikon Excel formula builder, but these fields don't seem to work. Example, in Excel Eikon shows for Closing Price the field TR.PriceClose but there is no data using (only using get_data() for last price).

get_timeseries(list("MSFT.O","VOD.L"),

list("TIMESTAMP","TR.PriceClose"),

"2020-01-01T00:00:00",

"2020-01-10T00:00:00")

Replacing TR.PriceClose with Close does work:

get_timeseries(list("MSFT.O","VOD.L"),

list("TIMESTAMP","CLOSE"),

"2020-01-01T15:04:05",

"2020-01-10T15:04:05")

Question: Does anyone has a reasonable R sample script downloading the usual items, like volume, 30 days ADV, shares outstanding, PE ratios

Many thanks!

eikoneikon-data-apipythonworkspacerefinitiv-dataplatform-eikonworkspace-data-apireikon-data-api-rsample-code
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.

2 Answers

· Write an Answer
Upvotes
Accepted
Jirapongse avatar image
87.8k ●294 ●53 ●79

@HeikoRR

When using the TR function in Eikon Excel to retrieve the data, you need to use the get_data method in the R eikonapir library to get the same data. For example:

data_frame2 <- get_data(list("MSFT.O","VOD.L"), 
                        list("TR.PriceClose.Date","TR.PriceClose","TR.Volume","TR.SharesOutstanding","TR.PE","TR.AvgDailyVolume30D"),
                        list("Frq"="D","SDate"="2020-01-01","EDate"="2020-01-10"))
data_frame2

However, you need to contact the Eikon Excel support team via MyRefinitiv and ask for fields that can be used with the TR function to get the required data.



1584932286553.png (46.2 KiB)
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
HeikoRR avatar image
35 ●3 ●3 ●1

Many thanks - works perfectly!

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.