Forum Discussion
Api in every row of excel.
Hi Currently I have an excel file with the following columns. MFund Code I Bought at I Mutual fund name I latest Price 112092 I 100.00 I Fidelity worl...
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