question

Upvotes
Accepted
6 3 3 4

VBA API - Fetch CF_CLOSE with DEX2 doesn't work

Hello,

I have a working VBA Code that retrieves many TR. Fields for a list of mixed instruments with the DEX2 API.
The problem arises when I try to fetch fields which do not start with "TR.", as for example CF_CLOSE or OPEN_PRC.

The error says "CF_CLOSE is not a valid request parameter.".


Oddly enough, using the fomula builder, this formula works:

=TR("LU0033050237";"CF_CLOSE;TR.CLOSEPRICE";"CH=Fd RH=IN CODE=ISIN";B1)

Am I getting something wrong? How can I fetch Fields that don't have the prexif "TR."?

In the specific case, I have to use CF_CLOSE instead of TR.CLOSEPRICE because for Bonds (e.g. LU0033050237) and Open-End Funds (e.g. US0030207163), TR.CLOSEPRICE seems to be very often empty (why??).

eikoneikon-com-apidatafieldsvba
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.

I found some good alternatives as TR.FiPricingClosingPrice or TR.FiPrevPrice for bonds or TR.FundNAV for funds.

1 Answer

Upvote
Accepted
4.6k 26 7 22

@nicola.pestalozzi the fields that do not start with TR are real-time fields, and you will have to use the real-time API, such as Adfin X Real-time, check out this tutorial. However, please note that Adfin X Real-time is only supported in the 32-bit environment.

As for the empty close prices, I would suggest that you raise an issue with your local Thomson Reuters support desk, they should be able help.

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.