InvestorsHub Logo
icon url

JMP23834

08/08/19 4:41 PM

#43826 RE: OldAIMGuy #43825

Maybe the difference is the Min value. I see that as a % of PC not a % of shares. I guess both could work depending on why you use a min.
icon url

OldAIMGuy

08/09/19 8:14 AM

#43830 RE: OldAIMGuy #43825

Re: Next Buy and Sell Targets for AIM................

BTW, Those were the formulae I composed back in 1989 for coming up with
the new AIM target prices. They were then used in a "Lotus 123"
spreadsheet until the Newport software was developed where they were
used again. I keep my hand written notes on such milestones. I even
wrote to Mr. Lichello about them but never had a reply, unfortunately.

The main difference between the raw formulae and the ones in the
software were that Bob Norman (co-author of the Newport software) built
in rounding functions so it didn't give answers for fractional shares,
only whole numbers. Bob wrote a lot of clever software back then:
parking ticket aging software for municipalities, insurance rating
software that gave him approximate customer cost for property and
casualty insurance along with auto insurance instead of having to wait
for the insurance companies to send out a paper version and other
goodies.

I still use Newport every week to keep my AIM on target. Unfortunately
it doesn't run directly on newer computers, so I keep an ancient XP
laptop in good condition to operate just that software. I know several
others who have bought reconditioned XPs just to run Newport. Newport's
the "Dragnet" version of AIM spreadsheets - "Just the Facts, Ma'am." It
does give histograms of 3 years at a glance in both line and stacked bar
formats, which today is easy in spreadsheets, but back in the '90s was
more challenging.

Other odd formulas I composed had to do with carbureted engines to
calculate expected mileage. Another was used to calculate the miles
needed to be driven to repay the expense of any modification that would
improve mileage. It could also be used to calculate the number of miles
needed to be driven to pay for the difference between one's current
vehicle and buying a new vehicle of higher mileage efficiency. (this was
back in the '70s during the "Fuel Crisis") Both of those were published
in Road & Track Magazine in their "Technical Correspondence" section
after they confirmed they worked.

My, how time flies!
Tom
icon url

Adam

08/09/19 12:07 PM

#43832 RE: OldAIMGuy #43825

Re: Hold zone calculations. I'm using the Bare Bones Spreadsheet so my formulas use the terminology/columns from that. I just added a couple of columns to compute these

Buy Target= (PC-Min$Trade)/(#shares * (1+BuySafe/100))
Sell Target= (PC+Min$Trade)/(#shares * (1-SellSafe/100))

I also work out the Hold zone % = (SellTarget - BuyTarget)/((SellTarget + BuyTarget)/2) * 100

For minimum trade I use a dollar value rather than a number of shares. Since the spreadsheet uses both I disable the min number of shares by setting that to a small number like 10 so it never has any effect. Most of my AIM programs have a min trade $ of at least $2K as I feel that very small trades are not worth the work involved.

Adam