Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    Join Date
    Dec 2007
    Posts
    4

    Question Unanswered: Can access import and store chronological streaming data?

    I have a online stock market broker through which we do trading through. They provide a software package which handles and displays live data and allows orders to be placed. Included with this software package is an API, which I have managed to display live data in excel with.

    What I want to do is record the live information into a chronological database so that I can do calculations based on whatever time period I specify.

    I have not used access for a few years and am wondering;

    1. Is this possible with MS Access?
    2. Is there a better database application to do this with?
    3. Where is the best place to start teaching myself the required information?
    4. Can anyone provide some keywords to help my Googling?

    Thanks in Advance

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    1. Everything is possible with Access :P
    2. "Better" is a subjective term. It really depends on your needs and what you are comfortable using. I personally think Access is the best all rounder.
    3. Not sure on that one. I learned "on the job" by reading real books. Web browsers didn't exist then!
    4. "Learning Microsoft Access" ?

    A "chronological" database is just a database with a date in it. Linking to live data is just a matter of connectivity, which you say you have under control anyway, so I'm really not seeing what you really need here.
    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

  3. #3
    Join Date
    Dec 2007
    Posts
    4
    Thanks for your prompt reply. I know I have a lot to learn with Access but I was hoping to fast track a little.

    My problem is that in Excel the cell is 'live' and constantly changing.

    I want to be able to record the value of the cell, with a date attached to it at a specified time interval and enter this series into a database. I would guess that the relationship between the date and data would be created upon the data being recorded in the relevant database table.
    I need to record the value at a specified time interval and enter it into the database table?
    What would be the most efficient way of achieving this in Access?
    Last edited by mememe99; 12-12-07 at 00:54. Reason: Make post more accurate

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Yes, I think that's the best way to go about it. You only need to record the value of the cell and the date IF the cell's value changes... of course
    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

  5. #5
    Join Date
    Dec 2007
    Posts
    4
    Could you point me to the command/code I would need to record the cell value at any specified time and enter it into the database?

    How would I make this happen regularly? Macro?

  6. #6
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    There are several steps.

    * Link the spreadsheet so you can examine the cell you want to track.
    * Make a "Cell Chronology" table to record the cell, it's value and the date.
    * Make a form which has it's Form Timer set to the time interval you want to use.
    * Write the On Timer event procedure to examine the cell's current value and compare it with your cell chronology table. If different to the last entry, write another entry along with the current date.
    * Open the form.
    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

  7. #7
    Join Date
    Dec 2007
    Posts
    4
    Thank you very much. You have saved me a lot of time and research.

    I second the credentials mentioned in your signature.
    Especially the "all round nice guy" bit.

  8. #8
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    ^^ You're very welcome!
    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

  9. #9
    Join Date
    Aug 2014
    Posts
    22
    Can we have a working sample of this please ?

    Thanks

  10. #10
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Quote Originally Posted by happy1001 View Post
    Can we have a working sample of this please ?

    Thanks
    seing as both parties haven't been on the forus since 2012 I suspect thats highly unlikely. but assuming you have the api to the stock market quote feed then its perfectly doable
    I'd rather be riding on the Tiger 800 or the Norton

  11. #11
    Join Date
    Aug 2014
    Posts
    22
    Quote Originally Posted by healdem View Post
    seing as both parties haven't been on the forus since 2012 I suspect thats highly unlikely. but assuming you have the api to the stock market quote feed then its perfectly doable
    Thanks for your reply healdem. Yes, I too was wondering whether such an old thread might generate any reply at all or not.

    I do not have the api but I have the subscription to the Live Streaming Data source, which can feed the data directly into the trading software and even into the Excel Sheets through RTD.

    Regards

  12. #12
    Join Date
    Aug 2014
    Posts
    22
    It is kind of hard to get those database samples that are directly related to doing the Stock Market Work. There are plenty of database samples available on almost all other topics.

  13. #13
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    If you can get the data into Excel, then you should be able to get the data into Access.
    if the worst comes to the worst get the data into Excel then pull it into Access. If your development skills are up yo it then run an instance of Excel within Access and do the dirty deed there. However it should be possible to use the same data feed that the Excel app uses and stuff it into Access.

    one of the outstanding strentghs of Access is its part of the MS Office 'family' so its fairly well integated.
    I'd rather be riding on the Tiger 800 or the Norton

  14. #14
    Join Date
    Aug 2014
    Posts
    22
    Quote Originally Posted by healdem View Post
    If you can get the data into Excel, then you should be able to get the data into Access.
    if the worst comes to the worst get the data into Excel then pull it into Access. If your development skills are up yo it then run an instance of Excel within Access and do the dirty deed there. However it should be possible to use the same data feed that the Excel app uses and stuff it into Access.

    one of the outstanding strentghs of Access is its part of the MS Office 'family' so its fairly well integated.
    Thanks for letting me know that it could be done, healdem. I agree about the strength part as well, it is indeed well integrated.

  15. #15
    Join Date
    Aug 2014
    Posts
    22
    Although I guess that MS-SQL might be better suited for this type of work, compared with MS Access.

Posting Permissions

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