Australian (ASX) Stock Market Forum

Dump it Here

Jump to new
frugal.rock said:
Remember, it's not your brokers decision, its the market depth and availablity.... partial or full... that's Mr Market.

Step to the front of the class for your knuckle rap....

It's a weekly system, there's no reason you can't leave a standing order in for the week.
Yes, it's breaking Skates rule, but Skates rule is generally intended only for not chasing the price higher.
If you are going to break the rule, change it up to suit your style, but don't abandon the intent the rule creates, as it's not your system.
:2twocents
Click to expand...
I'm all caught up now the recalcitrant stocks have now been purchased.

All good, the lessons are being learnt. I was well aware that an order can be partially filled at market and at whatever price is the going rate, however I wrongly assumed that the rules would be different for a limit order where you are placing conditions on the the order.
 
Mr Skate,
I am contemplating the idea of purchasing Share Trade Tracker.
I seem to remember mention of a 6 month trial for ASF members.
Is this current?
Cheers.
 
frugal.rock said:
Mr Skate,
I am contemplating the idea of purchasing Share Trade Tracker.
I seem to remember mention of a 6 month trial for ASF members.
Is this current?
Cheers.
Click to expand...

@frugal.rock there was not enough interest to develop a special version of Share Trade Tracker for forum members thus the 6-month free trial was not implemented.

Try Share Trade Tracker free for 15 days (No credit card required!)

Trading Spreadsheet | Record Track Analyse | XLAutomation

A share trading portfolio spreadsheet to record your trading activities. Includes automated updates of share prices, historical price information & display of those to a dashboard to report on performance.
xlautomation.com.au xlautomation.com.au

Norgate Data

Norgate Data - Share Trade Tracker Integration Overview

norgatedata.com

Skate.
 
Last edited:
Share Trade Tracker - 12 benefits
1. Share Portfolio Tracking has never been easier!
2. Track multiple portfolios from any exchange around the world
3. The Upload Trades is a time-saving benefit for new users to upload multiple trades, or for traders making large numbers of trades frequently.
4. Dashboard updates automatically when you add, delete, or update prices, to display the key indicators of your portfolio performance.
5. Add, update or delete shares quickly & accurately with easy to use pop-up forms.
6. Benefit from Find & Select forms allowing quick & easy search for specific securities or trade types in your workbooks.
7. Better analysis with custom charts to show net unrealised & realised profit/loss and display best and worst-performing stocks in your portfolio.
8. Automated retrieval of share prices & dividends including franking credits & franked % for Australian shares.
9. Profit/Loss and % Gain/Loss automatically recalculated, and custom stop loss / take profit warnings are included to support your trading model.
10. The Custom Ribbon makes navigation easy, displaying all commands to control your worksheets.
11. Worksheet & Dashboard filtering helps you analyse particular aspects of your trading.
12. The brokerage can be set on a Portfolio basis allowing for different Broker arrangements and more time saved

Reports
Keep your accountant happy with custom reports providing a summary of your past financial years trading, costs and dividends.

"Share Trade Tracker Subscriber Guarantee"
1. Price Guarantee - No price increases for as long as you stay subscribed
2. Free Support - We aim to exceed your expectations when you need help
3. Free Upgrades - Subscribers get all updates, fixes and new features for free

Skate.
 
Skate said:
Share Trade Tracker - 12 benefits
1. Share Portfolio Tracking has never been easier!
2. Track multiple portfolios from any exchange around the world
3. The Upload Trades is a time-saving benefit for new users to upload multiple trades, or for traders making large numbers of trades frequently.
4. Dashboard updates automatically when you add, delete, or update prices, to display the key indicators of your portfolio performance.
5. Add, update or delete shares quickly & accurately with easy to use pop-up forms.
6. Benefit from Find & Select forms allowing quick & easy search for specific securities or trade types in your workbooks.
7. Better analysis with custom charts to show net unrealised & realised profit/loss and display best and worst-performing stocks in your portfolio.
8. Automated retrieval of share prices & dividends including franking credits & franked % for Australian shares.
9. Profit/Loss and % Gain/Loss automatically recalculated, and custom stop loss / take profit warnings are included to support your trading model.
10. The Custom Ribbon makes navigation easy, displaying all commands to control your worksheets.
11. Worksheet & Dashboard filtering helps you analyse particular aspects of your trading.
12. The brokerage can be set on a Portfolio basis allowing for different Broker arrangements and more time saved

Reports
Keep your accountant happy with custom reports providing a summary of your past financial years trading, costs and dividends.

"Share Trade Tracker Subscriber Guarantee"
1. Price Guarantee - No price increases for as long as you stay subscribed
2. Free Support - We aim to exceed your expectations when you need help
3. Free Upgrades - Subscribers get all updates, fixes and new features for free

Skate.
Click to expand...
Really need to give it a go,my spreadsheets are working but time is precious..
 
Skate said:
Share Trade Tracker - 12 benefits
1. Share Portfolio Tracking has never been easier!
2. Track multiple portfolios from any exchange around the world
3. The Upload Trades is a time-saving benefit for new users to upload multiple trades, or for traders making large numbers of trades frequently.
4. Dashboard updates automatically when you add, delete, or update prices, to display the key indicators of your portfolio performance.
5. Add, update or delete shares quickly & accurately with easy to use pop-up forms.
6. Benefit from Find & Select forms allowing quick & easy search for specific securities or trade types in your workbooks.
7. Better analysis with custom charts to show net unrealised & realised profit/loss and display best and worst-performing stocks in your portfolio.
8. Automated retrieval of share prices & dividends including franking credits & franked % for Australian shares.
9. Profit/Loss and % Gain/Loss automatically recalculated, and custom stop loss / take profit warnings are included to support your trading model.
10. The Custom Ribbon makes navigation easy, displaying all commands to control your worksheets.
11. Worksheet & Dashboard filtering helps you analyse particular aspects of your trading.
12. The brokerage can be set on a Portfolio basis allowing for different Broker arrangements and more time saved


Skate.
Click to expand...

Looks very interesting...does it offer unitization? If not, how does it account for cash inflow and outflow not effecting portfolio P&L?
 
MovingAverage said:
Looks very interesting...does it offer unitization? If not, how does it account for cash inflow and outflow not effecting portfolio P&L?
Click to expand...

@MovingAverage I'm unsure of your meaning of "unitization". Share Trade Tracker accounts for cash inflows & outflows with ease as each worksheet includes its own entry form that can be linked to any portfolio.

Other income
The "Other Income" worksheet lets you record refunds, rebates or any other income received related to trading activities. To 'Add' the Other Income record select 'Other' from the ribbon and then 'Other Income'.
sharetradetrackerhelp.xlautomation.com.au

Share Trade Tracker Help - Other Income

The Other Income worksheet lets you record refunds, rebates or any other income received related to trading activities. To 'Add' an Other Income record select 'Other' from the ribbon and then 'Other Income'.
sharetradetrackerhelp.xlautomation.com.au sharetradetrackerhelp.xlautomation.com.au

Request a free trial

Trading Spreadsheet | Record Track Analyse | XLAutomation

A share trading portfolio spreadsheet to record your trading activities. Includes automated updates of share prices, historical price information & display of those to a dashboard to report on performance.
xlautomation.com.au xlautomation.com.au

Plans from only $19 per month!
1. No lock-in contracts.
2. Flexible to cancel at any time
3. Fully interactive help files & STT even has its own forum
4. Share Trade Tracker site Map - http://sharetradetrackerhelp.xlautomation.com.au/system/app/pages/sitemap/hierarchy

Share Trade Tracker Capture.JPG

I've added hyperlinks that will answer most of your questions (with GIF animation)
Summary
I trust this is a comprehensive answer - even though I didn't totally understand the question.

Skate.
 
I started the Spec portfolio with 40K and after a short time it had earned 4K in profits. This makes the performance +10%. When I add 10K cash to this portfolio to increase the number of positions this changes the performance % value. Is still 10% or is it only 8% as the capital amount has changed.

One way to calculate the performance of an account that has many deposits and withdrawals of capital is to calculate the VAMI. VAMI can be calculated using any time period, commonly monthly. I don't know how Share Trade Tracker does their VAMI calculation but if it's a proper VAMI then it would have to include unitisation.

The Spec portfolio started with 40K units at 1.00 each. At the end of the first month the account had grown to 44K so the current unit value is 1.10. Adding 10K to this portfolio does not mean there's an additional 10K units added to the portfolio. The new deposit is divided by the current unit value to determine the additional units added to the portfolio (only 9090.9). I would have to add 11K to the original capital to maintain the current unit value at 1.10.

The VAMI calculation should keep track of the current unit value and use this value as the divider in every deposit and withdrawal of capital to ensure a consistent performance report.
 
Share Trade Tracker VAMI Report
The VAMI (Value Added Monthly Index) is an industry measure of trading performance. The index tracks the monthly trading performance of a hypothetical $1,000 investment. It takes into account the trading profit and loss, income, dividends and costs for your portfolio.

Share Trade Tracker includes a VAMI chart and data table
The VAMI chart provides a visual display of the monthly performance and within the data table, the actual calculations are listed for further analysis and understanding. If needed you can set the Starting Investment Amount to be any value and the index calculation will start from that value. You can also use the Filter to display the VAMI for a specific Portfolio or a group of Portfolios.

Understanding Value Added Monthly Index (VAMI)
A value-added monthly index chart the total return gained as well as reinvestments. VAMI is one of the most commonly used metrics to depict a fund's overall performance. VAMI's popularity stems from the fact that it is quite descriptive, in that it shows an investor how $1,000 has performed over a given period, and that it is easy to understand. Comparing individual portfolio's performance couldn't be easier.

The Action Strategy VAMI Chart

Action Strategy VAMI Capture.JPG

Skate.
 
julo said:
Hello Skate,
I've noticed that you use unadjusted data. Is that an intention?
Click to expand...

@julo, I have 3 Silver Norgate data subscription packages & it was an intentional decision to downgrade from a "Platinum" Subscription to "Silver" as it matter of cost. My strategy development days are over & the Platinum Subscription was in excess of my current needs.

Strategy Development
It should be noted - the development of all my strategy was conducted using the Platimum Subscription package that included Historical Data that includes the "Current and Past watchlist".

Beta Testing
I didn’t take up the Platinum package that was available to me as a Norgate Beta Tester.

F.Y.I
1. For strategy development using Amibroker you certainly need Norgate's Platinum Subscription package
2. When trading a strategy using Amibroker all you need is the Australian Stocks (Silver Package) - the package I have

Skate.
 
Skate said:
@julo, I have 3 Silver Norgate data subscription packages & it was an intentional decision to downgrade from a "Platinum" Subscription to "Silver" as it matter of cost. My strategy development days are over & the Platinum Subscription was in excess of my current needs.

Strategy Development
It should be noted - the development of all my strategy was conducted using the Platimum Subscription package that included Historical Data that includes the "Current and Past watchlist".
Click to expand...

Hi Skate - the casual reader would think your strategy development days are far from over from the number of strategies both weekly and daily you've mentioned this year! :)
Unless of course most were hatched years ago and only "matured" recently?
 

Similar threads

Garpal Gumnut
Very nice Rain here today
2 3
Replies
42
Views
3K
SirRumpole
SirRumpole
tech/a
  • Poll
Financial Independence (Home Ownership, Super, Long Retirement) not possible for wage earners: What do we need and how do we get it?
8 9 10
Replies
191
Views
15K
divs4ever
divs4ever
ducati916
November 2024 DDD
2 3
Replies
53
Views
4K
ducati916
ducati916
basilio
Ozempic: Magic Pill or Devils Bargain?
Replies
10
Views
1K
sptrawler
sptrawler
sptrawler
Competency and trying to maintain standards
2
Replies
27
Views
3K
sptrawler
sptrawler
Top