New functions in Reuters

SebastianW

=RHistory(WIPLN3MD=;"ASK.Timestamp;ASK.Close";"START:"&2021-09-30-2&" END:"&2024-09-30&" ADJUSTED:YES INTERVAL:1D";;"SORT:ASC NULL:PREVIOUS TSREPEAT:NO DAY:A CH:Fd";GM3)

Hi,
Due to an update, my old functions are not working - any idea how to improve the code above?

Jirapongse

@SebastianW

Thank you for reaching out to us.

What is the update (Eikon update or update to Workspace)?

However, for questions regarding Excel, please directly contact the helpdesk team via MyAccount. The helpdesk team can verify what the problem is.

SebastianW

Workspace, ok I will text helpdesk

Jirapongse

https://community.developers.refinitiv.com/discussion/comment/123472#Comment_123472

@SebastianW

For Workspace Excel, you can use the formula builder to geneate a formula.

The function in Workspace Excel to get historical data is =@RDP.HistoricalPricing.

The formula looks like this:

=@RDP.HistoricalPricing("WIPLN3MD=","ASK","START:30-Sep-2021 END:30-Sep-2024 INTERVAL:P1D SOURCE:RFV",,"CH:Fd RH:Timestamp",B3)

Yes, you can contact the helpdesk team to get a formula.