+ Reply to Thread
Results 1 to 2 of 2

Getting excel to snapshot a cell every second and paste value into another column

  1. #1
    Registered User
    Join Date
    11-19-2013
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    5

    Getting excel to snapshot a cell every second and paste value into another column

    Hi

    I am using the following live feed to provide me with live bid, offer and last trading prices

    Bid Offer Last
    1800 1940
    1837.5 1838 1838
    6663.75 6665.5 6665.25
    30000
    400 450
    25150
    2030 2030
    16511 16514 16510
    2047 2048.5 2048
    23075 23124 23115
    1997.5 1998.25 1997.75

    i need to use the 'Last' column values to analyse moves and see if they are moving within a 2% tolerance. However, every time it trades the column changes to the trading value so I lose the previous value to compare.

    Is there a way that excel can snapshot every second the 'Last' cell into another column so I can monitor the values.

    Thanks

    Richard

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,910

    Re: Getting excel to snapshot a cell every second and paste value into another column

    To start storing values with time stamps in column A, and values in B,C,D, etc. Run StoreValueEverySecond to start the process, and StopIt to stop it. Assumes the code is in the workbook with both sheets, and the values are stored on the sheet "Data Storage", and the values are taken from a sheet named "Active" which has the active links

    Please Login or Register  to view this content.
    Last edited by Bernie Deitrick; 04-07-2014 at 04:20 PM.
    Bernie Deitrick
    Excel MVP 2000-2010

+ 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. [SOLVED] return a snapshot of a cell value at a designated time
    By Mokwit in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-16-2013, 01:25 AM
  2. Replies: 0
    Last Post: 08-28-2013, 03:23 PM
  3. Replies: 5
    Last Post: 08-20-2011, 04:14 PM
  4. Snapshot to excel
    By djfatboyfats in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-02-2008, 01:28 PM
  5. [SOLVED] how do I paste an excel column into one cell...tia sal
    By in forum Excel General
    Replies: 2
    Last Post: 06-08-2005, 11:05 AM

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