Calculators Afrifocus Securities Pty Ltd – calculators by wpr1947

VIEWS: 21 PAGES: 2

									Afrifocus Securities (Pty) Ltd – calculators for use on website
Updated Tuesday, August 24, 2010
Active links with a short description of each calculator
Links will only work if you extrect the archive to a folder on your pc



Equities calculators
Compound interest
This is a simple spreadsheet to show you the value of compound interest. You can use this to see what your current capital
amount will be worth in a few years time if you invest it at a certain rate of return.

Instrument trading range – relative to the previous close
This spreadsheet shows you at what price levels an instrument should be trading when it is at a certain percentage above or
below the previous close. You select the previous close [or any level to be used as a comparison] and the price sensitivity
percentage and the sheet will show you the various price levels – including a graph of the same.

Money management
This guide shows you how important money management is when you are trading. It aims to teach you to think in terms of
probabilities. Your hot rate is the ratio of the number of winning trades to the number of losing trades. The higher your hit
rate – the lower the probability of a large string of consecutive bad trades. Once you saw what a number of consecutive bad
trades can do to your account you may want to adjust your risk per trade in order to protect your capital.

Brokerage calculator – Equities
This calculator shows you what your brokerage charges will be for equities trades. You enter the price and the number of
shares traded and it shows you the brokerage. Rates can be selected for both internet trades and for normal trades where
you call and speak to a portfolio manager.

Profit and loss – Multiple equity trades
This calculator shows the profit and loss summary for a number of equity trades. You can add up to 100 trades and then
view the performance of all the trades combined. By default you enter the number of shares and levels traded at; but you
also have the option of entering the dates traded at and then you can see both the real and annualised percentage return.

Goal seek – Trading cost Breakeven point for Equities trades
This calculator shows you at which price to exit a trade if you want to break even on your brokerage and not make any profit.
This would typically be used when your trade has gone against you.



Derivatives calculators
Brokerage calculator – Currency futures
This calculator shows you what your brokerage charges will be for various currency futures trades. The brokerage is based
on a sliding scale per number of currency futures contracts traded.

Brokerage calculator – Single stock futures
This calculator shows you what your brokerage charges will be for various currency futures trades. The brokerage is based
on a percentage of exposure traded. You enter the price and the number of contracts traded and it shows you what your
brokerage will be – based on the spot price.

Fair value and spot converge
This spreadsheet explains the difference between a spot price and a fair value futures price and how they converge over time
when nearing the contract expiry date.

Fair value calculator – Single stock futures
This calculator shows you hoe to convert a spot price to a fair value futures price. You enter the spot price, dividend
assumptions and the interest rate to calculate the fair value futures price.
Fair value calculator – IDX futures
This calculator shows you how to get to a fair value futures price in Rands when trading international single stock futures.
You enter the spot price in the foreign market and the exchange rate vs the Rand and the calculator will show you an
indicative fair value futures price in Rands.

How many contracts
This calculator show you how many shares or contracts to buy given your specific risk management parameters. This can be
used when looking at either technical or fundemental data to determine your entry and exit points. You input the entry price,
profit targets and stop loss levels; and together with your cash available and risk tolerance the calculator will show you how
many shares or contracts to trade.

Black Scholes options calculator
This is the option pricing calculator developed by the JSE. You can enter multiple option positions into the calculator.

Profit and loss – Alsi index futures
This calculator show you the nett profit/loss for index futures contracts. You can either use it for a single trade or enter up to
20 trades and view the combined results. You enter the number of contracts and the levels traded at. For an open position
you can also just enter the current price in order to view your running profit/loss for the open trade.

Profit and loss – Currency futures
This calulator shows you the nett profit/loss for a single currency futures trade. You select the currency, position and expiry
date and then enter the number of contracts and prices traded at. You can either use spot prices as an indication or enter the
fair value future prices that you have traded at in order to get an accurate nett profit/loss figure. For an open position you can
also just enter the current price in order to view your running profit/loss for the open trade.

Profit and loss – SSF futures
This calulator shows you the nett profit/loss for a single SSF trade. You select the currency, position and expiry date and
then enter the number of contracts and prices traded at. For an open position you can also just enter the current price in
order to view your running profit/loss for the open trade.

Profit and loss – SSF spot prices
This is more a transaction planner than just a profit/loss calculator. It combines a simple profit and loss calculator; account
and risk management and the position sizing all in one calculator. It also projects the nett profit/loss at different exit points –
you can enter stop loss and various profit levels. All prices entered and projections done are based ons pot prices only.

Profit and loss – Multiple SSF trades
This calculator shows the nett profit/loss summary for a number of futures trades. You can add up to 100 trades and then
view the performance of all the trades combined. You enter the number of contracts, contract expiry date, dates and spot
price levels traded at. You can also add an optional stop loss to predict the loss on open trades.

								
To top