Simple Power Automate with Stocks API
To we are going to set up an HTTP request to fetch real-time stock data (on a Sunday and then populate some fake data), and dynamically process stock tickers like MSFT, AAPL, GOOGL, and AMZN.
Key Topics Covered:
• Setting up a scheduled flow in Power Automate
• Configuring HTTP requests with Finnhub API
• Dynamically looping through stock tickers
• Writing results to Excel
💡 Tools Used:
Power Automate M365 (one premium connector)
Finnhub API (Free plan available)
📈 Automate your stock updates today and streamline your workflows with this powerful integration! Don't forget to like, comment, and subscribe for more Power Automate tips and tutorials. 👍
Chapters:
0:00 Introduction
2:15 Create Free API Key
3:00 Set up Excel
7:06 Call the API
5:00 Set up Recurrence
11:30 Using Compose on Outputs
15:45 Using Example Data in Excel