Need help with API and stock data


The stock provider i intend to use for real time stock data and key metrics are providing data in JSON via API if I get this correct.

I want to get a program or a script in VBA (Excel) to get all the info of all the stocks they have. Or do I need a separate platform / program and then convert it to something Excel understand?

I can see from the Data tab that Excel is able to get JSON directly, just dont know how to do it. Where do I start and how can it be done?

Kind regards Kristian

I think this is the sort of thing you’re looking for. The initial details about the key, ip address, etc, will be different for the specific API you’re actually trying to use.