How can retreive the securities list from existing Portfolio using vba and COM API

ariel.amar

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?

David.Cammish

advanced-adc-tr-dex2-0.zip

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.