Does microsoft excel 2016 has function "=googleFinance()" which is available in google sheets?

Question

I want to get the live market price(Indian Market) of some stocks which are already mentioned in my MSExcel sheet, which can automatically update. I saw a function in google sheet (=googleFinance()) that does the same thing. But this function is not available in MS EXcel 2016. How to use this function in MSExcel or are there any alternatives?

Answer 1

I did a code that works for me.

Function GoogleFinance(index As String)
Dim resultado As Double, ie As Object

Set ie = CreateObject("internetexplorer.application")
ie.navigate "https://www.google.com/finance/quote/" + index + ":BVMF"
Do While ie.busy

DoEvents
Loop
On Error Resume Next
resultado = ie.document.getElementsByClassName("YMlKec fxKbKc")(0).innertext
ie.Quit
GoogleFinance = resultado

End function