Need Help finding top 10% of values for each date

Hello,

Beginner user here, I have dates and prices, multiple prices for each date, I found the max price for each date using the formula =MAX(IF($B$2:$B$23996=B2,$E$2:$E$23996)) where B is my dates and E prices, this gives me a column with the same value for each date, so I can then filter and compare the highest price of each day with other columns like time of day.

I'd also like to visualise the top and bottom 10% of prices using true/false values either in separate columns or using conditional formatting, i was thinking the percentile(if()) function would do it, but not sure i'm formatting it right. Tried using some suggestions from ChatGPT but none have worked.

Does anyone know how to do this?

thanks

Thanks.

The data I pulled is in B-H the rest of the columns are calculated from those. I'd like to find the top 10% of High and volume and the bottom 10% of low and Volume, but for each unique date,
so far I can only get it to mark the top 10% of the entire column.