By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,247 Members | 1,427 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,247 IT Pros & Developers. It's quick & easy.

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

P: n/a
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

Dec 26 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a

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

Dec 26 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.