For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
@kanza it is more of a content question. I suggest you contact the Refinitiv support desk and ask them to help you model this in Excel. Once done, we can guide you through converting it into API calls.