Is it possible for a graph in a form to be based on data on a website?

[Herbert Chan]

Hello,

I'm subscribing to funds on HSBC, and the fund prices can be found here:
http://www.tools.hsbc.com.hk/search/...g=en&init=true

At the moment, I'm copying each day's data into an excel spreadsheet (I'm
using the query function of excel to automatically extract the data from the
webpage). So now, the Access form containing the graph gets data from the
excel spreadsheet.

I'm wondering if it is actually possible to make the graph to be using data
directly from the hsbc website. Then I can just fire up my access graph any
time I feel like to see the chart (I'm using the candlestick chart to follow
the fund prices).

Hope this is possible and someone knows how to do it.

Thanks.

Herbert

[Chuck Grimsby]

Sort of, yes, but since the output is going to be in Excel, why no
just do it from Excel?

Check out the Excel section of http://www.mvps.org/ If memory serves,
there's some code there that shows how to read in a web page.
On Tue, 26 Dec 2006 19:52:02 +0800, "Herbert Chan" <he*****@chan.com>
wrote:

>Hello,
I'm subscribing to funds on HSBC, and the fund prices can be found here:
http://www.tools.hsbc.com.hk/search/...g=en&init=true
At the moment, I'm copying each day's data into an excel spreadsheet (I'm
using the query function of excel to automatically extract the data from the
webpage). So now, the Access form containing the graph gets data from the
excel spreadsheet.
I'm wondering if it is actually possible to make the graph to be using data
directly from the hsbc website. Then I can just fire up my access graph any
time I feel like to see the chart (I'm using the candlestick chart to follow
the fund prices).
Hope this is possible and someone knows how to do it.

--
Drive C: Error. (A)bort (R)etry (S)mack The Darned Thing