Getting Swiss Portfolio periodic tax returns using RDP Libraries
See the full article on the Developer Portal, written by Raksina Samasiri, Maysa Wittayanontawet, Hathaipath Inlub, and Kittinee Thamruengthong.
Why do we need to get the Swiss Tax Data attributes?
A Swiss Portfolio Manager is required to make periodic tax returns to the Swiss Federal Tax Authority. In order to calculate the appropriate taxation rates on these tax returns, the portfolio manager needs some key attributes alongside the basic instrument reference data that they already have.
In this article, we’re going to retrieve the Swiss Tax Data attributes provided by Refinitiv, for each instrument of a mixed-asset portfolio (bonds, equities, and funds) of 2,000 instruments
• Instrument ID
• Issuer Domicile Text
• Swiss Stamp Duty Flag
• Swiss Stamp Tax Rate
• Taxation Comment
• Taxation Type
We’re using Refinitiv Data Platform Libraries (RDP Libraries) to retrieve the data from these RDP APIs
- Symbology API: To convert the identifiers supplied in the instrument list into PermIDs
• Data Store GraphQL API: To request Swiss Tax Data for the instruments requested
5 steps to retrieve the data
Step 1) Preparation
Step 2) Authentication
Step 3) Convert Symbology
Step 4) Data Store GraphQL API — retrieve Swiss Tax Data
Step 5) Run the defined functions
To see the full details of each step, see you on the Developer Portal! From this code, we can retrieve Swiss Tax data from the input instruments provided in a CSV file using RDP Libraries.
References
SOURCE CODE
RELATED API
REFERENCE
- Swiss Tax Data — Refinitiv
- Refinitiv Data Platform Libraries — quickstart
- Refinitiv Data Platform APIs — Symbology User Guide
- Refinitiv Data Platform APIs Playground
- Swiss Tax Data | Refinitiv
RELATED ARTICLE