Visual basic for Excel 2007, Streaming data and create data lists that shall be filtered, marked and sorted
- or -
Post a project like this$$
- Posted:
- Proposals: 3
- Remote
- #45185
- Expired
Description
Experience Level: Intermediate
I have made a workbook that I operate manually. Now I want to automate the same. You are free to choose your method as long as the objective is met.
I have tried to make a visual basic program, see attachment, but it does not work.
The objective:
I receive via an RTD-link in Excel 2007 a constantly updated index value between 9 a.m. and 17:25 p.m.. I want to make some lists:
A. 1 list for the index every 1 minute, eg. at 09:01:00, 09:02:00, 09:03:00 etc. containing the time and index
B. 2 lists containing the time, index and some calculated values, the 2 lists shall contain values at the following frequencies: 60 and 260 minutes. Eg. for the 60 minutes frequency that will be at 10:00:00, 11:00:00, 12:00:00 etc. While for the 260 minute frequency it will be at 13:20:00 and 17:25:00 (closing of the stock exchange).
I have tried to make a visual basic program, see attachment, but it does not work.
The objective:
I receive via an RTD-link in Excel 2007 a constantly updated index value between 9 a.m. and 17:25 p.m.. I want to make some lists:
A. 1 list for the index every 1 minute, eg. at 09:01:00, 09:02:00, 09:03:00 etc. containing the time and index
B. 2 lists containing the time, index and some calculated values, the 2 lists shall contain values at the following frequencies: 60 and 260 minutes. Eg. for the 60 minutes frequency that will be at 10:00:00, 11:00:00, 12:00:00 etc. While for the 260 minute frequency it will be at 13:20:00 and 17:25:00 (closing of the stock exchange).
Per Morten L.
0% (0)Projects Completed
1
Freelancers worked with
1
Projects awarded
33%
Last project
2 Mar 2011
Norway
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies