-
Aug 21st, 2011, 03:05 PM
#1
Thread Starter
New Member
[RESOLVED] Excel: recording data with Real Time Data Feed DDE
Hello, I'm new to VBA and this is my first post.
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 2 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.
.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|