question

Upvote
16 0 0 1

Issue with new Workspace plugin in Excel

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)))

workspace#productworkspace-upgrade
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Upvotes
15.5k 33 5 10

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.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.