How to have VBA code where I pass an array of RICs

Jem · 2025-01-15T15:27:13+00:00

There was an error rendering this rich post.

I want to have VBA code where I pass an array of RICs, a time / date and I get the MID_Price.Close field back so for example - these three RICs:

USDSROIS2Y=
USDSROIS3Y=
USDSROIS4Y=

Find more posts tagged with

Accepted answers

All comments

Gurpreet

Hello @Jem,

Which API/product is this question for?

Jem

Refinitiv Workspace for Investment and Wealth Management

Gurpreet

COM API is not available in the Workspace and hence cannot be used with VBA. See this answer and alternatives offered for details.

If you want to reference multiple instruments in the Excel sheet, just pass it as a reference to cells in the formula:

Quick Links

All Forums
Recent Questions

EXPLORE OUR SITES