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