We help IT Professionals succeed at work.
Get Started

Accessing Real-Time Stock Quotes in an MS Access Database

4,584 Views
Last Modified: 2013-12-20
I am trying to somehow get real-time (or slightly delayed) stock quotes into an MS Access Database.  Working in the financial industry, we often make our own tools for different types of stock analysis. These tools are usually in Excel and therefore we just use the MSN Stock Quote Add-In for Excel. This is sufficient for our purposes.

Since I am building an analysis tool in MS Access now, I am trying to resolve the best method for getting some real-time (or slightly delayed) stock quotes into an MS Access database.  I have some ideas, such as using Excel with MSN Stock Quotes and then importing this data into an Access table (kind of cumbersome and may need to happen multiple times throughout the day - plus, I don't really want to involve another tool like Excel at all if I can help it)

Does anyone have any knowledge of an MSN Stock Quote type Add-In for MS Access or any other suggestions for how I might accomplish this task?  I always appreciate all of the help and excellent suggestions from the folks on this site and I'm hoping someone else may have tackled this same problem, previously.

Thanks!
Comment
Watch Question
rock star
Commented:
This problem has been solved!
Unlock 2 Answers and 7 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE