+ Reply to Thread
Results 1 to 2 of 2

programming live feed data

  1. #1
    Forum Contributor
    Join Date
    05-09-2009
    Location
    Chicago, US
    MS-Off Ver
    Excel 2003, Excel 2007
    Posts
    188

    programming live feed data

    hello everyone, i am just learning vba and my ideas are way ahead of my vba programming capabilities. here is my new idea, something i hope is possible with vba:

    i import live feed data into excel spreadsheet from my trading program, and it looks something like this "=TOS!msft" in each cell.

    so if i have a few cells in the first row of such data, which changes maybe every second (sometimes more often)....is there a way for VBA to look for any changes (in any of the cells) and if it spots a change, it pushes the values before the change took place to the 2nd row, so the "freshest" data is on the first row. and once that changes again, it'll push that to the 2nd, and the 2nd row to the 3rd...and just do this all day long and make a little database.

    i dont even know where to begin with something like this, so hopefully someone will be able to tell me if this is possible and if it is, how difficult of a project it would be.


    thank you all!

  2. #2
    Forum Contributor
    Join Date
    05-09-2009
    Location
    Chicago, US
    MS-Off Ver
    Excel 2003, Excel 2007
    Posts
    188

    Re: programming live feed data? help needed

    or i guess instead of telling excel to "look out" for a change in cells, we can just tell the VBA to put each new stream of data it gets from the outside program in a new row. i'm just trying to brainstorm and get the ideas out as i have no clue if either one is possible...
    Last edited by losmi8; 02-15-2010 at 09:14 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1