That's 'Share Trade Tracker'. An excel spreadsheet you can buy. The cumulative total, though, is custom chart added by @Skate, but the dashboard and the buy/open/sold tables are part of the provided package.
Dump it Here
- Thread starter Skate
- Start date
That's 'Share Trade Tracker'. An excel spreadsheet you can buy. The cumulative total, though, is custom chart added by @Skate, but the dashboard and the buy/open/sold tables are part of the provided package.
- Joined
- 26 May 2009
- Posts
- 45
- Reactions
- 42
Well, checked it out appears to be discontinued and not available for sale anymore.
That's interesting. I only bought it last month, so news to me! Let's hope this wont affect any current users.
- Joined
- 3 May 2019
- Posts
- 6,224
- Reactions
- 9,755
Just a quick word.
Mr Skate, the educational value is there for others in many respects.
Unfortunately, I didn't get to download the phantom PDF file you posted late on a Saturday night, I clicked the file but it was gone....
Opportunity has been like trying to grasp smoke lately.
The gap between the here and now and the elusive doesn't fill for many here, including myself.
That's where you provide pieces to a puzzle.
We're all looking for that edge, for which due to human nature, the goal posts are constantly changing.
Thank you for your efforts. The rest is up to us.
Mr Skate, the educational value is there for others in many respects.
Unfortunately, I didn't get to download the phantom PDF file you posted late on a Saturday night, I clicked the file but it was gone....
Opportunity has been like trying to grasp smoke lately.
The gap between the here and now and the elusive doesn't fill for many here, including myself.
That's where you provide pieces to a puzzle.
We're all looking for that edge, for which due to human nature, the goal posts are constantly changing.
Thank you for your efforts. The rest is up to us.
- Joined
- 26 May 2009
- Posts
- 45
- Reactions
- 42
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
this one right?
- Joined
- 28 December 2013
- Posts
- 6,362
- Reactions
- 24,248
@soren_lorensen all the metrics & graphics are from Share Trade Tracker (discontinued from sale). The advantage with Share Trade Tracker was the ability to add extra worksheets to the workbook & linking the formulas.
Skate.
thats the one.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.
this one right?
I guess they wont be incorporating my suggestion into the next version lol.
- Joined
- 28 December 2013
- Posts
- 6,362
- Reactions
- 24,248
@Warr87 if you have any questions about Share Trade Tracker you can email: support@xlautomation.com.au
Share Trade Tracker will no longer be offered for sale
After 9 years and hundreds of releases, XLAutomation is sad to announce that Share Trade Tracker will no longer be offered for sale on the XLAutomation website. While the product is considered a worthwhile tool by many of our dedicated users we have been unable to attract a sufficient number of subscribers to make the continued development and support a profitable activity for our business.
What does this mean for you as an active subscriber to Share Trade Tracker?
1. XLAutomation will honour your existing subscription of Share Trade Tracker & provide support until the expiry of the existing subscription
2. At the end of that subscription you will retain access to Share Trade Tracker for life
3. After all subscriptions are expired we will no longer offer support for Share Trade Tracker as a product
When will this start?
1. From Monday 9th of November, 2020 we will remove Share Trade Tracker from our site for sale
2. We set all existing subscriptions to expire on the next renewal
After the expiry of your subscription
If you continue using Share Trade Tracker after the expiry of your subscription & require support you have the option to approach XLAutomation directly via their consulting services. This is available for any feature that already exists in Share Trade Tracker or new functionality that you would like to include to the existing spreadsheet. We realise this may be surprising and disappointing news for our loyal subscribers to Share Trade Tracker. Be assured that XLAutomation has not taken this decision lightly given the time & effort that has been invested in the development of Share Trade Tracker.
Skate.
thanks for the clarification!
- Joined
- 28 December 2013
- Posts
- 6,362
- Reactions
- 24,248
The Daily Panda Strategy
(a) After reading the posts above - it's worthwhile for me to keep posting daily updates for the PANDA Strategy.
(b) I didn't want to keep posting daily updates for the sake of posting.
(c) Thank you for the replys.
Skate.
- Joined
- 12 January 2008
- Posts
- 7,215
- Reactions
- 17,881
Thanks again @Skate for posting the Panda System trade details. I have been looking at the effectiveness of the entries. Ehlers DSMA is an indicator that I've not examined so I've been curious. My curiosity has been satisfied, thank you.
I do enjoy seeing your application of the systematic trading process. It's very elegant and effective. My trading process feels clunky and much more time consuming in comparison. Seeing your process makes me want to improve mine.
btw: The ROC > 20 when used with my 1st BB strategy filters out many, many losing setups. I've been looking at it on the US markets and together the prospects seem much better. I'll never know for sure without back testing it properly.
I do enjoy seeing your application of the systematic trading process. It's very elegant and effective. My trading process feels clunky and much more time consuming in comparison. Seeing your process makes me want to improve mine.
btw: The ROC > 20 when used with my 1st BB strategy filters out many, many losing setups. I've been looking at it on the US markets and together the prospects seem much better. I'll never know for sure without back testing it properly.
- Joined
- 28 December 2013
- Posts
- 6,362
- Reactions
- 24,248
@peter2 realises this is a beginners thread & I try extremely hard to keep my posts to the sheer basics, chunking all my post. Sometimes more advanced members will take a deeper interest in developing their own skills to separate them from the average trader. By posting more technical information at times I believe goes somewhat to help them achieve this.
Ehlers mathematical formula - summary
I've placed my summary of "Ehlers DSMA" at the start of my post as understanding Ehlers DSMA is lengthy & at times dry & boring. So in summary, the DSMA is simply an adaptive moving average that features rapid adaptation to volatility in price movement. It accomplishes this adaptation by modifying the alpha term of an EMA by the amplitude of an oscillator scaled in standard deviations from the mean. The DSMA’s responsiveness can be changed by using different values for the input parameter period of which I found crucial when trading our Aussie market.
For those more technical in nature
To better understand the alpha term of an EMA you can reference this page for a clearer understanding - https://www.itl.nist.gov/div898/handbook/pmc/section4/pmc431.htm - otherwise don't get caught up on the technicals that Ehlers is so obsessed with.
The Panda Strategy relies heavily on Ehlers basic idea of "Deviation Scaled Moving Average" (DSMA)
John Ehlers - Deviation-Scaled Moving Average (DSMA) is simply an "adaptive moving average" with the unique feature of rapid adaptation to volatility in price movement. It's worth remembering that moving averages have two characteristics - (1) they lag & (2) they smooth data. But there are different ways to tweak them. DSMA is one way to make them more adaptive to current prices & make the smoothing heavier.
It's a mouthful & hard to understand
DSMA accomplishes this adaptation by modifying the alpha term of an EMA by the amplitude of an oscillator scaled in standard deviations from the mean. The DSMA’s responsiveness can be changed by using different values for the input parameter period & well suited to the Panda Strategy, being a trend-following system. Ehlers basic idea is valid but with most good ideas the parameter setting has been overused - thus negated. After saying this his "Technical Indicator" is a mathematical formula using the moving average of price but by adding a "volume relationship" lifts his idea to a new level helping to determine the probable direction of the price.
The DSMA is a data smoothing technique
Ehlers DSMA acts as an exponential moving average (EMA) with a dynamic smoothing coefficient. The smoothing coefficient is automatically updated based on the magnitude of price changes. In the Deviation-Scaled Moving Average (DSMA), the standard deviation from the mean is chosen to be the measure of this magnitude. The DSMA indicator provides substantial smoothing of the data even when price changes are small, while quickly adapting to these changes.
DSMA's design for those still following
The DSMA indicator has minimal lag yet is able to provide considerable smoothing. DSMA’s responsiveness is achieved by varying its lookback period, therefore, the standard deviation can be calculated as the square root of the average sum of the squares of the smoothed filter waveform over the input period. When you divide the root-mean-square (RMS) into the smoothed filter waveform, it scales the waveform in terms of standard deviations. When you start with alpha computed in terms of the input period & then multiply it by the variable deviations, it scales alpha both in terms of the input & current volatility
In terms of the current volatility
The scaling goes in the right direction at the right time. When the price deviation of the oscillator is large, the root-mean-square (RMS) is large, & consequently alpha is large. When alpha is large, there is "minimal" EMA filtering & the filter quickly adapts to the current prices. Conversely, when the price deviation of the oscillator is small, the root-mean-square (RMS) is small & alpha is small. When alpha is "small", the EMA produces heavy smoothing.
Reference
Even if the brilliance of Ehlers DSMA makes little sense at first - this post will serve as a repository of information of one of his better ideas.
Skate.
- Joined
- 28 December 2013
- Posts
- 6,362
- Reactions
- 24,248
Back to the basics
Technical indicators are mathematical formulas that use "price, volume & time" to help traders determine the probable direction of the price the security may take in the future. It's the relationship between the three that brings it all together. There are literally hundreds of ways to trade the markets, some much better than others - trend following is my all-time favourite. In saying this, you need to find an approach that you can borrow, test & then adapt to suit your own circumstances. I've spent countless hours in the early years backtesting data, refining the information & developing my own strategies.
Manage your Money, Risk & Trading Psychology
How? - By first having a deep understanding of "Money, Risk & Trading Psychology" - it pays to research all three. Also, you need to be aware of your emotional intelligence & how it can directly affect your trading & trading outcome. Once you have a clear understanding you can set about developing a trading strategy - going onto "fine-tuning" your entries & exits. In doing so it will give you the confidence in trading your own structured trading system.
Next - develop your "Trading Plan"
Your "Trading Plan" trumps your trading strategy. Your trading plan should encompass all your trading rules, "non-negotiable" rules that should be observed religiously. With any style of trading "technical analysis" is at the heart of all my trading decisions. Technical analysis is an important skill to master & doing so helps avoid all the drama so many other traders go through. To expand your potential you need to master these skills to trade more effectively. Miss one step & you could miss out on profits or worse - increase your losses.
Become a good decision maker
As with life, trading is all about making a series of decisions (unemotional decisions) & by developing a lock-tight system your trading will run more efficiently & effectively - our ultimate desire. Another skill is to learn how to stay motivated - how to create a set of goals. Keeping a positive attitude sets you on a path of obtaining a high-level of motivation. Developing self-discipline, plus self-motivation is essential in this game.
Self-praise is no recommendation
But in this case, it's true. With a mixture of educational posts & the shared experience of other members makes the "Dump it here" thread the perfect thread for "beginners" when they first start out on their perilous trading journey. This thread is an ideal first experience into the "world of trading" - outlining the dangers associated with trading. With the additional posts from senior members, contains many engaging valuable lessons that shouldn't be overlooked. Sharing sound knowledge is the DNA of this thread.
Skate.
Technical indicators are mathematical formulas that use "price, volume & time" to help traders determine the probable direction of the price the security may take in the future. It's the relationship between the three that brings it all together. There are literally hundreds of ways to trade the markets, some much better than others - trend following is my all-time favourite. In saying this, you need to find an approach that you can borrow, test & then adapt to suit your own circumstances. I've spent countless hours in the early years backtesting data, refining the information & developing my own strategies.
Manage your Money, Risk & Trading Psychology
How? - By first having a deep understanding of "Money, Risk & Trading Psychology" - it pays to research all three. Also, you need to be aware of your emotional intelligence & how it can directly affect your trading & trading outcome. Once you have a clear understanding you can set about developing a trading strategy - going onto "fine-tuning" your entries & exits. In doing so it will give you the confidence in trading your own structured trading system.
Next - develop your "Trading Plan"
Your "Trading Plan" trumps your trading strategy. Your trading plan should encompass all your trading rules, "non-negotiable" rules that should be observed religiously. With any style of trading "technical analysis" is at the heart of all my trading decisions. Technical analysis is an important skill to master & doing so helps avoid all the drama so many other traders go through. To expand your potential you need to master these skills to trade more effectively. Miss one step & you could miss out on profits or worse - increase your losses.
Become a good decision maker
As with life, trading is all about making a series of decisions (unemotional decisions) & by developing a lock-tight system your trading will run more efficiently & effectively - our ultimate desire. Another skill is to learn how to stay motivated - how to create a set of goals. Keeping a positive attitude sets you on a path of obtaining a high-level of motivation. Developing self-discipline, plus self-motivation is essential in this game.
Self-praise is no recommendation
But in this case, it's true. With a mixture of educational posts & the shared experience of other members makes the "Dump it here" thread the perfect thread for "beginners" when they first start out on their perilous trading journey. This thread is an ideal first experience into the "world of trading" - outlining the dangers associated with trading. With the additional posts from senior members, contains many engaging valuable lessons that shouldn't be overlooked. Sharing sound knowledge is the DNA of this thread.
Skate.
- Joined
- 28 December 2013
- Posts
- 6,362
- Reactions
- 24,248
Skate.
- Joined
- 17 October 2012
- Posts
- 707
- Reactions
- 1,389
For those wanting to research and play bit more with Ehler's DSMA, here are a few more links/resources to read and try. I'd also suggest setting up the DSMA period as a Param input field for Amibroker users - very quickly gives you a feel on price graphs how DSMA responds to short and long period values against other options such as exponential moving average, or plain moving average.
TRADERS’ TIPS - JULY 2108
Traders' Tips, a collection of code provided by developers to help implement trading ideas and techniques presented in the pages of Technical Analysis of Stocks & Commodities Magazine.
traders.com
- Joined
- 13 February 2006
- Posts
- 5,061
- Reactions
- 11,469
Moving past the basics.
1. Entries are as important as exits.
2. To have great entries/exits, traders must be able to identify turning points ahead of lagging indicators: proactive not reactive.
3. Turning points have different speeds.
4. The speed is correlated to the unexpectedness of the news, the pre-existing direction of trend and the general level of vol. that has prevailed.
5. Is the turning point a counter-trend in a continuing trend, or the end of the trend. You need to know, particularly if you are a long only trader.
To achieve the above necessitates going past the superficial data of the market that you are trading and finding the (a) internal dynamics of your particular market, (b) inter-market correlations that lead your market, (c) incorporating a macro-viewpoint that is consistent with your market, not for a timing of entry/exits, but the start and end of macro-trends, because (d) your mindset (bias) will trip you up if you are a bull in a new bear market and vice versa.
jog on
duc
- Joined
- 28 December 2013
- Posts
- 6,362
- Reactions
- 24,248
@Newt has posted some good resources to read more about Ehlers DSMA indicator - looking at new trading ideas from a few different angles is always valuable.
DSMA
The idea & the mathematics behind "Ehlers DSMA" is not new. Ehlers has a habit of twisting his earlier ideas & making them new again. Also, Ehlers DSMA indicator modifies the alpha term of an "EMA" whereas Tushar Chande, uses the RSI to adjust the alpha term to achieve similar results. Perry Kaufman, on the other hand, uses his "Effectiveness Ratio" to adjust the alpha term - meaning they all achieve similar outcomes using different indicators & methods. Why mention this? - For others to understand the logic behind the idea which is sound, solid & effective (to a point - I might stress)
The DSMA Strategy versus the "Panda Strategy"
What's the difference other than the name? Well, the DSMA indicator is the heart of the "DSMA Strategy" using the raw signals from Ehler's maths. The results aren't too "shabby" if you have the stomach to trade those signals. The Panda Strategy uses precisely the same engine to drive the strategy with the exception of additional "filters" & a few different parameter settings as-well-as @ducati916 volatility exit.
Mathematical gymnastics
The settings & parameters used by Ehler, in my opinion, has been overused & the edge "negated". Applying a little more mathematical gymnastics to Ehler's original idea turns the DSMA into a more stable & easier to trade strategy. I've called the new & improved version - the "Panda Strategy" for distinction.
The Backtest results
The backtest results between the "DSMA Strategy" & the "Panda Strategy" displays the differences (circled in red) a few improvements made. The proof is in the pudding.
Summary
I'm just saying, don't get carried away with an idea that has merits - just do your homework.
Skate.
- Joined
- 28 December 2013
- Posts
- 6,362
- Reactions
- 24,248
@ducati916 raises some interesting points that lead to this post. I was reminded by a "PM" today of the unique features of the CAM Strategy that goes hand-in-glove with Duc post "moving past the basics". Developing a single trading technique & using it all the time can sometimes be unhelpful dealing with varying market conditions such as the past few months.
Trading pullbacks in trending stocks
One of the tools @peter2 uses to his advantage is trading pullbacks in trending stocks. Reading his thread gives you an idea of how & when he uses such a method. Since the market does not trend all the time, you need a way to determine when it’s appropriate to trade pullbacks. Backtesting can yield insight into when to use this approach & determine what types of pullbacks & filters are most profitable.
High volume bullish bar
Peter recently gave an example of a pattern he likes - a high volume bullish bar (HVBB) & how using that pattern in isolation can affect your trading results saying: "I know that many short term traders want to jump right in immediately. It might work out or it may not. Jumping in without a plan or an acceptable RR is gambling"
Moreover
In that same vein of trading patterns (pullbacks) - In what market conditions should the pullback technique be used?
Knowing the answers to both examples, trading (HVBB) & (PB) can make you a more effective trader & lessen your risk.
Skate.
- Joined
- 12 January 2008
- Posts
- 7,215
- Reactions
- 17,881
I'll respond immediately. I trade the 1st and 2nd pull-backs when I've missed the start of the trend. I prefer to trade pull-backs when the market is going sideways to slightly up. In these conditions the W% of break-outs drops off and this becomes very frustrating. I reduce the angst and trade more pull-backs than break-outs.
In strong bull markets we can buy almost anything and make a profit.
My third group of trades is the reversal. I'm reminded of @rnr 's suggestion that reversals should only be traded when the market is starting to reverse after a significant dip/fall. I agree with this idea.
- Joined
- 13 February 2006
- Posts
- 5,061
- Reactions
- 11,469
Successful trading is informational advantage. Whatever your market, your edge lies in your informational advantage. What is an informational advantage? It is anything that gets you into the trade and out of the trade (far) ahead of your competition.
Some examples:
(a) inside information;
(b) speed of trade execution (front running measured in mili-mili-seconds);
(c) Market Makers (trade flow information and power to set the price);
(d) Quant AI algos;
Typically what we have:
(e) Pattern recognition
The better hidden the pattern, the higher the probability that it will work out as obvious patterns are targets for the above traders looking to leverage their informational advantage. In this day and age that probably means if you are a systems trader that your 'pattern' has to be something a little different. If it is not, it does not mean that it is non-profitable, but likely it will have lower numbers and rely to a far greater extent on really disciplined execution.
The two areas of disguise are, unsurprisingly, entries and exits. The stuff in the middle is pretty obvious even to complete novices. Strong entries have a further advantage to confer, they generally protect you from being shaken out of the trade prematurely, before it really takes off. An example: a sharp trend lower with a sharp reversal higher into some chop. Prices move higher or lower? In other words, a consolidation forming support or formation of a short (long) term top?
Some patterns:
(i) chart pattern;
(ii) chart pattern + technical analysis applied to chart pattern;
(iii) inter-market patterns (charts);
(iv) inter-market charts + applied technical analysis;
So all of the above will have +/- similar % of working out, given an unknown market trend. Add a market trend that is aligned with your pattern traded, that is recognised as such, that is an additional informational advantage. Go one step further, knowing the secular trend and the counter-cyclical trend. Informational advantage. Knowing that the secular trend is going to end? Informational advantage. All of those informational advantages are available to us.
These various patterns constitute a significant number of moving parts (no-one said getting rich was easy) to observe, interpret and integrate into a trading system correctly.
jog on
duc
Similar threads
- Poll
