Jan 14 2019 10:05 AM
Hi all, I am trying to get JSON data from the IEX API and have used the WEBSERVICE() function, but I can't seem to filter it down to the values I need.
For example:
If I want the "total cash" for the first year financials of Apple; I have tried this formula:
=VALUE(WEBSERVICE("https://api.iextrading.com/1.0/stock/AAPL/financials?period=annual/0/totalcash"))
Which gives an error. I think the incorrect part is the "/0/" but I don't see how to specify which year I want.
Any help is really appreciated.
Thanks,