Discount Broker Comparison

Popularity (Ranking) of Brokers in India.

Based on Alexa Ranking I have compared some of the brokers and found Indian Ranking as follows.

Zerodha and RKSV being a known name and active in the Traderji forum, they are still at top and ranking first and second respectively. Others are

(c) Wisdom capital : position : 37745

(d) TSO : 43869

(e) RK Global : 45460

(f) SAS : 56474

(g) Achievers : 60452

(h) VPS: 123345

(i) Procon : No Ranking at all.


Despite Advertisement in CNBC by some brokers like Achievers, Wisdom capital standing tall among other brokers. Needless to say Wisdom Capital started @ Feb 2013. Does that means its going to become another Zerodha story for future?

source : http://www.alexa.com/search?q=wisdomcapital.in&r=home_home&p=bigtop

In the latest version,
Paste this formula in CELL B38 and copy it till CELL Q38



This will fix the repetition issue.

Hi, bpr,
A little suggestion,
In that excel 37 th row which indicates diff. You can set diff 0 for number 1 ranking holder and the cumulative differences one by one. Now a days no one want to look at loosers like RKG or Bezel (most of the times).
And there is a little error too why RKG is set as zero. For some other brokers when total charge is higher than them is in negative shown in Red also.

Another suggestion,
Brokers like VPS, SAS, WC, RKSV etc most number of times ranked higher. They are performers. They must have privilege for early columns in main chart not like RKG, Bezel looser. I am saying so bcoz now number of columns are more and I need to scroll to see the winners even with 1920-1080 resolution. :rofl:

There is little error in formulae in the blue table so that some time 'diff from pre' is showing zero value which is wrong. That's why cumulative difference of two consecutive rank holders also showing same which is also wrong bcoz of added zero value from previous col 'diff from pre'.

Whenever you get time make that excel better. It is an asset. :thumb:

If I am not wrong u r with bezel and RKG give me the details for currency futures or validate the data.

To your third point,
I don't fully understand the issue. If possible please post a screenshot and indicate the error so that we can understand.
Diff from pre column can be zero when the brokerage cost between 2 plans is exactly same i.e they have the same rank.

--------------
Thank you for updated excel 1.7 that error is already fixed.
Here was the error in previous version 1.5.

I think you didn't get it.

It was not an error. It was zero because the difference is ZERO. Since it was a zero there is no change cumulative difference. I guess you would understand now...

I think you didn't get it. It was an Error. The difference was not ZERO. The difference was Rs 585.

I guess you would understand now...

It's not an error. It just says that the difference is "0". We have to work other way around to avoid the repetition.

:rofl::rofl::rofl:
Yes. I understood now.
Really, thanks for the effort you put to make me understand the error.

I thought you were mentioning this again. But now I noticed that the particular cell's formula is wrongly entered.