Where can we store currency exchange rates for past and future data in OTM

Summary:

WE need to understand a way where we can store currency exchange on daily basis in OTM and use them as per our will.

The exchange rates we will be getting using integration from a API table which will be updated every day.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):