question

Upvotes
Accepted
1 1 0 3

Cannot load rates with AdxRtHistory

Hello,

I have the bellow code but it does not work.

Do you have any idea why ?

If oRtHist Is Nothing Then Set oRtHist = CreateReutersObject("AdfinXRtLib.AdxRtHistory")
    
     With oRtHist
        .FlushData
        .ErrorMode = EXCEPTION
        .Source = "IDN"
        .itemName = "USONFFE0D=RR"
        .Mode = "START:" & Format(sttDt, "ddmmmyy") & _
            " END:" & Format(endDt, "ddmmmyy") & _
            " SORT:DES" & _
            " ZERO:SKIP" & _
            " NULL:SKIP" & _
            " FRQ:D"
        .RequestHistory "NDA_RAW.Nda_date;NDA_RAW.Nda_latest_trade_yield"
    End With

The formula in Excel is the following:

=RHistory("USONFFE0D=RR","NDA_RAW.Nda_date;NDA_RAW.Nda_latest_trade_yield","INTERVAL:1D",,"CH:IN;Fd",M19)

Thanks a lot,

Hamza

eikoneikon-com-api
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
Upvotes
Accepted
966 11 21 26

AdFinXRtLib is an API that has real-time data and some end of day historical data. Intra-day historical data is available in Eikon via RHistory. These are two different APIs though so you will not be able to use the arguments from RHistory Excel function to populate the arguments of AdxRtHistory VBA API.

You will find an RHistory API tutorial here. Plug the function arguments into that API and it should work.

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.