S
Seaman Seven
Hello, I have a simple problem: create a historical record from a live
on-line data feed on Excel.
Here is the problem:
1. Excel Workbook with 2 worksheets: "DataFeed" and "Record"
2. The "DataFeed" worksheet has 3 Cells with Data Feed from Internet
continuously updated every second:
Cell A1 = Time Cell A2 = Quote
3. The "Record" worksheet is empty and I need a VBA module to record
the content of Cells A1 and A2 (from "DataFeed" worksheet") to Columns
A and B every 5 minutes
If the VBA module starts working at 09:00:00 till 09:55:00 I will get
12 rows of data on "Record" worksheet:
On column A I will have: A1=09:00:00; A2=09:05:00; A3=09:10:00 ...
On column B I will have: B1=Quote at 09:00:00; B2=Quote at 09:05:00;
B3=Quote at 09:10:00 ...
I think the problem is clear and objective.
on-line data feed on Excel.
Here is the problem:
1. Excel Workbook with 2 worksheets: "DataFeed" and "Record"
2. The "DataFeed" worksheet has 3 Cells with Data Feed from Internet
continuously updated every second:
Cell A1 = Time Cell A2 = Quote
3. The "Record" worksheet is empty and I need a VBA module to record
the content of Cells A1 and A2 (from "DataFeed" worksheet") to Columns
A and B every 5 minutes
If the VBA module starts working at 09:00:00 till 09:55:00 I will get
12 rows of data on "Record" worksheet:
On column A I will have: A1=09:00:00; A2=09:05:00; A3=09:10:00 ...
On column B I will have: B1=Quote at 09:00:00; B2=Quote at 09:05:00;
B3=Quote at 09:10:00 ...
I think the problem is clear and objective.