Develop a MACRO in EXCEL to Capture Running Values and then ADD a TIMER

Κλειστό Αναρτήθηκε Πριν 7 χρόνια Πληρώθηκε κατά την παράδοση
Κλειστό Πληρώθηκε κατά την παράδοση

Macro Requirement

1. I have a file in which stock prices come in from the exchange

2. The stock prices are dynamic and constantly changing

3. However, when a particular condition is fulfilled i.e. today’s Volume EXCEEDS Previous Day’s Volume, then I at that stage the constantly changing stock price i.e. LTP and other value ATP to be captured in a different cell in the worksheet.

4. After the constant ATP is captured, an indicator called SIGNAL is to be seen. If the Signal is LONG, then the changing ATP should be sustaining above the captured static ATP for continuously 10 minutes. If the Signal is SELL, then the changing ATP should be sustaining above the captured static ATP for continuously 10 minutes.

5. The constantly changing ATP will give whipsaws. To give an example, consider the signal is LONG and hence the changing ATP has to remain above captured static ATP for continuously 10 minutes. It might happen that it remains above and then goes below and then again goes above and below. So, whenever the condition is LONG and changing ATP is above captured ATP, there should be a timer. The timer should get reset and again start each time it is breached i.e. UP and DOWN. Only when the timer successfully completes 10 minutes without any reset i.e. constantly changing ATP stays above the captured static ATP for 10 minutes (which the times will say), then next to the cell where it has captured static LTP and static ATP, it should say for that row, ATP exceeds 10 minutes and give a message box.

6. There shall be 400 rows in the excel sheet.

Am not enclosing the file here. However, having given the logic, the file can be created.

Excel VB.NET Visual Basic

Ταυτότητα Εργασίας: #11596479

Σχετικά με την εργασία

8 προτάσεις Απομακρυσμένη εργασία Ενεργό Πριν 7 χρόνια

8 freelancers κάνουν προσφορές κατά μέσο όρο ₹1754 για αυτή τη δουλειά

schoudhary1553

Dear Project Poster, I have relevant hands on 5 years of experience .We have a team of all the skills. I assure you about the work quality and time delivery. Please give me chance to complete this project. I Have Περισσότερα

₹3000 INR σε 1 μέρα
(191 Αξιολογήσεις)
7.0
abhinovpankaj

Hello, I have been working as freelancer since last ~ 3 years,prior to this was working with a MNC as an Sr. Software Professional. The project is Product based development and integration of the product with vari Περισσότερα

₹1750 INR σε 1 μέρα
(48 Αξιολογήσεις)
5.5
prabakarm23

I have 7 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 Server databases. And also I Περισσότερα

₹3333 INR σε 5 μέρες
(48 Αξιολογήσεις)
4.6
anithamuthu3

Fine to meet you soon see

₹1000 INR σε 5 μέρες
(0 Αξιολογήσεις)
0.0
expertchamber

HI, 1000+ Excel order Completed. I am 5 years Experienced Excel proficient. I have been working here last 5 years.I have earned 10 on 10 Rating in Microsoft Exam by the Microsoft Corporation. will provide these s Περισσότερα

₹650 INR σε 1 μέρα
(0 Αξιολογήσεις)
0.0
mythocalos

A proposal has not yet been provided

₹1250 INR σε 5 μέρες
(0 Αξιολογήσεις)
0.0