How to get time series of Australian business and home lending rates in Eikon/Python (aAUVHOSLNF and

I am looking for time series of business and home lending rates using Python - Eikon.

I tried this, but without success:

start_date = '2010-12-31'
end_date = '2021-03-31'
dfb = ek.get_timeseries(["aAUVHOSLNF"], start_date = start_date, end_date=end_date)
dfh = ek.get_timeseries(["aAUSBVRSTRM"], start_date = start_date, end_date=end_date)

Note, the Datastream codes and respective RICs for the interest rate series are:

AUVHOSLNF, aAUVHOSLNF
AUPRSBRS, aAUSBVRSTRM


Best Answer

  • Hi @blucap ,


    I'm afraid that (i) not all data-sets in Datastream are available on Eikon and (ii) this Q&A site is not monitored by content experts... Having had a quick look at the Data Item Browser on the Eikon Desktop App, I could not find time-series data for 'aAUVHOSLNF' or 'aAUSBVRSTRM'. If (I) you have a content question, please open a support case with Refinitiv Helpdesk; if (II) you have Datastream, would you mind letting me know if the bellow provides the data you are looking for?


    df5 = ds.get_data(tickers="AUVHOSLNF,AUPRSBRS",
    fields="X",
    start='2000-01-01',
    end='2021-04-06')
    df5

    1627045516878.png

Answers

  • Many thanks for your answer. I will escalate to the helpdesk.