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
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
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
21 фрилансеров(-а) в среднем готовы выполнить эту работу за $34
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
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.
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.