Vba for stock quotes

Dear Friends,

I want to get today's live stock quote in this format:
open, high, low, LTP (last traded price / current / close)

it could be from yahoo finance, google finance, investing.com or any other site for indices.

Yahoo seems to have changed its live price format on its site...web query method is not working anymore...i am using windows professional...


please see attached excel sheet for the vba code that i have "gathered". But i cant fix it.

I shall be grateful, if someone helps...

reg
k

This is the code in the attached excel sheet, for ready reference...

Please Login or Register  to view this content.