I want to write my own function in Excel to get the real-time quota from the following website and update/refresh every minute.
As you can see, the stock number is at the position after "symbol=" in the URL.
Anyone can let me know how can I do it? I tried to use MSN Monney before but its data does not suitable for Hong Kong market. So I wanna to have my own.
In the Excel sheet 1,
column A, all the stock number typed manually.
column B, the real-time stock quote getting from the above website, of course related to the value typed in column A.
I hope someone can help!
Thank you very much!