View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Seaman Seven Seaman Seven is offline
external usenet poster
 
Posts: 1
Default VBA module for record data from datafeed

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.