AF1MN for DATASTREAM API CALL using postman

Xiaoning
Xiaoning LSEG
in Datastream

For P/E ratio we finally planning to use AF1MN;AF2MN;AF3MN which are forecasted earnings by IBES and we divide that with daily price to get the more accurate P/E ratios and our business as approved it now.


But when we are requesting using API , unfortunately it is returning Price instead of earnings value. Can check this with high priority as we need to develop and deploy ASAP.



DATASTREAM FORMULA

=DSGRID("@:JPTOPIX","AF1MN;AF2MN;AF3MN","-4M","","D","RowHeader=true;ColHeader=true;Heading=true;Code=true;LatestFirstValue=true;DispSeriesDescription=false;YearlyTSFormat=false;QuarterlyTSFormat=false","")


DATASTREAM API CALL using postman - ( FYI the code is working and returning other standard values as excepted )

Please find the screen shots below for the AF1MN from DataStream. Its returning Price


Request

image

Response

Tagged:

Best Answer

  • Jirapongse
    Jirapongse ✭✭✭✭✭
    Answer ✓

    @Xiaoning

    The request in postman should look like:

      {
            "DataRequest": {
                "DataTypes": [
                    {
                        "Properties": null,
                        "Value": "AF1MN"
                    }
                ],
                "Date": {
                    "End": "",
                    "Frequency": "D",
                    "Kind": 1,
                    "Start": "-4M"
                },
                "Instrument": {
                    "Properties": null,
                    "Value": "@:JPTOPIX"
                },
                "Tag": null
            },
            "Properties": {
                "Key": "Source",
                "Value": null
            },
            "TokenValue": "<token>"
        }

    image

    The output is:

    image

    You can test the request by using this DSWS client test page.

    First, you need to use Get Token and then use the retrieved token with Get Data.

Categories