Hi dispersion Many thanks friend. Still a long way before I can place a buy or sell order. @urusit "The rotation index/Quadrant Close , is calculated using data from the 4 and 8 profile. Since the 5d profile is consider to be the short tf. So the RI ...

Auction Market Value Theory & Analytics

Hi urusit Many thanks. I will get to work immediately. Kind regards Elroy

Auction Market Value Theory & Analytics

Mzvega, before i post the first 4 sentences, here is my new findings. Is my end result correct? Kind regards Elroy

Auction Market Value Theory & Analytics

This should read as T1 and T2 then it would made sense.

Auction Market Value Theory & Analytics

I am working on it. I forget to normalize my end result.

Auction Market Value Theory & Analytics

End result = 0.5 instead of 0.625 Is it correct?

Auction Market Value Theory & Analytics

About RI.

Auction Market Value Theory & Analytics

Hi Mzvega and Voketexpert Thanks for your reply. Now I am confused. Please shed light on path. Kind regards Elroy

Auction Market Value Theory & Analytics

By Better way, I mean a better command or layout in excel. In my previous post I have tried the If statement, but I have discovered the Frequency command in excel that got me to the end result. Is my end result (0.625) correct?

Auction Market Value Theory & Analytics

Attached

Auction Market Value Theory & Analytics

Hi people This is the Rotation Index(RI) worked out to the best of my knowledge in excel. Please share if you have a better way of doing it. Kind regards Elroy

Auction Market Value Theory & Analytics

Findings:

Auction Market Value Theory & Analytics

The question is frequent.

Auction Market Value Theory & Analytics

Hi Mzvega This is the only question/command in excel that I have, for now. Kind regards Elroy

Auction Market Value Theory & Analytics

Hi Weyk No problem friend. Good health for you and your family. Kind regards Elroy

Auction Market Value Theory & Analytics

Hey Weyk, it's that gentleman and not that guy.

Auction Market Value Theory & Analytics

Hi JR97 Thank you for your reply. I will try to explain the Rotation Index (RI), the best of how I understand it. For example, We have a 4 day range from 0 to 100. If you divide the range in 4 Quadrants, it will look something like this: Quadrant 1 ...

Auction Market Value Theory & Analytics

Good day Thanks for your reply Mzvega. Anyone else, to help a non software developer with an excel formula?

Auction Market Value Theory & Analytics

Good day guys. Please help with an excel formula.

Auction Market Value Theory & Analytics

More findings...

Auction Market Value Theory & Analytics