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 512.0 KiB each and 1.0 MiB total.

Alex Putkov.1 avatar image   Alex Putkov.1

@Xiaoning

Thank you for your participation in the forum. Are any of the replies below satisfactory in resolving your query? If yes please click the 'Accept' text next to the reply that best answers your question. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.

Thanks,

-AHS

1 Answer

· Write an Answer
Upvote
Accepted
Jirapongse avatar image
79.2k ●251 ●52 ●74

@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.