Завершено

Microsoft Excel Logs

Hello,

I have an Excel worksheet that receives live changing market data feed.

I am looking for a method to do the following:

1) Log any cell that changed values either above +10 or below -10.

2) Log the time that the change occurred.

3) Scan for changes every 250 milliseconds

An example:

Cells M1 to M22 are receiving live data feed that is constantly changing.

At 9:25 am cell M13 changes values from +5 to +11.

At 9:27 am cell M13 changes value from +11 to +4.

At 9:40 am cell M13 changes value from +4 to +20.

At 9:40 am cell M17 changes value from -1 to -30

Expected result:

A log file generated with the following information:

- Cell M13 went over +10 at 9:25 am

- Cell M13 went over +10 at 9:40 am

- Cell M117 went under -10 at 9:40 am

Thanks.

Квалификация: Excel

Показать больше m1, live excel data, excel data feed, scan excel, logs, excel worksheet, feed excel, live feed excel, time log excel, file microsoft excel, excel macro example filling cells, excel java example, excel macro filling cells, processing logs excel, excel pricing example, visual basic scripts excel copy data cells, excel macro search cells, excel macro comparing cells, vsto excel vbnet example add, excel macro copy cells

О работодателе:
( 7 отзыв(-а, -ов) ) Sherman Oaks, United States

ID проекта: #7077456

Поручен:

TonmoyRoy111

Dear Sir, I ensure you of completing the project within the specified time. I have a previous experience of Data Modification work in Excel using Macro. Besides I am an Electrical Engineer and currently working in Больше

$35 USD за 1 день
(9 отзывов(-а))
2.7

21 фрилансеров(-а) в среднем готовы выполнить эту работу за $34

Teloquence

A proposal has not yet been provided

$50 USD за 0 дней(-я)
(257 отзывов(-а))
7.2
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 220 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive Больше

$50 USD за 3 дней(-я)
(47 отзывов(-а))
5.5
sonarkaushik

Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have done lots of these kind of projects and will deliver flawless work Looking for further discussions in this reg Больше

$48 USD за 3 дней(-я)
(34 отзывов(-а))
5.4
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas and macros. Check my reviews. They speak for themselves. Best regards

$45 USD за 3 дней(-я)
(26 отзывов(-а))
4.6
paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your pr Больше

$69 USD за 4 дней(-я)
(30 отзывов(-а))
4.5
vsprybhanu

Hi, Experienced VBA, VB6 and VB.Net Programmer. Expertise in Data Entry, Data Processing, Excel and Programming. Read and understood your project description. I've excellent knowledge of moving data arou Больше

$45 USD за 3 дней(-я)
(18 отзывов(-а))
3.6
abhinovpankaj

Hi, I am working as software professional in IT industry from last 4 years. I work on VB scripting along with VBA for MS office applications. Also developed various Desktop based application using Visual Studio Больше

$35 USD за 1 день
(6 отзывов(-а))
3.4
prabakarm23

Greetings for the Day!!! I have 6 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Serv Больше

$40 USD за 1 день
(12 отзывов(-а))
3.2
akshay175

Hi, I am an expert in MS Excel, MS Access, SQL database production and management. I have over 7 years of experience in working with all of the databases and analytics. I can write a vba code to do all this and set th Больше

$35 USD за 2 дней(-я)
(4 отзывов(-а))
2.9
epservsolutions

Hi, We are an experienced (6+ years of industry experience), highly dedicated and a proactive team of Developers, Designers and Social Media Marketing experts. We are working extensively in ASP.NET, PHP, HTML, V Больше

$50 USD за 1 день
(1 отзыв)
2.0
hussainsheikh124

dear sir I am computer sciences graduate student and interest on your project will provide you the qaulity work just contact me regards hussain

$35 USD за 1 день
(2 отзывов(-а))
1.5
jithendrak

A proposal has not yet been provided

$25 USD за 5 дней(-я)
(0 отзывов(-а))
0.0
aslampasta

Professional and Timely service.

$10 USD за 3 дней(-я)
(0 отзывов(-а))
0.0
vw7095966vw

To whom it may concern, I have the necessary Excel and VBA coding skills required to produce a solution for you. This file is it stored on some web or ftp site? What format do you require the created log file to b Больше

$35 USD за 1 день
(0 отзывов(-а))
0.0
webappstar412

Hello, sir. I have just received your project. i have 30 programmers. We have many experiences completing the same as your project. We hope that you'll hire us. Thanks.

$35 USD за 3 дней(-я)
(0 отзывов(-а))
0.0
shahzebansari04

A proposal has not yet been provided

$30 USD за 2 дней(-я)
(0 отзывов(-а))
0.0
amina153

Dear Sir I have necessary sort of expertise to make up microsoft excel logs properly. I ensure that you will get the best service from me in the proposed time. I am waiting for your kind reply.

$15 USD за 2 дней(-я)
(0 отзывов(-а))
0.0
kapekape

HI I AM AN EXPERT IN EXCEL, VB AND MACROS please send me a message so that we can have a dialogue SKYPE = kapekmonho I am available now you can access my cell phone number from the freelancer site See example in Больше

$14 USD за 1 день
(0 отзывов(-а))
0.0
ranajitvw

Hi, I am an ex-banker with vast experience of data entry works in excel/word. I assure you sincerity and accuracy of performance. Thanks

$15 USD за 2 дней(-я)
(0 отзывов(-а))
0.0
mahsa54

A proposal has not yet been provided

$35 USD за 1 день
(0 отзывов(-а))
0.0