conditional format on price reversal

[suresh kannah]

Hello Team

Need conditional format on price reversal ,the details are mentioned in the attachment.

Thanks
Suresh

 

[Villalobos]

Hi,

Check this is Ok for you!

 

[NARAYANK991]

Hi Suresh ,

Your requirement is not clear.

There are 3 prices , the Pivot Point , the day's Open , and the day's Current.

There can be more than 2 situations , as follows :

• The day's Open is above the Pivot Point , and the day's Current is also above the Pivot Point
• The day's Open is above the Pivot Point , but the day's Current drops below the Pivot Point
• The day's Open is below the Pivot Point , but the day's Current rises above the Pivot Point
• The day's Open is below the Pivot Point , and the day's Current also remains below the Pivot Point

This is only considering the relationship of the day's Open and the day's Current vis-a-vis the Pivot Point , and not considering the relationship of the day's Open vis-a-vis the days Current.

Which of the above 4 should be colored GREEN , and which should be colored RED ?

Narayan

 

[suresh kannah]

Mr.Narayan

Yes there are multiple situations,Wanted a sample so that i can tweak

There can be more than 2 situations , as follows :The day's Open is above the Pivot Point , and the day's Current is also above the Pivot Point

If the current price is above the pivot it will be green and in case drops below the pivot it becomes RED.

The day's Open is above the Pivot Point , but the day's Current drops below the Pivot Point

if the current price goes up the pivot and drops down then it has to red.


The day's Open is below the Pivot Point , but the day's Current rises above the Pivot Point

if the current price is abobe pivot it changes to green


The day's Open is below the Pivot Point , and the day's Current also remains below the Pivot Point

then the CP will be red

Hope i have clarified.Thanks for your time
Suresh

 

[NARAYANK991]

Hi ,

This means that the day's Open is not considered in the CF ; if the Current price is above the Pivot Point , the value should be colored GREEN , and if it is below the Pivot Point , the value should be colored RED.

Is this correct ?

Narayan

 

[suresh kannah]

Mr.Narayan

Yes you are right,
The current price keeps changing dynamically as it fetches the live data,

Thanks
Suresh

 

[NARAYANK991]

Hi ,

In that case the file uploaded by Villalobos does the job.

Narayan

 

[suresh kannah]

Mr.Narayan

where can i find the file.

Thanks
suresh