Solved

Accessing Data for an Application Through an Internet Server

Posted on 2000-04-26
6
146 Views
Last Modified: 2010-05-02
Hi all-

I am creating an interactive investment application.  I have all of the
historical quote data (all data necessary to plot a graph) on my web
server.  I want to use all of this information to plot a graph of the
stock's history while the user is on the internet.  When the user is not
on the internet, the graph would simply be blank.  I know that it is necessary to use the Inet control to FTP previously set files. (I think?!)  Is there a way that I can do this? (I have seen it done in bigeasyinvestor @
www.bigeasyinvestor.com).
Please address replies to toddbranch@home.com.

Thanks.

toddbranch
0
Comment
Question by:toddbranch
6 Comments
 

Author Comment

by:toddbranch
ID: 2753314
Adjusted points from 80 to 400
0
 
LVL 1

Expert Comment

by:j3877
ID: 2753346
Why do the stock values always have to be on the webserver - can't you just download the stocks history from the server, and when they connect to the internet, just get the values that they don't have, and plot the graph on the local machine, therefore saving the server a lot of processing?
0
 

Expert Comment

by:catdaddy123
ID: 2753703
look here for retrieving data from http servers http://616.org
0
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 

Author Comment

by:toddbranch
ID: 2753772
I am going to have a database of over 12,000 stocks that will each have historical data of at least a couple of hundred of kb each.  I want to make the download of the application as small as possible.  I can access this data from a stock service that already has all of this on their server.
0
 

Author Comment

by:toddbranch
ID: 2753787
catdaddy-
where on the website do I look for info on accessing data on http servers?
0
 

Accepted Solution

by:
netvan earned 400 total points
ID: 2753957
You can create a temp access table.Then download the data and draw the graph.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now