So here we’re going to fill in the tickers for the Apple, Microsoft and Amazon corporations. Then go to reinstall it via Insert tab> click Get Add-ins> search for 'stock connector' and click Add. I used this URL (with my own key) as an example to return a single intraday Microsoft share price MSFT&apikey= demo To begin collecting data from stock exchanges in Excel, first we need to fill in tickers or stock symbols for company names for which we want to get the information. If you want to reinstall the add-in in Excel you may refer to steps below: In Excel ribbon, right click Stock Connector and click Remove Add-in > click Yes. Next, generate a query response by choosing the query you want, copying the URL they provide in their examples and pasting it into your browser - keep the response there for copying later. You'll need to read the API query options to decide - įor this example I've just used the Quote Endpoint query. If you want realtime you may have to pay for a service somewhere or use the intraday query with 1min intervals. I think the limitation here is 5 requests per minute, which is not bad for a free API. You could also create a custom connector in PowerApps, but that's a little more involved, so I've tried to keep this example as simple as possible for everyone.įirst, create a free account and get your API key ( ) Please note that the stock price from this example may or may not be realtime depending on the API and the query you decide to use from that API - this example is really to show how you can easily leverage use a third-party API inside PowerApps and Flow.
Here we can delete the stock exchange identifier and the ticker, then we click on the Search icon and Excel shows the list of other stock. In case you want to get data from another stock exchange, right-click on the ticker, go to ‘Data Type’ and select ‘Change’.
You would need to play with various api suppliers and queries to find the one that suits your needs, but for this example I've used Alpha Vantage. How to Get Data from Another Stock Exchange. You can do this with a free stock API like Alpha Vantage and creating a flow to collect the info for you.