Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open new record with selected fields from previous record | Excel Discussion (Misc queries) | |||
VBA code in one Module referencing Public Variables Declared inanother Module failing | Excel Programming | |||
Excel Data Record | New Users to Excel | |||
Record Macro - Record custom user actions | Excel Programming | |||
Need help autopopulating next new record with previous record data | Excel Programming |