question

Upvotes
Accepted
3 0 1 1

AF1MN for DATASTREAM API CALL using postman

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

datastream-apidsws-api
1593069887926.png (20.7 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Upvote
Accepted
76.9k 240 52 72

@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 (49.9 KiB)
1593073166236.png (17.6 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.