Issue with new Workspace plugin in Excel

kerri-anne

We recently moved from Refinitiv Eikon to Workspace and the plugin does not appear to be pulling daily instrument prices as it used to. Wondering if there might be something that needs to change in the formula that pulls the prices? Example: =@IF(B3="","",IF(AND(VALUE('Date & Time'!$B$1)=TODAY(),ISTEXT(@RHistory(B3,".Close","START:"&'Date & Time'!$B$1&":00:00 END:"&'Date & Time'!$B$1&":"&'Date & Time'!$B$2&" INTERVAL:1M",,,E3:E3))),TR($B3,"CF_LAST"),RHistory(B3,".Close","START:"&'Date & Time'!$B$1&":00:00 END:"&'Date & Time'!$B$1&":"&'Date & Time'!$B$2&" INTERVAL:1M",,,E3:E3)))

raksina.samasiri

Hi @kerri-anne ,

Your question is about Workspace Excel functionality, rather then about the API.

The best approach is to reach out to helpdesk directly, by submitting Workspace Excel question via MyAccount.

To be of help, I have opened a
support case on your behalf, ticket number 13996794, please
expect a support expert to reach out to you shortly, via email address
that you have registered on developers portal with.

wasin.w

https://community.developers.refinitiv.com/discussion/comment/122016#Comment_122016

Here's the statement posted in the ticket, I'm putting it here for reference

Thank you for your patience.

Our specilists identified that formulas are only intended for Eikon and needs to be converted for workspace.

You may place your request to convert these formulas for workspace using the link below.

https://fmc.refinitiv.com/