Excel Integration: How to retrieve full monthly historical data for a CUSIP (similar to Workspace)

Harry
Harry Newcomer
edited March 21 in Datastream

I need functionality where I can input a CUSIP into Excel and automatically retrieve the full monthly historical data for that CUSIP. The output should look exactly like the monthly historical view available in Workspace under "Trade Check" (see attached screenshot for reference). Please let me know how I can achieve this or where I need to go to generate these results directly from Excel

image.png image.png

Answers

  • Jirapongse
    Jirapongse ✭✭✭✭✭

    @Harry

    Thank you for reaching out to us.

    To retrieve data from Excel, you can contact the LSEG Workspace Excel support team directly via MyAccount.

    The support team can check if the data is available and provide you with the Excel formula used to retrieve the data.