question

Upvotes
Accepted
Xiaoning avatar image
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 5.0 MiB each and 10.0 MiB total.

1 Answer

Upvote
Accepted
Jirapongse avatar image
38.1k ●71 ●35 ●53

@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 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea