henryvii99
New Member
- Joined
- Apr 22, 2011
- Messages
- 32
Dear everyone,
I had tried to do web query on the technical analysis data on yahoo finance, it work perfectly fine if I use normal web query method (copying the http link to excel), e.g. http://hk.finance.yahoo.com/q/ta?s=0001.HK
But it doesn't work if I use variable, e.g.
http://hk.finance.yahoo.com/q/ta?s=["num"].HK
Is there any method to query a batch of queries? I want the basic info from the chart in the bottom. But I don't need to update it often (e.g. once a week). So I can do it in a semi auto way, provided that the dynamic web query is working.
I may need to do queries on ~2000 stocks!!! Is there a macro that can help me to copy the tables out? Or extract the data and copy it to somewhere? If a solution is too difficult, a fix in the yahoo finance web query is good enough to save my skin.
Many thanks in advance.
I had tried to do web query on the technical analysis data on yahoo finance, it work perfectly fine if I use normal web query method (copying the http link to excel), e.g. http://hk.finance.yahoo.com/q/ta?s=0001.HK
But it doesn't work if I use variable, e.g.
http://hk.finance.yahoo.com/q/ta?s=["num"].HK
Is there any method to query a batch of queries? I want the basic info from the chart in the bottom. But I don't need to update it often (e.g. once a week). So I can do it in a semi auto way, provided that the dynamic web query is working.
I may need to do queries on ~2000 stocks!!! Is there a macro that can help me to copy the tables out? Or extract the data and copy it to somewhere? If a solution is too difficult, a fix in the yahoo finance web query is good enough to save my skin.
Many thanks in advance.
