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...
Bookmarks