I'm working on a project where I'm using the "headlines = ek.get_news_headlines("R:BAYGn.DE IN ENGLISH")" with Eikon API to collect financial news headlines for DAX 40 companies over the past year. The challenge I'm facing is the API's limit of 100 headlines per request.
If anyone has tackled a similar task, I'd love to hear your insights. Specifically:
How can I efficiently loop through paginated API requests to gather all the data I need?
Are there any concerns regarding API quotas or rate limits for making a larger volume of requests?
Any advice on using Excel Add-In to retrieve financial news headlines?
Your advice and experience would be incredibly helpful in overcoming this hurdle. Thank you for your time!