After clicking on the Configure option on the Ribbon you will be presented with the Configuration settings. The first tab is for the management of the Portfolio's within Share Trade Tracker
Portfolios are used to organise and categorise your trades into groups. These maybe specific types of securities or a strategy that want to be able to monitor and assess for performance over time. The workbook is delivered with a set of default Portfolio's, you can change these or add to them or delete if required.
The brokerage approach can be specified for each Portfolio. This is designed to allow you to apply the different brokerage methods for each Portfolio. The Default brokerage option is set in the Trade Settings configuration tab and applies for all Portfolios that do not have their own settings. When a Portfolio has it's own settings you select that option and then specify the details to apply as each trade is added to Share Trade Tracker that option will be used to automatically calculate the brokerage.
Exchanges
Exchanges are used to match a securities "symbol" to the right home exchange when the updating prices. Getting the right Exchange Code is really important as this will be used when the securities price is searched for on Yahoo. The workbook is delivered with a starting set of Exchanges and the "Yahoo Exchange Code". There should never be any need to change these values.
The "Familiar Name" will be the name of the Exchange that is displayed throughout the workbook. The "Yahoo Exchange Code" will be used as a suffix (eg BHP.AX) for the security symbol. This is then used when searching for that securities price and other information (eg Dividends).
Included to this form is access to a full list of Exchanges available on Yahoo. Click on that button if your Exchange is not included in the delivered list and then add those values. Once an Exchange is added it can then be used when recording Buy and Sell trades.
Click on the following
Exchanges page to see a full list of available exchange codes
Data Source
Note: Update Share Trade Tracker v3.4.7 and later - Default data source Yahoo
Share Trade Tracker includes automated price and dividend data updates. The data is sourced from various sites that offer a reliable feed to update trading positions. There are 2 separate data source configurations required one for Prices and one for Dividends.
Price - The default data source for Prices is Yahoo, this data source is based on the historical price data provided on the
Yahoo Finance site. For most Share Trade Tracker users this will be sufficient for your daily price update. For more details on the other options see
Price Data Source
Dividends - The default data source for Dividends for Australian securities is
ShareDividends, this is the only FREE source of dividend data available that provides franking credit and dividend details. For Overseas securities Yahoo is the default data source. For more details on the other options see
Dividend Data Source.
Trade Settings
The Trade Settings are configuration items used to make the process of Adding Buy and Sell trades easier and quicker. Lets step through each of these settings and where they are used.
Brokerage $ Value: This is the set Brokerage value that you pay per trade
Brokerage % of Trade: This is the % of a Trades value that you pay in Brokerage per trade
The Share Trade Tracker workbook allows for you to set each of your trades to use one of three (3) options for the default value of Brokerage. Even though this is the default value for Brokerage you can still change that value when Adding a trade. The options are
- Use the Brokerage $ Value only
- User the Brokerage % only
- Use the Maximum of the Brokerage $ Value or % of Trade
Share Trade Tracker provides for Stop Loss and Take Profit warnings on your Open Positions. Those warnings are driven by the Stop Loss and Take Profit values stored with each Trade. When you first create a Trade the Stop Loss and Take Profit values are calculated based on the % values included to the Trade Settings.
Stop Loss: % used to calculate Stop Loss (eg 10% for $1.00 would set $0.90 as Stop Loss)
Take Profit: % used to calculate Take Profit (eg 15% for $1.00 would set $1.15 as the Take Profit)
The final Trade Setting is another Stop Loss feature that allows you to monitor your trades using a stop loss value compared to the Maximum Price for that trade over the time that you have held it. Based on this value if the current Market Price for a trade is less than the Floating Stop Loss % then it will be highlighted on the Open Positions worksheet.
Floating Stop Loss: % is used to set the comparison value that is highlighted on the Open Positions worksheet
To Reset the Maximum Price for all Open Positions, select Reset Max Price. It will set the Maximum Price for each Open Position to the purchase price for the trade. From that point the Maximum Price will be set by the prices returned through
Update Prices.
Lastly at any time you can return the Default settings that were provided with the workbook by selecting "Reset Defaults". This will return the Trade Settings to the starting values.