is retired now but still kicking like a horse!
Register for free to join our community of investors and share your ideas. You will also get access to streaming quotes, interactive charts, trades, portfolio, live options flow and more tools.
Register for free to join our community of investors and share your ideas. You will also get access to streaming quotes, interactive charts, trades, portfolio, live options flow and more tools.
OK Cowboy,
I have looked at that spread you linked to me and I understand what you mean:
B127 is the last data entry and B128 is still empty. . No problem!
On Row 128 there is no Data Entry yet so the calculation could not be done anyway, and I always duplicated the precious price in the cells below.
If the prices in B129 and B130 are filled in and B128 is empty then the calculation goes haywire in that spread too!.
I noticed that in that spread there is an Automatic Row Addition Feature installed.. . ARAF
I have not even learned how to do that! No doubt it is an simple statement. But below the last Row I have various information blocks, so if I ad rows I have to move these down first. . unless that can be done automatically too.
I need to read Excel for Dummies
Hallo Cowboy!
With the last thing first: The ALS is simply the Dutch version of IF in the Dutch Excel.
So, if the computer is configured with the Dutch Office 2000 any English Excel spreadsheet is automatically "translated" to Dutch Excel statements and also the changes in symbols are done automatically. . .even prices in which you would use a period . . .$45.76. . .for a decimal are converted to $ 45,76.
Of course, any remarks that are not part of the Excel functions remain in English
In my latest remark on this I mentioned that everything works if I get an English Excel spread. The point I made thereafter was that IF a calculation requires a number then IF that number is not given (blank cell) then the calculation can not proceed! I do not know yet what alternatives there are for this. For me it is no problem that an empty Cell is given a zero but often a 0 price give a calculation problem. . . That was my point for in many cases you create than division by zero.
I will check out later your suggestion in regards to:
As you can see even though B128 is blank, roll 128 does not have error messages.
Which appears to be a case in which a "missing" price(Empty Cell) is presented for a calculation. . .I will see if that relates to what I asked.
Is what you call "roll" the same as what I call "row" ?
I have not yet had any time to look into OpenOffice . . .I need 89 hours in a day to get everything done I want to do
I bought a scanner for my computer today but had no time to install it yet. . .was supposed to meet my son for lunch but he did not show up. . more hours wasted
Have not heard anything from him. I hope he is alright.
Problem is solved!
With the automatic translation of an English Excel to a Dutch Excel one this happens:
The problem that now remains is captured in the question I asked.
When the Cell in which a number for a calculation ought to appear is EMPTY the calculation goes haywire.
In the example I have made Cell B12 empty and the entire spread becomes useless because the calculation has no element that it needs.
So this function is not useful if one downloads data list and there is a missing number in it.
So the question becomes: "IF it is useless for the case that Cell B12 is empty, why is that statement formulated that way for Cell B12?
I would make more sense to have the empty cell be filled with a 0 so that one can see right away what is happening and you can fill it with the price B11 . .
Or even better. . .have this dome automatically:
=IF(B12=EMPTY,B12=B11,Calculation). . .
or something like that so that B12 is aromatically filled with the value of B11. . .you get the idea.
IF NOT: THEN at least I GOT IT
Hi Randy,
<Conrad: It is this part ,"", that gives the problem.>
We can not win this game. We are caught-up in the Plot of Fawlty Towers with John Cleese messing everything up, no matter how hard we try to make things work.
I tried them all with variations thrown in: two double quotes. . quadruple single quotes. . retyping the statements from scratch searching the Help File
It's a Plot to make me go Mad!
It won’t . . . I just give up!
And all this for something I had no intention to use
My main question has not been answered though. . .but there is no need for it. . .I can go to Clive’s Downloads and see HOW it works if a share value is calculated with the share price that is given from a cell with (,’’’’,) in it ?. . . .Does it read zero and makes a mess of all the portfolio values or what?
Please do not answer this question. . .it is rhetorical. . . .
I will look again at Clive Down Load Spread and find out the easy wayJ
AIMster, Thanks. I have a new question(please don't answer!)
You might consider Open Office - a freeware open source product that their "Calc" spreadsheet program is pretty well equipped feature-wise with Excel. . .
Does that mean if I type
=IF(ISLEEG(B29), ,tra;lalala))
it wil translate that automatically to
=IF(ISBLANK(B29), ,tra;lalala))
??????? or is CALC bilingual?
One day I will look at this Open Source Thing
Hahahaha . . .This is cute! . . . Lol!
The Englishman is telling the Dutchman that BLANK = LEEG
Thanks Clive. . . .you can solve every problem we encounter.
You ought to be paid € 55/hr for all that know-how you give away for free! How about setting up an On-line Consultancy with me and we accept any question that anyone can think of after they pay the € 55. . . average problem solving time = 1 hour! We split the Yield 50/50. . .you say that is an Optimum Ratio and I will take your word for it. . .Scout’s Honour!.
Now the question arises for me: Why is the English version not written as:
=IF(ISEMPTY(B29). . . Tra la la bv;ah b;a blal;h))
then I would have understood it right away!
It is an ENGLISH FLAW !!!!
I am not going to pay € 55.
No need to do that Grabber. I know the options to get around it, if I had to, but I do not need to. . .I do not use downloaded prices in Excel spreads. . No idea how to do that!. . .So I never use blank spaces where a number ought to be.
One day when I need it I will find out.
Now I have other things on my head but I do not get around to them. . .every time I turn around new suggestion appear on this Forum about how I could go about solving it
And since I do not want to be rude I feel obliged to explain that I no longer need any more suggestion
Grabber, you are missing 961 lines
You are cheating!
Hi Randy,
<Conrad: It is this part ,"", that gives the problem.>
We can not win this game. We are caught-up in the Plot of Fawlty Towers with John Cleese messing everything up, no matter how hard we try to make things work.
I tried them all with variations thrown in: two double quotes. . quadruple single quotes. . retyping the statements from scratch searching the Help File
It's a Plot to make me go Mad!
It won’t . . . I just give up!
And all this for something I had no intention to use
My main question has not been answered though. . .but there is no need for it. . .I can go to Clive’s Downloads and see HOW it works if a share value is calculated with the share price that is given from a cell with (,’’’’,) in it ?. . . .Does it read zero and makes a mess of all the portfolio values or what?
Please do not answer this question. . .it is rhetorical. . . .
I will look again at Clive Down Load Spread and find out the easy way
Grabber, I know all of what you are saying on the percentage issue, and I use both methods as I see fit. When I type X*Y/100 it goes very fast and I can copy it in 1000 rows and I do not get the nasty % symbol in the cells
To each his own!
Some men waste their time trying to catch a fish and then they throw it back. . . I think they do it because their wives want them out of the house on Saturdays and Sundays, and wives hate fisch anyway. . .what a waste of time that is!
When I want a fish I buy one and I do not bring it back to the store. . .I fry it! What’s so difficult about that?
Well, that last bit was a little white lie. I do not fry fish very often. . .once per 5 years at most. I mostly buy smoked salmon from Norway or smoked mackerel from the North Sea or smoked eel from the IJsselmeer or from the Haringvliet. . .that is a story apart. If you want to catch Haring you have to go to the North Sea. . .there is no Haring in the Haringvliet!
In the Haringvliet you can only catch eel and other sorts of fresh water fish, but they are contaminated with lots of Dioxins. . at least two per fish. . .because it is next to Rotterdam(heavy industry and chemical manufacturing), and the waters from Germany end up there too. . .
It’s illegal to sell fish with Dioxins(European Standards) so they are sold as fish from the IJssemeer, and because in the IJsselmeer the Dioxin levels are rather low everybody is happy. .the Fishermen can make a buck, the public thinks they buy Dioxin Free Smoked Eel, the Inspectors are looking the other way and drink a few beer when they are supposed to be inspecting, and the Government does as if they are from Missouri, so as not to cause the fishermen to go broke and or to upset the European Government.
I never throw back smoked fish
Grabber,
I tried. See Post No. 34142
The problem is probably that I need to search for the Dutch equivalent of ISBLANK.
The IF has to be ALS but I tried that too. The error lies in the symbol ,"", and I tried ,'''', and each time the hang-up comes back to that part of the statement.
If I download an English Excel program then the conversion to Dutch is automatic. . if I type in English words in the Dutch Spread it is rejected.
So the option is to get a spread from someone that is not an ON-LINE Version. . . On-line Excels programs are not "translated.
At the moment there is no need to panic. . It was just my curiosity that is killing me
I either have to search the Dutch Excel Help File or someone has to send be a short Excel spread via e-mail in which the statement is present.
E-mail = excel@vortex[remove this between[] ].demon.nl
The [fhghhfhfh] will fool ALL the robots
Please do not spend all your time to educate me on this. . .if you give me a hand I take your whole arm!
Ggrrrr!
I
AIMster,
=IF(ISBLANK(B29),"",(J29*D29)/100))
Does not work either: It is this part ,"", that gives the problem.
It is simply not recognised. I do not understand it.
We might as wel let it go. . .things like this give me a splitting head ache.
Thanks for the trouble.
RandyH
=IF(LEN(B29)>0,J29*D29/100,"")
Is not accepted in Excel for Office 2000!
Not to stir up the pot,. . .
Now that you did stir the pot I want to stir a bit too
You are quite right but I too use this xxx/100 quite often. When I am making up a spread I do not always know beforehand where the % column comes so t is easier to write X*Y/100 than to write X*Y and then go to the Formatting to use the % presentation. . .takes much longer and of you want to change the number-type for the column then you have to change it back again.
Ideally one should "design" a spread beforehand and then you can plan where you put what. . .many amateurs in Excel programming. . .like I am. . . do it the other way around and we save time on one column and lose 3x "the time" at some other place in the spread.
That's how it works for yours truly!
I understand you, but my point was that your option is a "back door" method, not being formally correct. . .if the stock price would be 0 you would not be having any shares in it, or at least you would not be maintaining your portfolio.
I see the method as a solution for a day that you do nor know the price and the program happily keeps running without giving you 0 share Value and 0 PV value . . .perhaps simply using the values of a previous line in the program. . . so as not to upset the Apple Cart
I will try the other methods that were suggested.
Grabber, Clive is always correct, unless he makes a mistake. . .he is human too
My question was how I could do that in Excel from Office 2000. . that statemen as Clive gave it creates an error and there is only a message that I should scheck the correctness of the statements. . .
Old #7
IF(B29>0,J29*D29/100,0)
I understand you but as you say this would not convey the meaning because if B29 is a negative number or 0 the result would also be zero and mathematically that would not be incorrect, so it would have to be something like this
IF(B29=EMP,EMP,J29*D29/100)
with EMP having the meaning for Empty Cell.
So the question is: how do I find that in Excel form Office 2000?
This type of searching is like looking for a word in a dictionary when you do not know how the word is spelled.
I have ran into that before. . .I did not know the correct search word so I ended up in vicious circle, not getting ahead with the job.
Of course I realise that this is like attempting to fix an engine if you have no idea how an engine works.
I will look at “Empty Cell” representation
Maybe EMP already exits as the correct answer. . .I will try it
No! It does not work
Still searching. . . . .tra la la. . .
=IF(B29<>"",J29*D29/100,"")
Mijn Excel (Office 2000)does not even accept this statement.
It would appear to mean that if B29 is smaller or larger than 1/100 of the product J29 and D29 then the cell would give 0 value, otherwise it give the value J29*D28/100. . .but the ""xxxxx"" is not accepted.
I wonder too what it means.
If I change it to
=IF(B29<>",J29*D29/100,")
then it does not work eiter but is accepted as
#NAME?
for every number in cell B29 (or nothing in it), where the statement is typed in.
The Wizzard Clive has done it again.
If you say something works better because you "fixed it" then I take you word for it! I think you area Wunder Kind.
Now a question:
If I have a document that deals with a bank statement would it not be just as simple to have a file called "Bank Statements" and have sub-files by year and month? The dates are the shown automatically in the Details Listing.
I must be missing something.
I always do.
Years ago I had a friend and he told me how he filed his documents.
On each documents he printed the subject, date and computer file name. So he could always find it back in his computer.
So I asked him: "But then you need a Paper Copy for every document in you computer".
"Of course, I have plenty of space here for filing cabinets. How else could I find things? My head is not a bloody computer".
I had no rebuttle.
Thanks Clive-I got it!
Clive,
On average B&H made 2% higher average yearly gains than AIM across all 1000 x 2 year random samples (9.5% AIM. 11.4% B&H) but did so with over twice the volatility (6.4% AIM stdev versus 13.8% B&H stdev).
Annualised AIM 9.4% versus B&H 9.9%
In this analysis you start out with the remark that ROCAR for AIM is normally higher than the B*H Yield.
In the above it was not specifically mentioned but I assume that these results are not the ROCAR yields for AIM. Are both these yields
AIM = 9.4%
B&H = 9.9%
based on the investments in equity so that the AIM yield is correctly compared to B&H yield?
I would have expected the AIM yield to be closer to 15%.
Performance SPY Portfolio 2011-Dry Run Optimised.
Start Investment 20000 1 January 2011
Cash= 14400;
Equity = 5600
Prices bases on (H+L)/2=Averages Day prices(1)
March 2, 20110
PV= 20232; No trades executed
Price Increase= 3,52 %
ROTAI Yield = 26 %. . . .(Does not include Reserve)
Earned on Reserve= 45,75 (2%)
(1) Average Day Prices are checked and is a trade occurs is it kept on the record for the date it occurred.
Dates in which no trade occur are eliminated to space on the Spread Sheet
The recorded dates are entered on a monthly basis.
This means that in principle the Yield is calculated for Daily Updates but that the Final Record shows mainly Monthly Data Sets.
Relative to an investment for which only once a month the stock prices are looked at the Yield would be higher because I do not miss the intermediate peaks and dips for which the Vortex AIM triggers a trade on the currently optimised parameters, but this would be the same as using GTC-Orders and not looking at the process at all.
Previous Post:
http://investorshub.advfn.com/boards/read_msg.aspx?message_id=59670853
Thanks for that AIMster! It's Gazz
I now got A Virtually Round Tuit
or was it something else . . .???
Yes, now I remember:
I Virtually got A Round Tuit
No.. No.. shit, that's was not it:
I got Virtually A Round Tuit
. . . but that is just semantics
Why is that?
The word "fraction" is not semantics to me. If the real shares would be 0,9*(Total Shares) than I call that a fraction.
A spade is a spade
Thanks. . .I am in a "pulling legs" mood.
Some times it happens that a leg comes off when it was not strapped on very well!
I am now an expert on Virtual Shares!
I thought that's what I've been saying! Yikes....
I had to find out what your comment mean and I found this as one from a dictionary:
Yikes:
(girl walkes by with really tight, ugly pants)
"yikes"
Steve. . .I am not wearing ugly tight pants! I think that would be Yukkie if I did!
(My remark was meant as a bit of humor . . .you had explained already that it was Standard AIM except for the start-up so I wanted to rub it in that if it quacks like AIM that's why it looks like aim
Thanks for the explanations!
Once I make PC twice or three times the actual shares bought I operate as a normal AIM program
I like to explain that I am not going to DO anything with LD-AIM. I am just trying to understand what others do with it. . . a different stick to whip the dog with will make the dog bark a different song
I think I got that first 2 or 3 "thing" via the virtual shares addition at the start, but then the extra number of shares will still be in the portfolio to keep the virtual value larger than the real value, affecting the subsequent trades
What I conclude from this is that as the Portfolio grows the fraction of virtual shares becomes smaller, eventually becoming rather insignificant so that you are essentially running a standard AIM.
Is that what is happening the way you run an LD-AIM?
Hi Grabber,
When I look at your Chart with the + and - symbols I would be tempted to bet that it looks like an AIM system
It might be interested if you could add the response of a Standard AIM starting out with the same real capital and then show the differences so that the benefit of LD-AIM can be shown graphically as well as numerically. . . that interests me.
LessFussy is your name from now on!
On the LD AIM your explained a few things to me that made me understand it to some degree.
You are adding a few guidelines for LD-AIM that in your opinion would make it work better. . . OK the exact details are not so important to me. . . I suspect that by tweaking the variable SAFE’s you can get LD-AIM "tuned" to what in your eyes may be effective for you. Something similar can be, and is done, with standard AIM( I call it SAFE -Tweaking) to make it respond different from Standard AIM.
So what I conclude from all this is that by using "virtual shares"
one simply alters various "parameters" so that you get:
Buy= (PC-V)*A. . . Relative to the Standard AIM
Sell=(V-PC)*B . . Relative to the Standard AIM
and you tweak the parameters till the values of A and B are approximately as you want them to be. If that is approximately a correct interpretation of LD-AIM then instead of using virtual shares you could just as well use some trade aggression factors relative to Standard AIM like this:
Buy=(PC-a*V) = (PC-V)*A
Sell=(b*V-PC) = (V-PC)*B
In this case the application of a simple aggression factor applied to the Equity Valve would have the same effect, for example you can represent it also like this:
Buy=(c*PC-V) = (PC-V)*A
Sell=(V-d*PC) = (V-PC)*B
Mathematically you can calculate the values of a,b,c,d as long as you know what you want the values of the “multipliers” A and B to be.
I am not saying that these alternative ways of calculating the trades will give the same result over a range of equity prices but what it means to me is that LD-AIM is one of the options one can use to increase or decrease the trade sizes in a particular way, relative to Standard AIM so that the Trade Advice to price changes is more in line with what an investor would want for a "particular portfolio", and by adjusting the parameters a,b, (or c,d or A,B,) in the options above the overall response will be "better" than Standard AIM would be in that case. . . This sounds like a logical conclusion.
In all this I presume does the PC updating us usual:
PC2=PC1 + 0,5*Buy. . . (for a Buy only, as it is done for Standard AIM)
or are you also using a variable there to get a more flexible PC-update form for LD-AM
PC2=PC1 + x1*Buy
PC2=PC1 - x2*Sell
This would give a great flexibility to LD-AIM and it would in my view be a very effective system in which you can tune the systems for various types of equity behaviours. . .if you wanted to do that.
Well, AIMster, if I have gotten the latest message from TooFuzzy, in which he was rather Crystal Clear, then I have finally understood the effect of Virtual Shares as Play Dough, and I add quickly that I do not say this in any demeaning manner. A spade is a spade... right?
If my remarks hereunder reflects my understanding of LD-AIM then the Group of Ignoramuses in regards how LD-AIM works has been reduced by at least 1. Now you have to be made to understand it yet
It is clear of course that in that case LD-AIM still "suffers" from Residual Trades being given out. . .but like it is so in many other human affairs, followers of a faith, or some belief structure, are prepared to "suffer" for their belief
I "suffer" to. . .I have promoted Vortex AIM till I was blue in the face, and still almost nobody likes to buy Vortex Aim, even though it is a bargain for the Real Dough pittance I am asking for it
I am just no good at making good sales pitches. . .I call a spade a spade.
Auch^2
That was not very fuzzy! I do not recall any body telling me that in such simple terms.
If that is the essence of LD-AIM then would result, relative to Standard AIM:
Buy={(PC-V)-sV)}*2. . . .Relative to the Standard AIM
Sell={ (V-PC)-sV}*2 . . .Relative to the Standard AIM
Of course, in practice due to also the SAFE Value s, I presume the LD-Trades would not always be exactly double the value of the Standard AIM but approximately so.
Considering that because also due to the correction sV the actual Trades may look something like this:
Buy={(PC-V)}*1,9. . or something like it, Relative to the Standard AIM
Sell={(V-PC)}*1,9 . or something like it, Relative to the Standard AIM
Possibly it may even be so that the multiplying factors would automatically be different for buying and selling, because Residual Trade Feature of the Standard AIM algorithm that creates different results for the buying and the selling.
Is this then not exactly like the Vortex AIM Trade Algorithm, in which the factor 1,9 or 2,1 (or whatever) could be set without the use of virtual shares???. . .I do not see the difference.
If so, then I congratulate Grabber for his LD-AIM, and I now understand the comments of Old No. 7 to me in regards that my efforts "taking profits a little at the time" were more or less the same as the efforts of Grabbers LD AIM
The reason I did not understand that is that, in my opinion, every AIMER has that effort as his goal.
It is the very essence of AIM.
Very interesting that you have discovered the AIM-Like Retirement Income Model Clive.
This is in essence exactly like the VORTEX AIM Model for generating Retirement Income if one already has a healthy portfolio in place.
The method is illustrated in the Dutch Version of my book on the Vortex Method but is also referred to in less detail in the English Short Version of the book.
Using the variable aggression factors asymmetrically one can set Vortex to regularly sell more share-value than is bought , creating retirement income regularly. Depending on the settings you can adjust the income level higher or lower so that in principle one can keep the investment base "constant". . .or reduce the value degradation rate. . . for a reasonably well behaved price development.
My normal parameter settings for creating Portfolio Growth is something like this:
Sell Aggression = 0,3 to 0,6
Buy Aggression = 0,6 to 0,9
For the Retirement Income Mode this is simply reversed:
Buy Aggression = 0,3 to 0,6
Sell Aggression = 0,6 to 0,9
This means that if the prices dips a bit lower than usual there are relatively strong Buy Opportunities at the dips and this will generate extra profits on the sell side, or to let the Portfolio grow, even when profits are taken out regularly.
It is simply an accelerated dynamic form of a Constant “Dollar” Investment Plan for which regularly monthly investments are adjusted +/- so that at a time of low prices no money is taken out, or even some extra money is put back in.
That sounds exactly the same, in principle, as what you have described. . .The only difference with the Vortex Retirement Mode settings is that the withdrawals and the reinvestments are not executed on fixed dates but are driven by the price peaks and price dips. . .reducing the share base with the smallest possible number of shares. One can even plan that the Investment Base slowly reduces in say 20 years so that one is 80 years old most of the Investment has been paid out
I have described this feature in Vortex on various occasions in the past but got little or no reactions to it.
Larry,
this is your investing method per your profile:
"Take the Profit and Run. . .a little bit at a time! . Don't wait for the big kill."
I am very glad you have made me aware that my Vortex Method is like Grabbers Low Down AIM(That is a complinment), which I did not know it was. I made clear I did not understand Steve's virtual shares and in doing so I use humour to rub in my ignorance on some subjects.
What do you mean to say with:
Even I can understand the system ?
Furthermore, I have in no way criticised Grabber's Low Down AIM. How could I, if I do not understand it?
Maybe it is because what I write is a bit confusing to you that you have interpreted some of what I say as critique.
That I am somewhat critical with respect to AIM BTB is known for about 10 years already but that has no bearing on anything Grabber has said about his LD AIM
Maybe this makes to it a bit clearer to you . . . I mean about how I tick.
If there is anything specific about what I have said about Vortex AIM or other AIM variants. . .(apart from my sardonic humour on some other topics). . .that you did not understand then please ask me about it and I will try again.
Grabber,
After some thinking abiut the vitual things that it must be something like imagined profits as proposed in the virtual theories of Gilles De LatouretI have formulated it as follows:
Numerous investors have advanced conceptions of Virtual Shares but prominent among these in continental investing has been De Latouret, who uses virtual shares to refer to an aspect of unreal investing that is abstract, but which is nonetheless real in some way. An example of this would be the meaning, or sense, of a share, which is not a material aspect of the investment (whether it be written or spoken or imagined) but is nonetheless an attribute of that investing. De Latourets’s concept of the virtual shares has two aspects: first, we could say that the virtual share is a kind of surface effect produced by the actual causal interactions of the investor with the Stock Market, which occur at the metaphysical level. Second it creates an illusion of security that arises from the intense actualisation the virtual profits that accrues from such an investment in the transcendental sphere of the imaginary investment so that the investor actually thinks he is really creating profits, which are of course not really real.
I do however understand Imaginary Numbers much better. Take this for example:
Z=Exp(i*pi -1/i^2.3)* e^i)
Z= -4.83888511 + 5.98531348i
I know this because imaginary numbers are just as real as real numbers!
Grabber, it time for me to bow out with dignity . . I have never understood any of this "virtual" share business even though I have tried to follow some of the discussions when this idea was invented. Somehow I apparently I do not have any affinity with "virtualities". Maybe I am too much of a realist. When some one says "I an virtually broke" then I have no idea what it means. . .they drive a car, drink booze and pay rent and I do all the things they do. . .well, maybe not all of them. . .some things I am doing for any money.
What the hell is a virtual share?
Is it Play Dough?
Monopoly Money?
Lego?
If you don't have equity then you are out of the game, mo matter what you call the play dough.
Get Real.
Don't go Virtual!
In Engineering they tried to teach me the Virtual Displacement Method for finding deformation of loaded structures.
They failed.
I know it Grabbie
I think you and I are more "In line" than we realise now
I read Lichello's book after I had read the "Money Spinner" and had started experimenting with AIM.
Generally Licello's book contained about 90 of unnecessary verbiage(The Story Line. . .The Plot).
The Money Spinner contained the 10%. . .The Guts. . .and was a very effective instrument to make me jump on the Chuck Chakripani Bandwagon.
IAM Done With It.
Maybe.
Trying to derive a negative adjustment to PC in order to keep the internals of an AIM program in line with the action taken (Stop Loss execution) is a reasonable concept IMHO.
Perhaps it is but I have not understood how this PC-related issue is relevant for a Stop Loss.
As I have shown to myself the negative PC for selling lowers the PC so that you can even get to the point that the Trade=0 after a Sell, so that the next Sell comes earlier if the prise rises and comes later if the price drops again.
If it is you AIM to stop selling if the Trade signal = 0, or near it, and to see this as a signal to Dump all the equity in a Stop Loss then I see your point. . .but that was clear in earlier discussions, or at least it is generally clear for any AIMing effort.(1)
I am groping to understand you.
If you use a negative PC adjustment for a Buy you lower the PC so that Trade=0, or nearly so, then if the price keeps dropping the next Buy is delayed. . .The Brake is applied! That was the point I made earlier. . . .didn’t I?
If the price reverses however your selling-off of the shares would be earlier than with the positive PC-adjustment.
So in either case the purpose of the different tactic has its negative counterpart if you let AIM do all the thinking for you and if you do not interfere with the Auto-IM at the very moment that the price does something different than what you had planned for.
I maintain my recommendation to always interfere with AIM if it does not what you want it to do:
Ignore the AIM Advice and do something you like better.
In the end you no longer need your AIM. . everything is in your head.
**************************
(1) After a bit if thinking I thought: "It could well be that what you AIM for is something with a 2*pi-shift":
Is it your intention that after you have decided that a Stop Loss is necessay, and have executed it, that you want to "fiddle" with your AIM parameters to make it reflect what you have done????
For example, after a Stop Loss it is "as asy as making Apple Pie" to fudge the PC-update factor to give you a Huge Sell Advice that reflects the Stop Loss.
Is that what you AIM for?
That is what we do in engineering all the time. . .we create Fudge Factors to theoretical equations to make the result that comes out of it be in line with "what happens" in reality.
It simply accounts for out ignorance about the real processes by which things happen, in AIMing you say that you have no way of knowing what will happen, so the "fudging" after the event has no purpose.
Hi Larry,
Actually AI does allow you to adjust the PC allocation from 0% to 100%. So you can set the PC increment to 0% and the PC will never change with a buy. I have been playing with it with some interesting results.
I understand that from previous posts. On this I wonder if you can enter a negative number for the PC- update % ???? It would do wonders as a Brake on the Cash Burning for falling prices! It’s a Filter!
When the prices move within a trading range you can use an PC-update % of say 60 or 70%. This would increase the buying and the profit creaming with the right setting. . .the cash would be exhausted at the bottom and the profit would be taken at the top.
As soon as the price drops out the bottom limit you set the PC-update to say –30% 05 –40% and the Brake is applied. The trade advice will give large buys and if you judge it as opportune you execute it with Extra Cash. . .it's is Judgement Call. . if you do not feel right about it(use a little study) then sit tight or get out. . .the Reserve = 0 almost anyway. In any cast one should NEVER execute a Trade Advice if one is not sure he is doing the “right thing”. . this means to me that in any case one should be convinced he wants to invest the Advised Trade Amount IF he does it . . .that is no different than asking oneself:
“Would I start a New AIM Portfolio at this point?”.
If the answer is ”yes” then simply invest the extra cash, otherwise don't and maybe even better, get out.
If the price reverses then AIM will have a healthy dwell factor to delay the selling because of the high PC value. . .So this is also a healthy Filter for sell delays, so the last buy at the low price will generate a good profit if price keeps rising. . .so this provides the simple filters everyone is seeking, but you have to be prepared to interference with AIM when the time is ripe: . . readjusting the PC-update % to other values if the price behaviours changes into a trading range pattern.
Maybe your interesting results are a bit like I described?
Using a negative PC-update for the selling can be equally effective in delaying the Sell-Offs. . .The lower PC causes the Sell to come at a much higher price. . . This sounds like a Vealie to me but I have never tried to dive into Vealies deep enough to make this hunch stick. . .My practice is(was I should say!) that if I felt the Price would continue to rise I would simply ignore the Sell Advice and let the profit Run. . .I am the Filter.
If you can translate these judgements. . .to trade or not to trade. . . to some extend into the settings of the PC-update % then this automates the Portfolio Management. . .the program would still deserve the name AIM, and if the price behaviour changes then you change the settings again! This way you can credit yourself with better than average yield or blame yourself for having made the wrong decisions.
<Mr L went through hell to get to that choice. Runaway loops and all sorts until he recalled a 2X 1-50 licence plate>
As I read it that Hell was not such a Hot Place at all for him, more like a Waiting Room. He just had no idea to how to handle the problem and was beating about the bush on it when he happen to run into an old car, or tractor, with these plates on it in a old barn and then he used that without doing any analysis on it to prove if it was an optimum amount. . .if he did I must have had a blackout
The Lichello Flaw crept in the moment he decided on the 50% Update without adding a compensation factor to set the Trade=0 after a trade. In the end I have read that many an AIMer complained that the 50% was far to high and caused a too high a Cash Burn Rate.
Thanks, but I don't think AI can do a PC reduction.
It should be easy to adapt an AIM Excel spread to ad a PC-update for the Sells with the 50%-update and simply reduce the 50% to 40 of 30% for the Buys PC- Update by using a negative factor.
This is a piece of cake!
On the other hand I could change the Trade Advice in a VORTEX AIM to
Trade = (PC-(1+s)*V) . . .s=SAFE. . .and set the Vortex AIM aggression factors to 0 and set the
PC Updates
PC2=PC1 + a*Buy
PC2=PC1 + b*Sell
You can then select a or b to be any fraction you like to see what happens with various Data sets and different values of a and b.
Setting b=0 and a=0.5 would make the spread a Standard AIM BTB Spread. . .The Residual Buys and Residual Sells would automatically be eliminated too
If I can not sleep one night I might even be tempted to do it in 10 minutes or so.
I will Copyright it and if it become a hot like Hot Cakes I will put in on my Order Form and Call it VORTEX HOT-AIM
.
.
.
Darn!
Now I have disclosed the secret and anyone can make a HOT-AIM