A.I.M. Users Bulletin Board

[Mr Core Position]

Jack -- AIM calculator Next Sell.

The calculator just calculates next buys and sells for individual prices or a range of prices. For record keeping, I just use a spreadsheet.

From the last line of the spreadsheet I enter into the calculator, manually, the stock symbol (optional), the present quantity held, the PoCo, and the cash held (optional - used if setting the minimum order as a percent of total account value -- stock + cash).

Also, from the spreadsheet I enter in the NET price of the last
transaction. That last transaction could, naturally, be either a buy or a sell.

Refer to screenshot
http://home.earthlink.net/~beand/graphics/aim_rangecalcex.gif

And a range calculation printout sample at
http://home.earthlink.net/~beand/cpt/aim_rangecalcex.txt

You will notice on the screenshot and the printout that, for illustration, I have set the min BUY order for 5% of PoCo and the min SELL order for a fixed $125.00.

Along with the SAFE settings, the minimum SELL price AIM will allow in this example is $7.32 (shown right above the "No Transaction Zone" legend in the printout. aka "Hold Zone".) The quantity to sell is 19. While the transaction price would be $7.32, the NET price you would get, considering commission of $10.01, would be 6.793158.

In the example, the previous net price entered is $6.25.
The percent NET price difference of 8.69% is shown in the next to last column of the $7.32 transaction price row.

The net DOLLAR difference of $10.32 is shown in the last column of the row. (($6.793158 - $6.25) * 19 shares).

That $10.32 COULD be a profit or not -- what if the last transaction was also a sell -- what if the last transaction was a buy of only 18 shares, then you got 1 share unaccounted for.

F' the IRS.

By the way, I would not myself take that $7.32 transaction price transaction -- I would scan up the last two columns for the first transaction that meets both my personal percentage and dollar criteria.

Arbitrarily, for this example, if you wanted 10% that would mean a price of at least $7.37. And if you wanted at least $50, that would mean a price of $7.79.

NOTE: You can enter in ANY price you want for the last NET price. So you could enter in the net price for some transaction other than the very last one. That does NOT affect the Next Buy/Sell Calculations based on the quantity held and PoCo. It will effect, naturally, the last two columns.