Automated Price Fetching Tool

I need an Excel solution that automatically fetches price data from my broker's API. The tool should perform some predefined calculations, such as basic additions and subtractions, on the fetched data.

Requirements:
- Excel proficiency
- Experience with APIs, especially broker APIs
- Ability to set up automated data fetching and calculations in Excel

Ideal Skills:
- Strong Excel skills
- Familiarity with API integration
- Experience with financial data and calculations