Visual basic for Excel 2007, Streaming data and create data lists that shall be filtered, marked and sorted

  • Posted:
  • Proposals: 4
  • Remote
  • #45185
  • Expired
Manjunatha L.Abu Bakar Siddique K.Dawn F.Lotus D. have already sent a proposal.
  • 0


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).

New Proposal

Create an account now and send a proposal now to get this job.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.