Hi There, I am looking to use an API in python to retrieve the current return ( 1min, 5 min and 15 min) and the RSI (14 min) for USDCAD (CAD=).
HI @Nij ,
Have you had a chance to use https://developers.lseg.com/en/video-catalog/data-item-browser to find the proper field name?
However, I've tried but not sure which field (data item) name is what you're looking for.
And as this forum is more for programming-type queries, rather than content queries. I would recommend you to contact the Workspace support team directly via https://support.lseg.com/s/ . You can ask for the Workspace Excel formula which can be used to retrieve the data and if the formula is available, we can apply it to the get_data method in the Data Library. That way a content specialist can work closely with you to find a way to get the required data.
Hope this could help.
@Nij
You can use the LSEG Data Library for Python to retrieve intraday historical data. The following code uses the get_history method to retrieve 1min historical data of CAD=.
df = ld.get_history( universe=['CAD='], interval="1min", start = '2025-11-20T00:00:00Z', end = '2025-11-20T02:00:00Z') df
It supports the following intervals.
interval: str, optional Date interval. Supported intervals are: tick, tas, taq, minute, 1min, 5min, 10min, 30min, 60min, hourly, 1h, daily, 1d, 1D, 7D, 7d, weekly, 1W, monthly, 1M, quarterly, 3M, 6M, yearly, 1Y
After that, you can use this data to calculate those RSI values. You can refer to this Create Technical Analysis triggers and signals using the LSEG Data Library for Python article.
Otherwise, you can contact the helpdesk support team via LSEG Support as mentioned by my colleague.
