+ Reply to Thread
Results 1 to 2 of 2

How to Record Incoming Stream of Data

  1. #1
    Registered User
    Join Date
    08-31-2023
    Location
    Hokkaido, Japan
    MS-Off Ver
    365
    Posts
    1

    How to Record Incoming Stream of Data

    This forum has been very helpful in my work and I finally decided to register to ask for help.
    I have an incoming real-time stream of data from a platform however, the platform only provides 300 rows of data each time, and as newer rows of data comes, the past ones are deleted. However, I need to be able to save the past rows of data as well to have a better understanding of the data.

    If any one has experienced a similar problem before, please share with me how you solved it. What I did was I made a macro that runs every second to copy and paste the 300 rows of data then it deletes the duplicates. The process is repeated however the data is pasted below the bottom row then deletes the duplicates. It works for now however, sometimes the process of deleting duplicates tend to delete some essential duplicate data as well.

    Is there a way where the data is constantly pushed down so as to have one continuous stream of data instead of 300?

    Thank you!

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,623

    Re: How to Record Incoming Stream of Data

    You probebly shall not just delete duplicates, but try to find in the already recorded set where the position of current 300 rows starts.

    you could try starting with checking if the bottom 300 in main set is identical with new 300
    if not whether bottom 299 is identical with first 299 of 300
    if not whether bottom 298 is identical with first 298 of 300
    and so on
    so in case of sample (8 instead of 300)

    main
    c
    a
    b
    a
    a
    b
    c
    a
    b
    a
    c
    b


    a
    b
    a
    c
    b
    a
    e
    a

    start with comparing all new with red (equal count) part in main a and b fits but then is a difference c/a (if there woud be no differences then there was no new data recorded)
    so we take 1 less from top in red main and compare with 1 shorter at bottom of new set. it immediately shows not to fit because b is not a
    so we take one more less from red and again one shorter from new . again immediately c is not a.
    again one less in both (resp top and bottom) and these sets compare exactly the same. we add remaining (not included in comparision) 3 bottom elements of the new data
    a
    e
    a
    to the bottom of main set and we are ready for new process
    Best Regards,

    Kaper

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Stream data from excel to Weebly website
    By IVOptionAnton in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-13-2014, 05:00 AM
  2. Maximum and Minimum values from data stream
    By casery in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-27-2013, 09:25 PM
  3. [SOLVED] Advice on how to structure calculations for an incoming stream of data
    By sa02000 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-10-2012, 06:41 AM
  4. Time Stamping Incoming Data
    By SDruley in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-23-2011, 03:13 PM
  5. Refresh All Workbook Data - incoming data insert properties
    By dnnr in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-26-2007, 11:14 AM
  6. [SOLVED] Live incoming data
    By peter z in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-25-2005, 12:05 PM
  7. [SOLVED] Data Stream Converter ??
    By Dan Thompson in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-22-2005, 03:06 PM

Tags for this Thread

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