Bond yields and duration

I need to obtain time series of bond yields (i.e. p. 83 of Hull's textbook) and bond duration (i.e. p. 91) for a range of fixed-rate bonds. However, TR.CLOSEYIELD and TR.DURATIONANALYTICS are rarely available for bonds, including large ones like DEDB2GPB=SG.

Theoretically, I should be able to compute it myself, but that requires to query bond prices through TR.CLOSEPRICE, Issue and Maturity dates as well as coupon details through TR.COUPONRATE, TR.COUPONFREQ, TR.FiFirstCouponDate and TR.FiLastCouponDate.

Before I do that, I would like to ask for confirmation that, indeed, I cannot get the information straight from Eikon. Thank you for your help.

This question is similar to the ones below, which however did not help me.

[*] https://community.developers.refinitiv.com/questions/48626/python-api-bond-yield-data.html

[**] https://community.developers.refinitiv.com/questions/46222/eikon-api-what-field-to-choose-for-historical-dura.html