AF1MN for DATASTREAM API CALL using postman

Xiaoning

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

Response

1593069887926.png

Jirapongse

@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>"
    }

The output is:

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.

1593073373984.png

1593073166236.png