​A selection of topics on IT and its application to finance. 
​Send me your comments, questions ​or suggestions by clicking
h​ere


elmama
An Excel example showing the use of the new Reuters RDATA command


When Reuters decided to upgrade their old 3000 XtraPowerProPlus engine to Eikon they came up with an all-encompassing replacement for the myriad RtGet, RtUpdateetc … commands called RDATA. Below shows a simple but practical example of its use in getting some EUR spot and forward cross rates.


First of all we need to tell Reuters which instruments we are interested in, then what data to retrieve for those instruments. We will put our instrument list in cells A3 to A6 and we will put what data we want to extract in cells B2 to E2.


In my particular case I wanted to extract the Bid, ASK and update time of the Euro and Swiss Franc spot and 3 month forward rates.


My XL looked like this


 

A

B

C

D

E

=RData(A3:A6,C2:E2,"RTFEED:IDN","FRQ:1s",,C3)






CURRENCY

VALUE DATE 1

ASK

BID

EUR=

EUR

01/10/2013

1.3543

1.354

EUR3M=

EUR

01/10/2013

3.19

3.07

CHF=

CHF

01/10/2013

0.9031

0.9028

CHF3M=

CHF

01/10/2013

-7.15

-7.28

 


Looking at the RDATA command in cell A1 it’s reasonably clear what is going on. The first parameter A3:A6 tells RDATA where the RIC codes are for the instruments we are interested in. The second parameter C2:E2 tells RDATA what information we want to retrieve on the instruments. The RTFEED:IDN parameter tell RDATA which Reuters database to use. The fourth parameter indicates how often the data should refresh i.e every 1 second in this case. And the final parameter C3 tells RDATA where to start putting the returned data.