Use Excel for TS Report and Marketdata API

This option is only possible if the company uses Microsoft Entra Id.

First add the permission “Public API Access” to the user in the TS Application 

Open Excel choose Data => From Web 

Enter the following url 

https://ts.treasurysystems.com/tenants/CUSTOMERNAME/api/marketdata/ir/v1?dateCode=20240312 

or

https://ts.treasurysystems.com/tenants/CUSTOMERNAME/api/reportdata/realtime/v1

For more information about the different endpoints and their different parameters please see Treasury Systems Report Data and Market API

Chose Organization account