i am using DEX2 to send commands and retreive data using VBA. I am sending replication of TR commands successfuly via API but can't retrive the list of securities from a portfolio. the TR command is
(replicate =TR("PORTFOLIO(MyPortfolio)",....)
is there a way to send this command using DEX2 library?
Hi.
Thank you for your participation in the forum.
Are any of the replies below satisfactory in resolving your query?
If so please can you click the 'Accept' text next to the appropriate reply. This will guide all community members who have a similar question.
Else please post again offering further insight into your question
Thanks
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
AHS
Hello Ariel,
I have attached the Excel Advanced ADC (Analytics Data Cloud) TR Dex2 zip file (from the downloads section of the Eikon COM, “Eikon - Microsoft Office” APIs.
This (largeish) workbook contains a number of different ADC Dex2 examples (each worksheet is self contained code wise and shows the on-sheet TR() function call on the left hand side and the VBA API call on the right hand side). Use the worksheet with the closest on sheet TR() example, check that you can retrieve your data correctly and then use the inputs for the VBA retrieval.
Any problems, please get back to us.
David Cammish,
Platform Services.
