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?
This post was moved to a different board that fits your topic of discussion a bit better. This means you’ll get better engagement on your post, and it keeps our community organized so users can more easily find information.
As you’ll notice, your topic is now here in the Project Development Help and Advice board. No action is needed on your part; you can continue the conversation as normal here.