Dear friends,

I have a set of stocks which are being valued on sheet1 of an excel file on real-time basis.

The value of the portfolio is being reflected in cell A1 of sheet2.

I want to monitor the value of the portfolio on a minute by minute basis and platting of a graph.

Can someone help me on how I can have the time in column A (starting in cell A3 downwards) at a one minute interval and the value of the portfolio in column B (starting in cell B3 downwards). Accordingly I can plot a graph.

Many thanks in advance...