Homepage
PR Newswire
Quote:BTW several yrs ago at the old forum, you showed your kung fu at using the web query function in Excel to automatically retrieve SGX stock quotes from it's web pages directly into Excel on real-time basis. I carefully followed your instructions (including the workaround the web query bug) and was able to use it to calculate comparative yields across a range of stocks real-time with just 1 click. Until SGX reworked its website about couple years ago and introduced Java routines to fetch quotes which broke the web query access. Wonder if you have kung fu around this issue yet.
If the goal is to retrieve price quotes and have them on Excel sheets, and you don't mind a lag of 15 to 30 minutes, you can use the Yahoo! Delayed Stock Quotes Template published by The Ben Graham Centre of Value Investing at Richard Ivey School of Business (University of Western Ontario).
It is available at this link:
http://www.bengrahaminvesting.ca/Resourc...tabase.htm
___________________________________________________________________
Addendum:
This works for all tickers quoted on Yahoo! Finance.