I have these data types
A: Stock : Traded Volume
B: Stock : Total Put and Call volume
C: Stock : Total Open Interest
Weights all equal
A:1
B:1
C:1
say I have 50 stocks I wish to rank them in best possible option liquidity ranking.
I though this formula might do it
SORT A highest to lowlest, rank stocks 1 to 50, with 1 being highest
SORT B highest to lowlest, rank stocks 1 to 50, with 1 being highest
SORT C highest to lowlest, rank stocks 1 to 50, with 1 being highest
Then to get overall ranking to this : RankA + RankB +RankC
So if a stock hard a perfect highest ranking it would be :
RankA + RankB +RankC =3
and the worst ranking would be :
RankA + RankB +RankC = 150
*****************
The above gives equal weight to all data types.
Question, is should I weight the data sets like this
A: 0.5
B 1.5
C: 0.75
Any ideas how to do this better??
A: Stock : Traded Volume
B: Stock : Total Put and Call volume
C: Stock : Total Open Interest
Weights all equal
A:1
B:1
C:1
say I have 50 stocks I wish to rank them in best possible option liquidity ranking.
I though this formula might do it
SORT A highest to lowlest, rank stocks 1 to 50, with 1 being highest
SORT B highest to lowlest, rank stocks 1 to 50, with 1 being highest
SORT C highest to lowlest, rank stocks 1 to 50, with 1 being highest
Then to get overall ranking to this : RankA + RankB +RankC
So if a stock hard a perfect highest ranking it would be :
RankA + RankB +RankC =3
and the worst ranking would be :
RankA + RankB +RankC = 150
*****************
The above gives equal weight to all data types.
Question, is should I weight the data sets like this
A: 0.5
B 1.5
C: 0.75
Any ideas how to do this better??