insight, how do you import the data for analysis into your spreadsheet? do you get it from your trading app, or download from your clearers website? Presumably your spreadsheet is written such that it would only work with the data if it is presented in one of the above formats?
I think a wise choice for any trading vehicle is for the wannabe trader to decide what the true mission is: Do you wanna be a trader or a statistical genius? ....
Good points Patch. The comments are mostly brief so the 30 pages are mainly cut and pastes of charts for later review, but it still takes several hours a week. Time well spent for me I believe. Personally the area I can most improve at the moment are my exits, I'm spending a lot of time trying to improve them with my stock trading as I believe they are more important than my entries! I'm a VBA beginner but this is an area I can see value in learning, I know traders who use VBA extensively for their trading. Arbitrageur I import OHLC data which is very simple to do and this data is also easy to get from a number of sources. I get my data from one of my broking websites. My analysis mainly deals with correlations and patterns based on relationships with the OHLC data, so it's very simple stuff to do in Excel. I like this form of analysis as I can see patterns in a way I consider more objective than viewing charts and I can work easily in % terms. I sometimes have custom templates, if I'm examining a pairs trade for example I can download 10 yrs of data for a number of stocks into the same template and have all my criteria instantly examined.
Disagree, Making money is the most important thing, but return on capital is just as important. If you have 1mm and you are only making 500 a day then your return is terrible and you might be better off sticking that money in a fund that makes over 12% a year and let someone else do the work. It's not just making money, its putting your money where it will make you the most money possible.
MAE & MFE: maximum adverse excursion & maximum favorable excursion are probably my 2 closely monitored stats (& im not a great stats kind of person) these measure how much the position went against you (mae) and also in your direction (mfe). i think the guy with the long list may have touched on these??? usually a good idea to monitor these during system build without any predefined limits like a predetermined stop. i guess its only fair to point out though that i dont really trade systems or methods much anymore - im moving towards concepts - more freestyle or intuitive trading. i think anyone who has truly spent enough time behind the screens watching numbers and sticks jump around knows what im talking about (for a change ) i still monitor mae & mfe though. they are my benchmarks.
disagree (with some of that ). happiness is the most importnat thing. if you aint happy, i doubt you will make it. if $500 a day rocks your boat then fine.
no way amigo. you have to track your progress to see where you can improve. money management and discipline are key to long term success. Ill make a $1000 bet (not that anyone could really take the other side of that) that the guys who track all of these items daily, analyze them and use them wisely, make more than double what the people make who dont track thier trades.
Before I bother to measure anything, I always look at the equity curve for smoothness. If it's rough, I usually pass.
insight, Interesting thread. I always wondered what people do to keep track of whatever they do. I guess what I do is out in right field as usual. I have been keeping track of the quality of stocks in my universe. This assures that they are price performers and also "repeatable". That is they do the same thing over and over. I continually monitor the place in the trading cycle they occupy as time passes. This way I know three things continually: where they are; what is next; and how fast the cycle is operating in time. I rank my stocks by their contemporary money velocity (%gain in price per day. Think of it at two piles of stocks where what I own is on the left with the top rank on the bottom of the pile. On the right is the hot list that I have from me universe with the best money velocity on the top. I continually compare what is on the top of each pile. I cross trade from the owned to the hot list with money I make available buy selling the owned and buying the hot. The money velocity of a stock in a cycle peaks as the price goes through the axis of the cycle. This means I am buying stocks that are increasing in money velocity as they approach the axis and selling stocks as they decrease in money velocity after they cross the axis. Typical lower values of money velocity in this market are 4.5 %/day. A three day hold would be like going from 19 to 28 for a better money velocity stock. See the last two runs of IRIS. In a similar range see the last five runs of BOOM. When one keeps track of sets of stocks (by scores of 1, 0, and 7) Use three portfolios in clearstation.com (I label them 7's ,1's and 0's) which come from a list on stocktables.com sorted by increasing volume (bottom is the 1's, middle is the 0's and the top is the 7's). I just select the ones going through the trough of the cycle (1's to 0's (just before BO) to 7's (just aftr BO)) so I have from these 10 each a selection of HOT list stocks which make up my right pile. I keep a clearstation HOT list portfolio and I keep my owned stocks available by other means. Both these lists are displayed 24/7 on a bank of computers (google for pics of them) displays (70cm arc through over 90degrees). All have the envelope of future price showing on the right 1/3 of each item displayed with four indicators (all defaults modified to current data transmission speed levels). The hot list and owned displays are in two parallel columns and where % cange is automatically calibrated for visual comparison, analysis, decision making and acting. I have never used any of the items most people have listed in this thread. You may be able to discern that I have a different orientation which is making money. 1. Excellent universe. 2. sorted by the cycle centered on the trough. (Stocks move up the page of the sort as they come into view, approach the trough, cross the through and break out. 3. Repeatability. All stocks get to the tenured list by precisely repeating their money making characteristics. 4. HOT listings. 5. ranking potential buys best to worst 6. ranking owned for worst to best 7. using money velocity to determine timing of trades 8. Cross trading from poorest application of capital to best available appication of capital. Things that are uniportant to me that I see others posting about. 1. entry signals and strategies 2. exit signals and strategies 3. stop strategies and methods (I have posted on the 12 most frequently used-- it is just a commentary. 4. MA thinking. 5. money management 6. risk management. 7. trend following in the assinine Covel sense. The primary principal of making money is mathematically based. Their are several variables involved. In order of importance: 1. cycles per unit time 2. profit per cycle 3. money velocity There are some lesser variables: 1. initial capital. Using the top two major variables and the lesser variable, anyone can formulate the mathematical equation the prevails for making money. final capital = initial capital(1 +decimal profit percent)^annual cycles of capital use. Anyone can conclude that the graph of making money (money velocity depiction) looks like the out put of a multi-phase ac to dc converter. The graph of dc power distributed is the "equity" curve, a continuous (mostly linear) function starting at initial capital and sloped at the money velocity. If you are a beginner approximate it at 11.1 % every 6.6 days on your chart starting with your present capital. Shift it upward by 20 % if you spend a half day working the screens with me using your method. One important note. If you do not have white space on the right of each of your charts presently and have the envelope of future price projected there using channels by now, please put me on ignore from here on out. You do not pass the test of being able to perceive that you need to know what the future ball park is for what you are looking at. You are literally up again a mental wall that is blocking your mind in such a way that you cannot build it in any way to learn how to make money. The objective in trading and investing is to make money. The normal stocks to have in view as you do this are making money at a rate of about 5% a day, 250 days a year. Use this standard on your excel sheets to see how efficient you are. The list takes 5 seconds to bring up on your screen.