Get stock quotes from a site

[SergioRocha]

Greetings to all... i'm developing a database to manage stocks investments. At the moment it has a simple web browser integrated that allows me to navigate throw any website without the need of a standard web browser like IE or Firefox. I know that there are ways to get financial information using one program language directly to an application. I've found that, for instance, Google Finance http://www.google.com/finance provides free financial info and shows how to get it with JavaScript... there is no reference for VBA or Visual Basic. I've done some research and found that there's a way to get this kind of information from a site but i only found VBA example for MS Excel. I've designed my application in MS Access. Someone known how to get the information from a site?

 

[raskew]

Hi -

...but i only found VBA example for MS Excel ...

Would you point to the source of that example.

Thanks, Bob

 

[SergioRocha]

Hi! You can find the code on the attached file.
http://sergiorocha.home.sapo.pt/dive...oogleyahoo.xls

I really need help.

 

[marjdk]

Did you manage to solve this issue? If so, would it be possible to see your solution since I am having the same kind of problem.

 

[SergioRocha]

Unfortunately no... i still need help!!!

 

[chergh]

I had a quick look at the spreadsheet and you can use the functions without modification in access.

All you need to do is figure out how you want to pass the 'ticker' parameter to the functions and then write the values returned to the function to a table.