live data

  1. A

    Copying excel rows from live data

    Hello - I am trying to copy real time data in subsequent rows whenever the data gets updated. I am using the following VBA code. This updates irrespective of any change. I only want it to change when the time stamp in cell A2 is updated. Any suggestions on how can I update this code? Private...
  2. J

    Importing a graph from the internet to Excel

    I'd like to import graphs from webpages to Excel. E.g. many webpages show intraday stock prices and I'd like to include some in a "dashboard" style worksheet that can be up-dated. Is this possible with Excel?
  3. T

    How to create a continuous VBA program sub

    I am uploading live-data from bloomberg onto excel, and that data contains the date/time (i.e. 7/8/14 6:01pm) and a stock price. Since it goes in real time, after each previous date/time and stock price, whenever new data becomes available, it is constantly being added below the previous...
  4. J

    Flash/Blink Cell Color Based on Live Changing Values while Keeping Background Color of the Cell the same.

    I have this excel document with a Finansu Add-in that pulls live stock feeds from Google Finance. As of now, if the % change is negative overall then the cell is red and if it is positive it is green. I want to find a way to make it so if the stock changed from 1% down to .5% down the cell will...
  5. bmckenna

    Can't insert anything and charts missing???

    Hey all, Opened up Excel to work on a macro-enabled, with live oracle and SQLi connection workbook, and all my charts are gone, and I cannot insert anything from pictures to charts, they are all greyed out. Yes, connections and macros are enabled. This happened before, and after fiddling with...
  6. S

    Help with saving logged live data

    Hi! Thanks to your help on my previous posting, I'm now able to successfully log live data continuously. Now I'm trying to save a chunk of the logged data to a csv file in a certain location with a certain date when certain conditions are met-- for example when row 30,000 is reached, I'd like...
  7. S

    Help with logging live data

    I'd like to log live update data continuously,i.e. as the data in the cell changes. The problem I'm facing is that the data comes in at uneven intervals-- ranging from 30 to 50 ticks per second. So I can't really use a timer function. I need to use some function which saves the data as the cell...

Some videos you may like

This Week's Hot Topics