Forum Discussion
mtthplysr
Mar 24, 2022Copper Contributor
How to calculate amount needed to get to max percentage
Hi everyone, So I am working on an excel sheet for my investments. What I would like to calculate is how many assets I need to buy to have the transaction costs be max. 2% of the total sum. I...
- Mar 24, 2022
mtthplysr Not sure about your maths as a transaction cost of 4 on a purchase of 50 equals 8%. Not 29%. But perhaps I have misunderstood.
If you now want to limit the cost %, you can use a formula like:
Y / max % / X = n
Used in your example that would be 4 / 0.02 / 50 = 4.
To check it, buy 4 at 50 = 200. Cost % = 4 / 200 = 2%
Riny_van_Eekelen
Mar 24, 2022Platinum Contributor
mtthplysr Not sure about your maths as a transaction cost of 4 on a purchase of 50 equals 8%. Not 29%. But perhaps I have misunderstood.
If you now want to limit the cost %, you can use a formula like:
Y / max % / X = n
Used in your example that would be 4 / 0.02 / 50 = 4.
To check it, buy 4 at 50 = 200. Cost % = 4 / 200 = 2%