We are needing to load ticker lists and pricing data through our ETL process into our application. I'm confused by the number of API's available - I'm just going to be automatically loading the ticker data into one of our SQL Server tables, at a certain time each morning. Same with pricing for yesterday's close. Which API should I be using for this type of case?
There's no simple answer here. Apart from the types and the amount of data you require or the technology stack you prefer you also need to consider data usage rights. I suggest you reach out to your Thomson Reuters account manager who will be happy to help you select the product and the API that best suits your use case. If you're not yet a Thomson Reuters customer you can either call Thomson Reuters office in your country or contact the sales team following the link below.