How do I extract data fields from a RIC using the correct TR field names in

Shubhashree

I want to extract the following Fields from a RIC via Python / API:
DESIRED_FIELDS = {
    "TR.PriceClose":         "Price",
    "TR.Price52WeekHigh":    "52W_High",
    "TR.Price52WeekLow":     "52W_Low",
    "TR.Volume":             "Volume",
    "TR.PE":                 "PE_TTM",
    "TR.EVToEBITDA":         "EV_EBITDA",
}

 

TECHNICAL_FIELDS = {
    "TR.PriceTo52WkHigh":    "Pct_vs_52W_High",
    "TR.PriceEMA50D":        "EMA_50",
    "TR.PriceEMA200D":       "EMA_200",
    "TR.PricePctDiff200DMA": "Pct_vs_200d_MA",
    "TR.RSI":                "RSI_14",
    "TR.MACD":               "MACD",
    "TR.MACDSignal":         "MACD_Signal",
    "TR.MACDHistogram":      "MACD_Hist",
    "TR.AverageVolume30D":   "Avg_Vol_30D",

 

but I do not get correct values. Is the "TR.." maybe incorrect for my desired fields?

 

 

Here is the list:

  OK  CH1430134226 -> AMRZ.K

  OK  US6974351057 -> PANW.O

  OK  US58933Y1055 -> MRK

  OK  US0326541051 -> ADI.O

  OK  US9581021055 -> WDC.O

  OK  US5951121038 -> MU.O

  OK  AU000000BHP4 -> BHP.AX

  OK  US8835561023 -> TMO

  OK  DK0062498333 -> NOVOb.CO

  OK  GB0002634946 -> BAES.L

  OK  GB00BVZK7T90 -> ULVR.L

  OK  US78392B1070 -> HYNIX.LU

  OK  US0382221051 -> AMAT.O

  OK  US7707001027 -> HOOD.O

  OK  US5024311095 -> LHX

  OK  US03831W1080 -> APP.O

  OK  US8740391003 -> TSM

  OK  US4523271090 -> ILMN.O

  OK  GB00B2B0DG97 -> REL.L

  OK  DE0008430026 -> MUVGn.DE

  OK  DE0006231004 -> IFXGn.DE

  OK  CA65340P1062 -> NXE.TO

  OK  NL0010273215 -> ASML.AS

  OK  US88160R1014 -> TSLA.O

  OK  US7475251036 -> QCOM.O

  OK  US81762P1021 -> NOW

  OK  FR0000044448 -> NEXS.PA

  OK  US0320951017 -> APH

  OK  US92532F1003 -> VRTX.O

  OK  US1667641005 -> CVX

  OK  US5380341090 -> LYV

  OK  US1011371077 -> BSX

  OK  CH0012214059 -> HOLN.S

  OK  US5324571083 -> LLY

  OK  US92840M1027 -> VST

  OK  US1725731079 -> CRCL.K

  OK  US81141R1005 -> SE

  OK  DE0007236101 -> SIEGn.DE

  OK  FR001400X2S4 -> ATOS.PA

  OK  US1273871087 -> CDNS.O

  OK  US11135F1012 -> AVGO.O

  OK  US58155Q1031 -> MCK

Jirapongse

@Shubhashree

Thank you for reaching out to us.

This forum is dedicated to software developers using LSEG APIs. The moderators on this forum do not have deep expertise in every bit of content available through LSEG products, which is required to answer content questions such as this one.

The best resource for content questions is the Helpdesk support team, which can be reached by submitting queries through LSEG Support. The support team will either have the required content expertise ready available or can reach out to relevant content experts to get the answer for you.

You need to ask for the Excel formula, such as =RDP.Data, that can be used to retrieve the required data. Then, we can help you converting that formula to Python code. You can also refer to the How to Convert the =@RDP.Data Excel Function into Code Using the LSEG Data Library for Python article.

Otherwise, you can use the Data Item Browser tool to search for fields and parameters.