Setting Commission

Can anyone guide me how can I set commission in Amibroker for a particular broker.
a.) the normal brokerage is 0.3% and taxes are calculated on this value.
b.) brokerage per share cannot be less than Rs 0.10.

If possible please guide me to find some good FREE personal Portfolio Manager which is capable of managing at least 3 portfolios and show profit/loss at the end of the day by importing the stock values through internet.
Any help in this regard will be greatly appreciated.
Thanks.

Hello,

1. You can define commission (brokerage) via menu Analysis>>Automatic Analysis>>Settings>>General>>Commission & Rates section. Select Commission Table radio button and click "Define" button. In the Commission Table window that opens, fill 0.3 (or 0.3 + tax component) against "% of trade value", 0.1 (or 0.1 + tax component) against "Min. Amount" under "Default" section and click OK.

2. AmiBroker has a comprehensive Account Manager which will act as your portfolio manager and will perform the tasks that you wish to do. The Account Manager is accessible from menu File>>New>>Account. For more information on how to use the same, search user guide for words "Account Manager". User Guide is accessible by pressing F1 from within AmiBroker or from menu Help>>Help Contents.

I hope this helps.

Regards,

AmiBroker-India

Thanks for your prompt reply but the solution provided doesn't seems to be working for me. When is set the minimum value to (.1+tax component) then it works fine if i want to add just one share. But as soon as units bought increases more than 1 then Amibroker calculates the commission at the rate of (0.3% of unit value + tax component) which in my case comes out to be 0.47%.
Any other possible solution will be highly appreciated.

Let me add in a real example excluding the tax component.
Suppose I bought 100 shares @ Rs 17.7
With brokerage being 0.3% the brokerage per share should have been Rs 0.0531 amounting to Rs 5.31.
However since this value is less than Rs 0.1 therefore I will have to shell out Rs 10.00.
Now if we add the tax component to the same.
Usual commission should have been 0.47% of the total transaction cost that is equal to Rs 8.31.
But for brokerages less than Rs 0.1 it becomes component of number of shares bought and not the component of total transaction cost solely.
I have just downloaded trial version of Amibroker and would request seasoned users of Amibroker for their advise on some good free portfolio manager.

Hello,

Is this not what you want ? Can you please explain in detail about your requirement ? I just hope that you are talking about real-life scenario...

Regards,

AmiBroker-India

Let me quote the example here
I bought 100 shares @ 17.7 since brokerage per share comes out to be less than 0.1 per share i am being charged Rs 10 + tax components where brokerage is Rs 10
However when i set the %of trade value to 0.47% (ie;0.3% + tax component) and 0.1 for the min amount Amibroker calculates my commission as Rs 8.319.

Hello,

Now I got you. Here is the solution, in AmiBroker Account Manager itself. AmiBroker Account Manager has 5-tier commission levels to suit to your needs. When none of the tiers are used, the default is used. In your case, we will have to use 2 tiers, first one for charging Rs.10/- commission for all trades where commission works out less than Rs.10/- and 2nd tier, when commission value exceeds Rs.10/-.

To do this setting, go to File>>New>>Account. Go to summery tab first, expand Commission Menu and define first tier. Here we find that till the time transaction value is less than Rs.3333.33, commission should be set to Rs.10/- so we set tier unit as Transaction Value, tier min. as 0.01, tier max. as 3333.34 and per trade as 10/-. What it means is : till the time tier unit (transaction value) is between tier minimum (0.01) and tier maximum (3333.34), per trade commission of 10/- will be applicable.

Once done, now we move to tier 2 to define scenario for transaction amounts greater than 3333.34. Here we define Tier Unit as Transaction Value, min. as 3333.34, tier max as 100000 and % of trade value as 0.3%.
(Please note that this tier max you can put as per your actual tier limit, say if your commission decreases to 0.2% after your transaction value crosses 100000, you will put 100000 here in tier max and will define another tier 3 from tier min 100000 to further amount to have per trade commission as 0.2% and so on).

Once this is done, fund your account, and try a sample purchase. You will notice that your commission amount will be automatically set to 10 when transaction value is less than or equal to 3333.34 and once it crosses 3333.34, commission will be calculated @0.3% till 100000.

See the settings screenshot enclosed.

I hope this helps.

Best regards,

AmiBroker-India

Hi,
Thanks for all your kind help, but regretfully this doesn't actually solves the problem.
I would like to quote 2 examples
1. If 400 shares are bought @Rs20 here even though total transaction value is Rs8000 but still commission needs to be calculated by Tier 1 rules it however will exceed the set Tier Maximum Value and hence will be calculated in accordance to Tier 2 rules which would be a wrong commission value.

2. If 50 shares are bought @Rs 70 then the even though total transaction value is only Rs3500 but still commission needs to be calculated in accordance with Tier 2 rules and not Tier 1 which unfortunately it will do.

I was wondering if it is possible to set the commission rules using AFL.
Any other help in this matter would be highly appreciated. Thanks