i am interested in setting up a data feed into excel via your API - can you help me set it up for CN

Amith.TUmesh
edited October 3 in Workspace SDK

i am interested in setting up a data feed into excel via your API - can you help me set it up for CNHSRSWATM=TRHK please?

Tagged:

Answers

  • If the LSEG Workspace is installed on a machine, then Excel Add-in for the Workspace is also added with it. You can see it in the Excel menu bar.

    Once logged into the Workspace, user can use formula builder as shown to get real time or fundamental data

    image.png

    Here is the formula for the provided instrument :

    =@RDP.Data("CNHSRSWATM=TRHK","CF_LAST;CF_BID;CF_ASK;CF_CURR;CF_CLOSE","CH=Fd RH=IN",B2)