Excel. Signal of achievement at the price of previous extremes

Oleg
Employer

[no-member:pro]Oleg[/no-member:pro]Oleg

1 projects
Closed
Project parameters
Type of cooperationOne-time project
Prepaymentprepayment is possible
Payment methodsElectronic money
Acceptance of requestsclosed
Project description
You need to create an Excel file to track and process the events of the previous extremes. The file is intended for a trader working with MICEX instruments.
Let's call it X-Signal.

Based on the price and time changes that are uploaded to it, X-Signal.xlsx should be able to:
Find the minimums and maximums of the price
determine the occurrence of an event reaching the extreme price (the current price is greater than or equal to the previous maximum, less than or equal to the previous minimum)
Work in real time and with history data
- to give an audible signal when an event occurs, as well as display events with a list sorted "the freshest from above"
Work independently with multiple tools, on different timeframes
- adjust easily and flexibly
Optimally use computer resources, do not brake on weak cars, run in Excel 2007
Project author: Oleg