Python script for this formula which gets the Mid Yield as of 7PM Paris Time

oscarjr

how to get the python script for this formula which gets the Mid Yield as of 7PM Paris Time. Please use sample RIC: FR0014005SE7= if needed

This is the formula we have for excel.
=@RDP.HistoricalPricing("FR0014005SE7=","MID_YLD_1","END:26-May-2026:19:00 TIMEZONE:PAR NBROWS:1 INTERVAL:PT1M SOURCE:RFV",,"RH:Timestamp")

Jirapongse

@oscarjr

Thank you for reaching out to us.

The API uses GMT so you need to convert team to GMT.

from datetime import datetime
from zoneinfo import ZoneInfo

# 1. Define the naive date/time in Paris
paris_time = datetime(2026, 5, 26, 19, 0, 0) # e.g., May 27, 2026 at 2:00 PM

# 2. Localize to the Paris timezone (this makes it timezone-aware)
paris_aware = paris_time.replace(tzinfo=ZoneInfo("Europe/Paris"))

# 3. Convert to GMT (UTC is computationally identical to GMT)
gmt_time = paris_aware.astimezone(ZoneInfo("UTC"))

print(f"Paris Time: {paris_aware.strftime('%Y-%m-%d %H:%M:%S %Z')}")
print(f"GMT Time:   {gmt_time.strftime('%Y-%m-%d %H:%M:%S %Z')}")

ld.get_history(
    universe = ["FR0014005SE7="],
    interval = "1min",
    fields = ["MID_YLD_1"],
    count = 1,
    end = gmt_time.strftime('%Y-%m-%dT%H:%M:%S'))

I use the LSEG Data Library for Python. The examples are on GitHub.