Results 1 to 8 of 8
  1. #1
    Join Date
    Jun 2008
    Posts
    16

    Unanswered: Download stock quotes

    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 Google 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?

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Can you post the link? I would expect the clever stuff to be "generic" VBA, not specific to Excel.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Yeah, shouldn't be too hard to modify Excel VBA to Access VBA, so if you post that up we can make some progress.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  4. #4
    Join Date
    Jun 2008
    Posts
    16
    Hi! You can find the code on the attached file.
    http://sergiorocha.home.sapo.pt/dive...oogleyahoo.xls

    I really need help.

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Is this the function you are referring to?

    Code:
    Public Function GetURLData(pURL As String) As String
        On Error GoTo ErrorExit
        Dim oHTTP As New XMLHTTP
        oHTTP.Open "GET", pURL, False
        oHTTP.Send
        If oHTTP.Status = "200" Then GetURLData = oHTTP.responseText Else GoTo ErrorExit
        Exit Function
    ErrorExit:
        GetURLData = vError
    End Function
    It might be a bit harder than I first thought ^^
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  6. #6
    Join Date
    Jun 2008
    Posts
    16
    Thank you StarTrekker that's a start. I'll investigate harder.

  7. #7
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    No no... all that is is a direct copy of a function within your database, it's not a proposed solution.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  8. #8
    Join Date
    Jun 2008
    Posts
    16
    Ohh i see! That might be one of the function. You can see details about Google Finance in here:
    Developer's Guide: Protocol - Google Finance APIs and Tools - Google Code

    The problem is that i don't find any reference about visual basic or VBA, only found Java and JavaScript.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •