Spreadsheet to plot data for dynamic chart in excel 2003.
I need a worksheet that will receive data and record it from four separate sites which all send real time numbers using the DDE format. The data that is sent will be numbers that represent monetary rates which are carried 4 places past the decimal point (i.e. [url removed, login to view]). These numbers can be brought into the worksheet using a special paste link which I can do myself. Also I need a cell that will show the time that the data from any of the four sites has changed (i.e. 22:40).
I believe the data should be arranged in columns with the first column being used for time (A2) and the next four columns (B2, C2, D2 and E2) representing the sites with the first row being used as a header. This could be needed to create a dynamic chart.
This is the point where I believe a macro needs to be written so that when a change in the data from any of the four sites occurs the data will be shifted down and a new row inserted automatically so a record of these events is built making it possible to create a dynamic chart.
The chart should be on a separate sheet within the workbook. I would like to see the price range on the left side with all four sites being represented with there own line in a line chart and the time indicator along the bottom like most stock charts if possible. I would also like the chart to cover a specific time frame preferably 24 hours.