Api in every row of excel.

you can use Excel built in tools to pull the data.  you can create an external link using Data->get data from webpage and pull a table of data but not sure how well that would work here.

alternatively, you can also use inline formula like this:

=--TEXTBEFORE(TEXTAFTER(WEBSERVICE("https://api.mfapi.in/mf/"&$A2&"/latest"),"nav"":"""),"""}],")

where A2 is where the Mfund Code is located

NOTE: I do NOT see that Stanley Index fund anywhere in that api