Excel Formula to RDL

Question

The client wants to know if it is possible to retrieve the data being retrieved by this excel formula =@RDP.HistoricalPricing("PLN3YOIS=TTKL","BID;ASK","START:30-Apr-2026 END:30-Apr-2026 INTERVAL:P1D SOURCE:RFV",,"CH:Fd RH:Timestamp")

This formula pulls the BID and ASK price of PLN3YOIS=TTKL for April 30, 2026

Moreover, if we have a knowledge base for data licence data retrieval?

Jirapongse · Answer

If RDL stands for Refinitiv Data Library, RDL has been rebranded to the LSEG Data Library. The LSEG Data Library supports Python, .NET, and Typescript.

Please use LSEG Data Library instead of Refinitiv Data Library. Then, the client can choose to use Python, .NET, or Typescript with LSEG Data Library.

Python is a programming language and we provide the LSEG Data Library for Python that can be used in Python.

Nathaniel_Castillo20 · Answer

Hello Jirapongse. Thank you for this one. May I ask what is the difference between Phyton and RDL? Is it the same thing or not? Thank you so much!

Jirapongse · Answer

@Nathaniel_Castillo20

Thank you for reaching out to us.

The client can use the LSEG Data Library for Python to retrieve historical. The equivalent Python code for that RDP.HistoricalPricing Excel formula is:

ld.get_history(
    universe=["PLN3YOIS=TTKL"],
    fields=["BID","ASK"],
    start = '04-30-2026',
    end = '04-30-2026',
    interval="daily"
)

The client can also refer to other examples on GitHub.

EXPLORE OUR SITES