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?
Does microsoft excel 2016 has function "=googleFinance()" which is available in google sheets?
Viewed 2125
1 Answers
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
Related